SQL Quiz-2

Which of the following SQL commands is used to create a new table?

• INSERT

• CREATE

• ALTER

• SELECT

2. What does the ALTER command do in SQL?

• Modifies data in a table

• Modifies the structure of a table

• Deletes records

• Adds new data rows

Which of the following commands will delete a table and all its data permanently?

• DROP

• DELETE

• TRUNCATE

• REMOVE

Which DDL command can be used to remove all data from a table but keep its structure?

• DELETE

• DROP

• TRUNCATE

• CLEAR

What does the UPDATE command do in SQL?

• The UPDATE command modifies existing records in a table.
• The UPDATE command deletes records from a table.
• The UPDATE command creates new tables in a database.
• The UPDATE command retrieves data from a table.

Which SQL command removes specific rows from a table?

• DELETE
• INSERT
• UPDATE
• SELECT

What does the WHERE clause do in a SELECT query?

• Limits the number of columns

• Changes column values

• Filters rows based on conditions

• Deletes rows

Which command is used to insert new data into a table?

• INSERT

• ADD

• UPDATE

• PUSH

Which of the following statements is TRUE regarding SQL commands and their effects on data and structure?

• TRUNCATE TABLE is a DML command that logs individual row deletions

• ALTER TABLE belongs to DML and is used to update column values based on conditions

• SELECT queries do not modify data and are classified under DQL, which retrieves data without affecting database state

• DELETE FROM table_name is a DDL command that removes the table structure permanently

Which of the following statements are FALSE regarding SQL command types?

(Choose all that apply)

• DROP TABLE is a DDL command that removes both data and table structure permanently

• SELECT is a DML command used to fetch records from a table

• UPDATE is a DML command used to modify existing records in a table.

• CREATE is a DML command used to create tables

• TRUNCATE is a DDL command that deletes all rows without logging each deletion