Data Engineering Session-2 Quiz

What does DDL stand for in SQL?

• Data Development Language

• Data Description Language

• Data Definition Language

• Data Design Language

Which command is used to create a new table in SQL?

• UPDATE

• INSERT

• CREATE

• DELETE

What is the purpose of the TRUNCATE TABLE statement in SQL?

• Delete all data from a table while keeping its structure

• Delete specific rows from a table

• Update existing data in a table

• Add new columns to a table

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

• TRUNCATE

• ALTER

• DROP

• CREATE

What is the purpose of the INSERT command in SQL?

• Insert new data into a table

• Update existing data in a table

• Create a new table

• Delete data from a table

What does the UPDATE command do in SQL?

• Update existing data in a table

• Insert new data into a table

• Create a new table

• Delete all data from a table

Which keyword is used to specify that only unique rows should appear in the result set in SQL?

• UNIQUE

• FILTER

• DISTINCT

• SINGLE

What is the purpose of SQL aliases?

• To make column names more readable

• To delete data from a table

• To create new tables

• To filter rows in a table

Which comparison condition is used to check if two values are equal in SQL?

• !=

• >

• ==

• <>

• =

What is the purpose of the T-SQL CASE expression?

• To delete rows from a table

• To join tables in a query

• To return a single value based on conditions

• To control the flow of a query