Quiz on Relational Database Model

What is the basic component of the relational model?

• Indexes

• Schemas

• Views

• Tables

What does a key in a relational database do?

• Stores data

• Identifies rows uniquely

• Links tables

• Defines attributes

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

• Two-dimensional structure

• Composed of rows and columns

• Persistent representation of logical relation

• Contains only unique values

What is a composite key?

• A key that is not unique

• A key composed of multiple attributes

• A key used for data retrieval

• A key with no attributes

What is referential integrity in a relational database?

• Ensuring all data is unique

• Creating redundancy

• Maintaining valid relationships between tables

• Avoiding null values

What is the purpose of a data dictionary?

• To store user data

• To provide metadata about the database

• To enforce integrity rules

• To create relationships between tables

Which relationship type is considered the norm in relational database design?

• 1:M relationship

• M:1 relationship

• 1:1 relationship

• M:N relationship

What can null values represent in a database?

• Only unknown values

• Only missing values

• Unknown, missing, or not applicable values

• Only applicable values

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

• As a single table

• As two 1:M relationships

• As a 1:1 relationship

• They cannot be implemented

What is controlled redundancy in a relational database?

• Avoiding all redundancy

• Creating multiple copies of data

• Sharing common attributes between tables

• Unnecessary duplication of data