Structured Query Language (SQL) Quiz

What does SQL stand for?

• Systematic Query Language

• Structured Query Language

• Standard Query Language

• Structured Question Language

What does a declarative language mean in the context of SQL?

• It expresses how something needs to be achieved

• It expresses what needs to be achieved

• It expresses when something needs to be achieved

• It expresses where something needs to be achieved

Which command is used to insert new records into a database table?

• append data

• create record

• insert into

• add record

What is the command used to delete entire tables in SQL?

• remove table

• erase table

• drop table

• delete table

What is the purpose of the 'join' keyword in SQL?

• To delete records from a table

• To modify existing records

• To combine data from two or more tables

• To create new tables

Which command is used to change the data type of a field in a table?

• update field

• alter table

• change type

• modify field

What is the purpose of the 'order by' command in SQL?

• To filter records based on a condition

• To update existing records

• To order the output in ascending or descending order

• To join multiple tables

What is the purpose of the 'like' keyword in SQL?

• To select records based on a pattern

• To join multiple tables

• To insert new records into a table

• To delete records from a table

Which command is used to add a new field to an existing table in SQL?

• alter table

• append column

• insert field

• add field

What is the purpose of the 'update' command in SQL?

• To join multiple tables

• To modify existing records

• To delete records from a table

• To insert new records into a table