Database Management & SQL Flashcards

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

Answer: WHERE price BETWEEN 10 AND 50

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

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

Answer: INSERT INTO inventory VALUES (...)

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

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?

Answer: JOIN

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

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

Answer: COUNT()

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

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

Answer: DISTINCT

SELECT DISTINCT eliminates duplicate rows from query results.

What does a PRIMARY KEY constraint ensure in a tobacco retail inventory database?

Answer: Each row has a unique, non-null identifier

A PRIMARY KEY constraint enforces uniqueness and non-null values for each record in a table.

Which SQL command permanently removes a tobacco product record from the inventory table?

Answer: DELETE FROM inventory WHERE id=5

DELETE FROM with a WHERE clause removes specific rows from a database table.