SQL 2 – Quiz | Divex Consult

1. Which SQL statement is used to add new records to a table? *

A) INSERT INTO

B) ADD RECORD

C) NEW ENTRY

D) CREATE ROW

2. What does the UPDATE statement do in SQL? *

A) Adds new records to a table

B) Modifies existing records in a table

C) Removes records from a table

D) Deletes the entire table

3. Why should you always use a WHERE clause with DELETE? *

A) Without WHERE, SQL will prevent deletion

B) It makes the query run faster

C) It is required to delete even one record

D) To specify which records to delete and avoid removing all rows

4. What is the purpose of the TRUNCATE command? *

A) Removes all records from a table but keeps its structure

B) Deletes specific rows from a table

C) Removes a database permanently

D) Modifies data in a table

5. How can you add multiple rows to a table in a single query? *

A) Using multiple INSERT INTO statements

B) Using a single INSERT INTO statement with multiple values

C) Using ADD MULTIPLE

D) Using INSERT ALL

6. What happens if you try to insert a record with a duplicate primary key? *

A) SQL allows duplicate primary keys

B) The new record replaces the old one

C) SQL throws an error and prevents the insertion

D) SQL automatically assigns a new primary key

7. What is the difference between DELETE and DROP? *

A) DROP and DELETE do the same thing

B) DELETE removes all data permanently

C) DELETE removes rows, while DROP removes the entire table

D) DROP is only used for clearing a table’s data

8. Which of the following SQL commands is used to modify the structure of a table? *

A) ALTER TABLE

B) MODIFY TABLE

C) UPDATE TABLE

D) CHANGE TABLE

9. What is the purpose of the REPLACE statement in SQL? *

A) To insert a new row or update an existing one if a conflict occurs

B) To modify data in an existing table

C) To remove specific records

D) To rename a table

10. Which SQL statement is used to remove specific columns from a table? *

A) REMOVE COLUMN

B) DELETE COLUMN

C) ALTER TABLE DROP COLUMN

D) TRUNCATE COLUMN

Structured Query Language(SQL)

SQL 2 – Quiz