question What is the purpose of the SQL WHERE clause

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

Which SQL command is used to update data in a table?

A. UPDATE
B. MODIFY
C. CHANGE
D. SET

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

A. Concatenate multiple columns
B. Replace NULL values with a specified value
C. Calculate the average value
D. Concatenate multiple rows

In MySQL, what is the purpose of the AUTO_INCREMENT attribute?

A. Automatically increments the value of a column
B. Sets a column to a predefined value
C. Allows NULL values in a column
D. Adds a default value to a column

Which Oracle clause is used to add an index to an existing table?

A. ADD INDEX
B. CREATE INDEX
C. INDEX TABLE
D. ALTER INDEX

What is the purpose of the SQL Server XML INDEX option?

A. Index an entire XML column
B. Index specific elements or attributes in an XML column
C. Exclude XML columns from indexing
D. Disable indexing for XML columns

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 SQL Server statement is used to change the value of an existing record in a table?

A. MODIFY
B. CHANGE
C. UPDATE
D. SET

In Oracle, what is the purpose of the INTERSECT operator?

A. Combine rows from two or more tables
B. Rotate rows into columns based on values in a specified column
C. Find the common rows between two SELECT statements
D. Join multiple tables

What does the SQL INNER JOIN clause do?

A. Combines rows from two or more tables
B. Retrieves all rows from a table
C. Retrieves rows that have no matching rows in the other table
D. Excludes specified rows

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise