question In SQL Server what is the purpose of the SQL Server VARBINARY data type

In Oracle, what is the purpose of the MERGE statement?

A. Combine rows from two or more tables
B. Update, insert, or delete data based on a condition
C. Sort the result set
D. Join multiple tables

What is the purpose of the SQL AVG() function?

A. Find the average value
B. Find the total number of rows
C. Find the highest value
D. Find the lowest value

Which command is used to select all columns from a table named "employees"?

A. SELECT * FROM employees;
B. SELECT ALL FROM employees;
C. SHOW COLUMNS FROM employees;
D. DISPLAY employees;

Which SQL function is used to find the total number of rows in a table?

A. COUNT()
B. TOTAL()
C. SUM()
D. ROWCOUNT()

What is the purpose of the SQL TRUNCATE TABLE statement?

A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL values

Which statement is used to remove all records from a table in MySQL?

A. DELETE FROM table;
B. REMOVE * FROM table;
C. TRUNCATE TABLE table;
D. DROP TABLE table;

In MySQL, what is the purpose of the LOAD DATA INFILE statement?

A. Load data from a file into a table
B. Load data from a table into a file
C. Load data from one database to another
D. Load data from multiple tables

What is the purpose of the Oracle SYS_GUID() function?

A. Generate a random globally unique identifier
B. Concatenate multiple columns
C. Calculate the average value
D. Round numeric values

What is the purpose of the Oracle UNION operator?

A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Sort the result set
D. Join multiple tables

What is the purpose of the Oracle TRUNCATE TABLE statement?

A. Remove specific records
B. Remove all records and reset auto-increment
C. Remove duplicate records
D. Remove NULL values

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise