Free Printable HAH Diagnostic Quiz

Worksheets

HAH Diagnostic Quiz

Total questions: 20

Worksheet time: 10mins

Name

Class

Date

What word is missing from the line below?
SELECT *
_______ CUSTOMER;

FROM

WHERE

SELECT

ORDER BY

What is the purpose of *?

Selects ALL fields from the table

Selects only the first field in the table

Selects the last field in the table

Shows only the first row in the table

Return only the customers who have ER anywhere in their last name.

last_name LIKE "%er%"

last_name = "%er"

last_name = "%er%"

last_name LIKE "%er"

What is a stored procedure in the context of databases?

A mechanism to create backup copies of a database

A table that holds temporary data during a session

A data structure used to store complex data types

A parameterized query that is stored in the database for reuse

Which of the following statements accurately describes a one-to-many relationship in a database?

A single record in one table corresponds to multiple records in another table.

A single record in one table corresponds to a single record in another table.

Multiple records in one table correspond to multiple records in another table.

Multiple records in one table correspond to a single record in another table.

What is the purpose of the CASCADE DELETE constraint in a database?

To automatically update related records when a primary key value is modified

To prevent the deletion of a record if it has related records in other tables

To automatically delete related records when a primary key value is deleted

To ensure that foreign key values are unique within a table

What is the correct order of clauses?

SELECT, FROM, ORDER BY, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, WHERE, FROM, ORDER BY

WHERE, FROM, SELECT, ORDER BY

Which of the following is a valid SQL aggregate function?

DISTINCT

CONCATENATE

AVERAGE

EXTRACT

What is the purpose of a primary key-foreign key relationship in a database?

To enforce referential integrity between related tables

To store complex data structures in a single table

To optimize database performance by indexing columns

To simplify data retrieval using JOIN statements

10.

Which clause allows you to SORT data?

ORDER BY

WHERE

FROM

HAVING

11.

When you select data from 2 tables, you are creating a ________.

JOIN

PRIMARY KEY

FOREIGN KEY

INDEX

12.

What happens if you forget to join two tables together using a WHERE clause?

CREATE CARTESIAN PRODUCT

GET A SYNTAX ERROR

0 RECORDS RETURNED

DELETE ALL

13.

True/False?
SQL table names are case sensitive

True

False

14.

How do you fix an ambiguous error in your SQL statement?

Use long form of field name

Remove that field name from the query

Require unique fieldnames for all

No such thing as ambiguous error

15.

Use which clause to FILTER data?

WHERE

ORDER BY

FROM

HAVING

16.

What represents no value?

NULL

" "

N/A

17.

SELECT MAX(price)
FROM PRODUCT
will return how many rows?

As many rows that are in the table

18.

Which word allows you to add more than one filter to a SQL query?

AND

BETWEEN

EQUALS

19.

To return strings that match a wildcard value, use which word in your filter?

EQUALS

BETWEEN

20.

Use what to remove spaces from the beginning and end of the string value?

TRIM

CROP

NOSPACE

SPACE

100 %

HAH Diagnostic Quiz

Total questions: 20

Worksheet time: 10mins

Similar Resources on Wayground