question In Oracle what is the purpose of the MERGE statement

Database

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

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

In MySQL, what is the purpose of the SHOW TABLES statement?

A. Display the structure of a table
B. Show the list of tables in a database
C. Display the content of a table
D. Show the indexes of a table

Which SQL Server statement is used to create a new table in a database?

A. CREATE TABLE
B. NEW TABLE
C. ADD TABLE
D. INSERT TABLE

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

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

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

What is the purpose of the SQL Server DISTINCT keyword?

A. Sort the result set
B. Filter rows
C. Eliminate duplicate values
D. Combine rows into groups

What is the purpose of the SQL Server SELECT TOP clause?

A. Filter rows
B. Sort the result set
C. Limit the number of rows returned
D. Join multiple tables

Which SQL function is used to find the current user in MySQL?

A. GETUSER()
B. CURRENT_USER()
C. USER()
D. GET_CURRENT_USER()

Which SQL statement is used to create a new table in a database?

A. CREATE TABLE
B. NEW TABLE
C. ADD TABLE
D. INSERT TABLE

Which SQL function is used to find the lowest value in a column?

A. MIN()
B. LOW()
C. BOTTOM()
D. LEAST()

In SQL Server, what is the purpose of the HAVING clause?

A. Filter rows
B. Sort the result set
C. Filter groups
D. Combine rows into groups