Fundamentals of Relational Database Systems Quiz

What is the smallest unit of data that a computer can process?

• Byte

• Bit

• Record

• Field

Which of the following is a characteristic of a field in a database?

• It is the smallest unit of data a user accesses.

• It can contain multiple records.

• It represents a group of related fields.

• It is a collection of related tables.

What does a data dictionary do?

• Organizes data in a hierarchical structure.

• Defines data types and field names.

• Represents relationships among entities.

• Stores all data values.

Which data type is used to store logical data?

• Text

• Number

• Yes/No

• Currency

What is an entity in the context of a database?

• A type of data manipulation.

• A person, place, thing, or event.

• A collection of records.

• A type of data integrity.

In an entity-relationship model, what does a diamond shape represent?

• Cardinality

• Entity

• Attribute

• Relationship

What type of relationship exists when one record is related to many records?

• Many-to-Many

• Many-to-One

• One-to-Many

• One-to-One

Which of the following best describes data integrity?

• Data that is easy to access.

• Data that is accurate and consistent.

• Data that is stored in multiple formats.

• Data that is derived from other data.

What is the primary function of a query in a database?

• To display all records.

• To retrieve specific data based on criteria.

• To create new records.

• To delete existing records.

Which of the following is NOT a database object?

• Spreadsheet

• Table

• Query

• Form