SQL SELECT Command MCQ SELECT Statement Practice Questions

Direction: Choose the correct option

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

A. SELECT

B. GET

C. RETRIEVE

D. FETCH

Direction: Choose the correct option

SELECT * FROM customers;

What does the * represent in this query?

A. All columns

B. All tables

C. All rows

D. All databases

Direction: Choose the correct option

How do you select only unique values from a column?

A. SELECT UNIQUE

B. SELECT UNIQ

C. SELECT DIFFERENT

D. SELECT DISTINCT

Direction: Choose the correct option

SELECT city FROM customers;

What will this query return?

A. Only customers named city

B. All columns from customers

C. Only the city column

D. The entire table

Direction: Choose the correct option

How do you give a temporary name to a column in the result?

A. Using ALIAS keyword

B. Using AS keyword

C. Using NAME keyword

D. Using RENAME keyword

Quipoin Menu