question Which SQL Server statement is used to add a new row to a table

Database

Which SQL Server statement is used to add a new row to a table?

A. INSERT INTO
B. ADD ROW
C. NEW ROW
D. CREATE ROW

'INSERT INTO' is used to add a new row to a table in SQL Server.

Which MySQL statement is used to delete a database?

A. DELETE DATABASE
B. DROP DATABASE
C. REMOVE DATABASE
D. DESTROY DATABASE

Which MySQL command is used to retrieve the definition of a table?

A. DESCRIBE
B. SHOW TABLE
C. DISPLAY TABLE
D. INFO TABLE

Which SQL statement is used to grant specific privileges to a user in MySQL?

A. ALLOW PRIVILEGES
B. GRANT PRIVILEGES
C. GRANT
D. ALLOW ACCESS

Which SQL 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 LIMIT clause?

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

In MySQL, which type of index allows only unique values and nulls are considered distinct?

A. PRIMARY KEY
B. UNIQUE
C. FULLTEXT
D. INDEX

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

A. MAX()
B. HIGH()
C. TOP()
D. HIGHEST()

What is the purpose of the SQL HAVING clause?

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

In MySQL, which storage engine supports transactions and ACID properties?

A. MyISAM
B. InnoDB
C. MEMORY
D. ARCHIVE

What is the purpose of the SQL DISTINCT keyword?

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