SQL Basics

What does SQL stand for?

• Structured Query Language

• Simple Query Language

• Structured Question Language

• Standard Query Language

• Semantic Query Language

Which SQL statement is used to select data from a database?

• SELECT

• UPDATE

• DELETE

• INSERT

• MODIFY

In SQL, which clause is used to filter records?

• WHERE

• SELECT

• FROM

• ORDER BY

• LIMIT

What does CRUD stand for in the context of databases?

• Create, Read, Update, Delete

• Create, Replace, Update, Delete

• Check, Retrieve, Update, Delete

• Create, Revert, Undo, Delete

• Copy, Replace, Update, Delete

Which SQL statement is used to insert new data into a database?

• INSERT INTO

• ADD NEW

• PUT

• CREATE

• UPDATE

What keyword is used to select all columns from a table in SQL?

• *

• ALL

• #

• %

• $

What is the main purpose of the SELECT clause in SQL?

• To specify the attributes to be shown in the result table

• To specify the source tables to access

• To define the condition for row selection

• To delete data from the table

• To count the number of rows

Which SQL command is used to delete a table?

• DROP TABLE

• DELETE TABLE

• REMOVE TABLE

• TRUNCATE TABLE

• ERASE TABLE

What does the WHERE clause do in SQL?

• Specifies the selection condition for rows

• Specifies the order of the output

• Specifies the table from which to retrieve data

• Joins two tables together

• Sorts the output

Which of the following SQL aggregate functions returns the number of selected rows?

• COUNT(*)

• SUM()

• AVG()

• MIN()

• MAX()