SQL Basics Quiz

What does SQL stand for?

• Structured Question Language

• Simple Query Language

• Standard Query Language

• Structured Query Language

Which command is used to retrieve data from a database?

• SELECT

• UPDATE

• DELETE

• INSERT

What is an RDBMS?

• Random Database Management System

• Random Data Management System

• Relational Database Management System

• Relational Data Management System

Which of the following is NOT a SQL command?

• SELECT

• INSERT

• UPDATE

• PUSH

What is the purpose of the SQL WHERE clause?

• To create a new table

• To filter records

• To specify the database

• To delete records

Which SQL command is used to add new records to a table?

• ADD

• INSERT INTO

• UPDATE

• CREATE

What does the SQL command DELETE do?

• Updates records in a table

• Removes records from a table

• Creates a new database

• Removes a table

Which SQL function is used to count the number of rows?

• MIN

• AVG

• COUNT

• SUM

What is a primary key in SQL?

• A type of SQL command

• A unique identifier for a record

• A function to aggregate data

• A method to join tables

Which SQL command is used to modify existing records?

• MODIFY

• UPDATE

• CHANGE

• ALTER