Quiz on Relational Database Model

What is the basic component of the relational model?

• Tables

• Views

• Schemas

• Indexes

What does a relation in a relational database consist of?

• Attributes and entities

• Files and folders

• Rows and columns

• Keys and values

What is a composite key?

• A key composed of one attribute

• A key composed of multiple attributes

• A key used for data retrieval

• A key that is not unique

What is a foreign key?

• A key used for data retrieval

• A key that uniquely identifies a row

• A key that cannot be null

• An attribute that matches primary key values in another table

What is the purpose of a data dictionary?

• To manage user permissions

• To create backup copies of data

• To store user passwords

• To provide detailed accounting of all tables

Which relationship is considered the norm in relational database design?

• 1:M relationship

• 1:1 relationship

• M:N relationship

• N:M relationship

What does referential integrity ensure in a relational database?

• All attributes are unique

• Foreign keys refer to valid tuples in another relation

• All data is encrypted

• No null values are allowed

What can null values represent in a database?

• Unknown, missing, or not applicable values

• Only applicable values

• Only missing values

• Only unknown values

How can M:N relationships be implemented in a relational model?

• By using a composite key

• By creating two 1:M relationships

• By using a single table

• By avoiding relationships altogether

What is the role of controlled redundancy in a relational database?

• To ensure all tables are independent

• To increase data anomalies

• To enable tables to be linked together

• To eliminate all duplicate data