Relational Database Model Quiz

What does a relational database model represent data as?

• Lists

• Tables

• Graphs

• Objects

What is a relation in the context of a relational database?

• A type of query

• A collection of files

• A named, two-dimensional table of data

• A single data value

What is the purpose of foreign keys in relational databases?

• To create indexes

• To store data values

• To represent relationships between tables

• To define primary keys

Which of the following is NOT a characteristic of a relational table?

• Each intersection of row and column represents a single data value

• All values in a column must be of different data types

• Each column has a distinct name

• Each row represents a single entity occurrence

What does the domain constraint ensure?

• All columns must have the same data type

• All rows must be filled

• All values in a column must come from the same domain

• All values in a column must be unique

What is the primary key in a relational table?

• A composite of all attributes

• An attribute that can be null

• A unique identifier for each row

• A foreign key from another table

What is the purpose of normalization in database design?

• To minimize data redundancy

• To simplify queries

• To increase data redundancy

• To create more tables

Which normal form is considered sufficient for most business database designs?

• BCNF

• 3NF

• 2NF

• 1NF

What type of anomaly occurs when data is not updated in all places?

• Referential anomaly

• Update anomaly

• Deletion anomaly

• Insertion anomaly

What does the SELECT operator do in relational algebra?

• Combines two tables

• Yields values for all rows that satisfy a condition

• Creates a new table

• Removes duplicate rows