question Which SQL Server statement is used to change the value of an existing record in a table

Database

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

'UPDATE' is used to change the value of an existing record in a table in SQL Server.

In Oracle, what is the purpose of the GROUP BY clause?

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

What is the purpose of the SQL Server RAISEERROR statement?

A. Suppress errors in a query
B. Display a custom error message
C. Count the number of errors in a query
D. Create a temporary error table

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

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

Which Oracle statement is used to grant all privileges to a user?

A. GRANT ALL PRIVILEGES
B. GRANT FULL ACCESS
C. GRANT SUPERUSER
D. GRANT ALL RIGHTS

Which Oracle statement is used to create a sequence?

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

What is the purpose of the SQL IN operator?

A. Filter rows based on a range
B. Filter rows based on a list of values
C. Sort the result set
D. Join multiple tables

Which SQL Server statement is used to add a new column to an existing table?

A. ADD COLUMN
B. MODIFY COLUMN
C. INSERT COLUMN
D. CHANGE COLUMN

Which SQL statement is used to add a new column to an existing table?

A. ADD COLUMN
B. MODIFY COLUMN
C. INSERT COLUMN
D. CHANGE COLUMN

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

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