Structured Query Language (SQL) Multiple Choice Questions (MCQ) Online Test #2

What is the purpose of a SQL transaction?

Which of the following is considered a fundamental SQL command for retrieving data?

What is the primary purpose of the DATE data type in SQL?

What is the purpose of the WHERE clause in a SELECT statement?

How do you retrieve all columns from a table named Employees?

How do you delete all rows from the Orders table but keep the table structure intact?

What happens when you execute the DROP TABLE statement on a table with foreign key constraints?

Which SQL clause is commonly used to filter the results of a subquery?

How do you specify descending order for a column in the ORDER BY clause?