Database Fundamentals - Lec2 Quiz

What does DDL stand for?

• Data Development Language

• Database Description Language

• Data Design Language

• Data Definition Language

Which command is used to create a new table?

• TRUNCATE

• DROP

• CREATE

• ALTER

What is the purpose of the TRUNCATE command?

• Delete specific data from a table

• Delete all data from a table while keeping its structure

• Add new columns to a table

• Update existing data in a table

Which command is used to add or drop columns in an existing table?

• INSERT

• ALTER

• DROP

• CREATE

What is the purpose of the INSERT command?

• Delete data from a table

• Create a new table

• Update existing data in a table

• Add new rows of data to a table

What does the UPDATE command do?

• Delete all data from a table

• Create a new table

• Update existing data in a table

• Add new columns to a table

Which keyword is used to display unique rows in a query result?

• ALL

• IN

• DISTINCT

• LIKE

What does the LIKE keyword allow you to do?

• Match any string with pattern

• Display unique rows

• Delete data from a table

• Perform arithmetic operations

Which logical condition is used to combine multiple conditions where all of them must to be true to apply them?

• OR

• AND

• BETWEEN

• NOT

What is the purpose of SQL aliases?

• To give a table or column a temporary name

• To delete data from a table

• To update existing table name

• To add new columns to a table