Database Data Types & Key Constraints Quiz

1. What data type would you use to store a date like 2024-01-15?

VARCHAR

INT

DATE

TIMESTAMP

2. True or False: Referential integrity is maintained by FOREIGN KEY constraints to prevent orphaned records.

True

False

Submit

4. What is the main advantage of using a surrogate key instead of a natural key?

It requires less storage space

It is independent of business data and remains stable

It automatically prevents duplicates

It improves query speed

5. Which data type is best for storing whole numbers like employee IDs?

DECIMAL

FLOAT

INT

VARCHAR

6. True or False: A FOREIGN KEY must reference a PRIMARY KEY in another table.

True

False

Submit

8. Which of the following is a valid example of a composite primary key?

A single customer ID

Combination of order ID and product ID

An auto-generated number

A customer's email address

9. True or False: CHAR and VARCHAR both store text, but VARCHAR uses variable length storage.

True

False

Submit

11. Which data type is best suited for storing a customer's email address?

VARCHAR

INT

DATE

BLOB

12. Which constraint automatically generates a unique number for each new record?

UNIQUE

AUTO_INCREMENT

DEFAULT

CHECK

13. True or False: Multiple PRIMARY KEY constraints can exist on a single table.

True

False

Submit

15. Which data type is appropriate for storing a true/false value?

VARCHAR

INT

BOOLEAN

DATE

16. What is the primary purpose of a NOT NULL constraint?

Prevent duplicate values

Ensure every row has a value in that field

Link tables together

Automatically generate values

17. True or False: A field with the UNIQUE constraint can contain multiple NULL values.

True

False

Submit

19. Which data type would you use to store a product price with two decimal places?

INT

FLOAT

DECIMAL

CHAR

20. What does a PRIMARY KEY constraint ensure in a database table?

Values are always in alphabetical order

Each row is uniquely identified and non-null

Data is automatically backed up

Records cannot be deleted

Tech+ Database Data Types Fields and Key Constraints Quiz

1. What data type would you use to store a date like 2024-01-15?

2.

What first name or nickname would you like us to use?

2. True or False: Referential integrity is maintained by FOREIGN KEY constraints to prevent orphaned records.

3. A field with UNSIGNED INT can store positive numbers from 0 to approximately ____.

4. What is the main advantage of using a surrogate key instead of a natural key?

5. Which data type is best for storing whole numbers like employee IDs?

6. True or False: A FOREIGN KEY must reference a PRIMARY KEY in another table.

7. A DEFAULT constraint provides an automatic ____ when no value is specified.

8. Which of the following is a valid example of a composite primary key?

9. True or False: CHAR and VARCHAR both store text, but VARCHAR uses variable length storage.

10. A CHECK constraint validates that field values meet a specific ____.

11. Which data type is best suited for storing a customer's email address?

12. Which constraint automatically generates a unique number for each new record?

13. True or False: Multiple PRIMARY KEY constraints can exist on a single table.

14. A field defined as ____ can store large text documents or image files.

15. Which data type is appropriate for storing a true/false value?

16. What is the primary purpose of a NOT NULL constraint?

17. True or False: A field with the UNIQUE constraint can contain multiple NULL values.

18. A FOREIGN KEY constraint links a field in one table to the ____ of another table.

19. Which data type would you use to store a product price with two decimal places?

20. What does a PRIMARY KEY constraint ensure in a database table?