CRT Database Management & SQL 2

Question 1

A tobacco retailer wants to find all cigar products priced between $10 and $50. Which SQL clause correctly filters this range?

Accepted Answer

WHERE price BETWEEN 10 AND 50

Answer

The BETWEEN operator in SQL is inclusive and correctly selects values within a specified range.

Question 2

Which SQL statement is used to add a new tobacco product record to the inventory table?

Accepted Answer

INSERT INTO inventory VALUES (...)

Answer

INSERT INTO is the correct SQL command for adding new rows to a table.

Question 3

A retail system has a 'sales' table and a 'products' table. What SQL operation combines data from both tables based on a common product_id?

Accepted Answer

JOIN

Answer

A JOIN operation links rows from two tables based on a related column such as product_id.

Question 4

Which SQL aggregate function would a tobacco shop manager use to count the total number of transactions in a sales table?

Accepted Answer

COUNT()

Answer

COUNT() returns the number of rows matching specified criteria in a table.

Question 5

A tobacconist database has duplicate customer email entries. Which SQL keyword removes duplicate results from a SELECT query?

Accepted Answer

DISTINCT

Answer

SELECT DISTINCT eliminates duplicate rows from query results.

(CRT) Certified Retail Tobacconist Practice Test