question What is the purpose of the SQL Server CROSS APPLY operator

What is the purpose of the SQL Server PIVOT 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

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

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

Which SQL Server statement is used to create an index on a table?

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

In SQL Server, what is the purpose of the CASE statement?

A. Filter rows based on a condition
B. Sort the result set
C. Combine rows into groups
D. Perform conditional logic in a query

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

In SQL Server, what is the purpose of the SQL Server XML data type method value()?

A. Extract a single value from an XML string
B. Combine multiple XML values
C. Concatenate XML strings
D. Validate XML structure

In MySQL, what is the purpose of the DESC keyword in an ORDER BY clause?

A. Sort in descending order
B. Specify a description
C. Sort in ascending order
D. Display columns

Which MySQL statement is used to update values in a table based on a condition?

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

What is the purpose of the SQL Server TRY...CATCH block?

A. Execute a set of statements in a loop
B. Handle exceptions and errors in a controlled manner
C. Define a cursor for record processing
D. Create a temporary table

In MySQL, what is the purpose of the COUNT() function with DISTINCT?

A. Count all rows
B. Count only distinct rows
C. Count rows based on a condition
D. Count rows in a specific column

Database MCQS - QUESTION DETAILS

Similar Questions

General

Subject Wise