RDBMS_Unit4

What does SQL stand for?

• Structured Question Language

• Standard Query Language

• Structured Query Language

• Sequential Query Language

Which of the following is a DDL command?

• SELECT

• INSERT

• UPDATE

• CREATE

Which SQL command is used to delete a table structure but not its data?

• DROP

• DELETE

• TRUNCATE

• ALTER

Which command is used to modify an existing table by adding/removing columns?

• CREATE

• ALTER

• INSERT

• DELETE

Which command is used to remove all records from a table but keep the structure?

• DELETE

• DROP

• TRUNCATE

• REMOVE

Which of the following is a DML command?

• CREATE

• ALTER

• INSERT

• DROP

The SELECT statement is used for:

• Modifying data

• Deleting data

• Retrieving data

• Creating tables

Which keyword is used to retrieve unique records in a SELECT query?

• DISTINCT

• UNIQUE

• DIFFERENT

• FILTER

The WHERE clause is used to:

• Filter records

• Group records

• Sort records

• Delete records

The ORDER BY clause is used to:

• Filter results

• Sort results

• Modify table structure

• Insert new rows