1. A key is a column or group of columns that identifies a unique row in a table.

True

False

2. Each table in a database must have two or more primary keys.

True

False. 3. A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably.

True

False

4. One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems.

True

False 5. A data model describes data and relationships that will be stored in the database.

True

False 6. In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes.

True

False 7. A foreign key is essential in relational databases to represent the relationship between two tables.

True

False 8. Which of the following is the smallest data element in a database?

Field

Record

File

Byte 9. Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________.

primary key

foreign key

identifier

functionally dependent record 10. Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

report

data model

database administrative function

query

Thank you