MSSQL Server Quiz

What does SQL stand for?

• Structured Query Language

• Standard Query Language

• Simple Query Language

• Structured Question Language

Which of the following is NOT a category of SQL?

• Data Control Language (DCL)

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Retrieval Language (DRL)

What is the purpose of the Data Definition Language (DDL)?

• To define and manage database objects

• To manipulate data within the database

• To control user access to the database

• To query data from the database

Which command is used to delete an entire table in SQL?

• DELETE

• DROP

• REMOVE

• ALTER

What does the SQL command 'INSERT' do?

• Retrieves records

• Modifies existing records

• Deletes a record

• Creates a new record

Which SQL command is used to grant privileges to a user?

• ALLOW

• REVOKE

• DENY

• GRANT

What is the purpose of the SQL WHERE clause?

• To filter records based on conditions

• To sort the result set

• To group records

• To join tables

Which operator is used to select values within a given range?

• AND

• BETWEEN

• IN

• LIKE

What does the SQL SELECT DISTINCT statement do?

• Returns values based on a condition

• Returns values in ascending order

• Returns only unique values

• Returns all values from a table

Which SQL command is used to sort the result set?

• SORT

• ORDER BY

• GROUP BY

• FILTER