SQL SELECT Statement Quiz

Which SQL keyword is used to specify the table from which to retrieve data?

• WHERE

• SELECT

• FROM

• JOIN

What is the function of the SQL keyword 'SELECT'?

• To modify data

• To retrieve data

• To delete data

• To create a table

What is the effect of a WHERE clause on a SQL query?

• It increases the query speed

• It limits the data affected by the query

• It changes the database structure

• It creates new tables

What does the comparison operator "=" mean?

• Not equal to

• Less than

• Equal to

• Greater than

Which operator means "greater than"?

• <=

• >=

• >

• <

What is the sequence used for strings in SQL?

• Numeric

• Alphabetical

• Random

• Reverse alphabetical

In the SQL query, which table is being queried?

SELECT *

FROM customers

WHERE contactLastName < ‘C';

• orders

• customers

• products

• employees

Which of the following is a correct SQL statement to select all data from a table?

• SELECT * FROM table_name;

• SELECT ALL FROM table_name;

• SELECT DATA FROM table_name;

• SELECT COLUMNS FROM table_name;

In SQL, what does the statement "SELECT * FROM customers" do?

• Selects specific columns from the customers table

• Selects all columns from the customers table

• Deletes all data from the customers table

• Updates all data in the customers table

In the SQL query, what does the asterisk (*) represent?

• Select all columns

• Select a specific column

• Select all rows

• Select a specific row