Motivation

What does SQL stand for?

• A. Sequential Query Language

• B. Structured Question Language

• C. Structured Query Language

• D. Simplified Query Logic

Which of the following is a type of SQL command?

• D. All of the above

• C. Data Control Language

• B. Data Manipulation Language

• A. Data Definition Language

What is the purpose of the SQL SELECT statement?

• A. To insert data into a table

• B. To retrieve data from a database

• D. To delete data from a table

• C. To update existing data

What command is used to remove a table from the database?

• A. DELETE

• B. ERASE

• C. DROP

• D. REMOVE

Which SQL statement is used to update existing records in a table?

• A. MODIFY

• B. UPDATE

• C. CHANGE

• D. ALTER

Which SQL category does the GRANT command belong to?

• A. DDL

• B. DML

• C. DCL

• D. TCL

Which of the following commands is used to save changes permanently in a transaction?

• A. COMMIT

• B. SAVEPOINT

• C. ROLLBACK

• D. REVERT

Which of the following is a DML command?

• A. CREATE

• B. INSERT

• C. GRANT

• D. COMMIT

The DELETE command removes a table structure from the database.

• TRUE

• FALSE

What will the following query do?

SELECT * FROM Students;

• A. Selects only names from the Students table

• B. Deletes all records from the Students table

• C. Selects all columns and rows from the Students table

• D. Updates the Students table