Subqueries Quiz

Which key is used to represent relationships between tables?

• Foreign key

• Primary key

• Secondary key

• Tertiary key

What is the relationship between tables in a database called?

• Foreign key relationship

• Primary key relationship

• Unique key relationship

• Composite key relationship

In the given SQL query, what is being selected?

SELECT supplierID

FROM products

WHERE productName LIKE '%bread%';

• productName

• supplierID

• productID

• customerID

What is the purpose of the '%' symbol in the SQL query?

SELECT supplierID

FROM products

WHERE productName LIKE '%bread%';

• To represent a wildcard for any sequence of characters

• To denote a comment

• To specify a column name

• To indicate a table name

What type of data is being queried in the example?

SELECT *

FROM suppliers

WHERE id IN ( SELECT DISTINCT supplierID

FROM products

WHERE productName LIKE '%bread%' );

• Customer data

• Supplier data

• Order data

• Employee data

What would be the result if the 'LIKE' clause was changed to 'NOT LIKE' in the query?

SELECT DISTINCT supplierID

FROM products

WHERE productName LIKE '%bread%';

• It would select all products

• It would select products not containing 'bread'

• It would select products containing 'bread'

• It would cause an error

What does the SQL function MIN() return?

• The maximum value in a column

• The average value in a column

• The minimum value in a column

• The sum of values in a column

What SQL clause is used to exclude certain values in a query?

• IN

• NOT IN

• EXCLUDE

• OMIT

What does the SQL statement "SELECT * FROM products" do?

• Selects specific columns from the products table

• Selects all columns from the products table

• Deletes all products

• Updates all products

What does the "NOT IN" clause do in the SQL query?

• Includes specified values

• Excludes specified values

• Updates specified values

• Deletes specified values