SQL Quiz

What does SQL stand for?

• Structured Question Language

• Standard Query Language

• Simple Query Language

• Structured Query Language

Which command is used to add data to a table in SQL?

• UPDATE

• INSERT

• SELECT

• DELETE

What is the purpose of the COMMIT command in SQL?

• To delete data from a table

• To save changes made to the database

• To retrieve data from a table

• To create a new table

Which of the following is a data manipulation command in SQL?

• CREATE

• INSERT

• ALTER

• DROP

What does the NOT NULL constraint do?

• Allows null values in a column

• Assigns a default value to a column

• Ensures all values in a column are unique

• Ensures that a column does not accept nulls

Which SQL command is used to remove a table from a database?

• REMOVE

• CLEAR

• DROP

• DELETE

What is a primary key in a database?

• A key that allows duplicate values

• A key used for indexing

• A key that can be null

• A unique identifier for a record in a table

How can you retrieve all columns from a table using SQL?

• SELECT tablename;

• SELECT ALL FROM tablename;

• SELECT COLUMNS FROM tablename;

• SELECT * FROM tablename;

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

• To specify the columns to retrieve

• To group the results

• To filter records based on a condition

• To sort the results

Which SQL function would you use to count the number of rows in a table?

• COUNT()

• ADD()

• SUM()

• TOTAL()