Database Concepts Quiz

Data is best described as:

• Organized facts

• Raw facts and figures

• Processed information

• A set of reports

In the database approach, data can be shared among multiple users. This is called:

• Data isolation

• Data redundancy

• Data sharing

• Data independence

In which phase of the database system life cycle is the ER diagram created?

• Database Design

• Database Implementation

• Database Maintenance

• Database Testing

Which phase in the database system life cycle involves regular backups and monitoring system performance?

• Requirements Analysis

• Database Maintenance

• Database Implementation

• Database Design

In the relational model, data is organized into:

• Graphs

• Records

• Relations (tables)

• Nodes and edges

A primary key in a database:

• Can have duplicate values

• Must have unique and not null values

• Can contain null values

• Can be a composite of multiple fields

A foreign key is used to:

• Enforce referential integrity between two tables

• Uniquely identify each record in a table

• Define the data type of a column

• Index the records in a table

The phase of database design that defines the structure of the data elements without focusing on physical implementation is called:

• Logical design

• Physical design

• Conceptual design

• Implementation

The phase in which the actual storage structure is defined in a DBMS is:

• Logical design

• Conceptual design

• Physical design

• Normalization

Which of the following is an example of a strong entity?

• Employee in a company database

• A department that depends on an employee

• A course assigned to a student

• A temporary employee record