Database MCQS - QUESTION DETAILS

In SQL Server, 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

The MERGE statement is used to update, insert, or delete data based on a condition in SQL Server.

Similar Questions

Which Oracle data type is used to store large text values?






In Oracle, what is the purpose of the HAVING clause?






In SQL Server, what is the purpose of the LIKE operator?






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






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






In Oracle, what is the purpose of the JOIN clause?






What is the purpose of the Oracle TRUNCATE TABLE statement?






What is the purpose of the Oracle DUAL table?






In Oracle, which data type is used to store fixed-length character strings?






Which SQL Server statement is used to remove a table from a database?