Data Concepts (Data+) Quiz: Schemas & Records

1. Which statement about NULL values is correct?

NULL represents the number zero

NULL means the value is unknown or missing

NULL is the same as an empty string

NULL values are automatically rejected

Submit

9. Which data type is best suited for storing a product price?

Integer

DECIMAL or FLOAT

VARCHAR

BOOLEAN

10. What is referential integrity in a database?

The rule that foreign key values must match primary key values in related tables

A method of compressing database files

The encryption standard used for data protection

A backup strategy for disaster recovery

11. What is a schema in a relational database?

The logical structure defining tables, fields, and relationships

A backup copy of the database

A query language for retrieving data

A security protocol for data encryption

12. What is an index in a database?

A sorted list of values that speeds up queries

A summary of all records in the table

A security restriction on data access

A type of data validation rule

13. Which of these best defines data cardinality?

The number of records in a single table

The relationship ratio between two entities

The size of the database file

The backup frequency of the database

14. A BOOLEAN data type can store which of the following values?

Only numbers 0-255

True or False

Any text string

Dates and times

15. What does normalization accomplish in database design?

Increases data redundancy and storage size

Reduces data redundancy and improves data integrity

Encrypts all sensitive information

Automatically backs up the database

16. In database terminology, what is a foreign key?

A key stored in an external database

A field that references a primary key in another table

A key used only for encryption

A backup identifier for records

17. Which data type would be most appropriate for storing a customer's email address?

Integer

Boolean

VARCHAR or Text

Date

18. What is the primary purpose of a primary key in a table?

To encrypt sensitive data

To uniquely identify each record

To sort records in ascending order

To create backups automatically

19. A database field is most accurately described as:

A collection of related records

A single column that stores one type of data

The physical storage location on disk

A relationship between two tables

20. Which term best describes a single row of data in a database table?

Field

Record

Attribute

Column

Data Concepts Quiz: Can You Master Schemas, Records & Fields?

1. Which statement about NULL values is correct?

2.

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

2. The ____ is the actual information stored in a field for a specific record.

3. Data integrity is maintained through constraints and ____ rules.

4. A field that stores TRUE or FALSE values is of type ____.

5. In a one-to-many relationship, the side with only one occurrence is called the ____ side.

6. A ____ is a constraint that ensures every record has a unique identifier.

7. The process of organizing data to eliminate redundancy is called ____.

8. A table with multiple candidate keys can have only one ____.