Database Management Systems Quiz

Which model organizes data in a tree-like structure with a single parent for each record?

• Relational Model

• Network Model

• Hierarchical Model

• Object-Oriented Model

Which DBMS model supports many-to-many relationships using a graph structure?

• Hierarchical

• Relational

• Network

• Flat File

Which of the following is an example of a hierarchical model?

• Oracle DB

• Excel Spreadsheet

• Organizational Chart

• Online Shopping Cart

The model that uses tables with rows and columns is called:

• Object-Oriented Model

• Hierarchical Model

• Relational Model

• Network Model

In the relational model, a row is also known as a:

• Attribute

• Tuple

• Field

• Key

What uniquely identifies each tuple in a table?

• Super Key

• Candidate Key

• Foreign Key

• Primary Key

A NULL value represents:

• 0

• Empty String

• Unknown or Unavailable Data

• Error

What is a foreign key?

• Key from another table

• A duplicate key

• A key with NULL values

• Key that stores images

The number of attributes in a relation is called its:

• Cardinality

• Degree

• Tuple

• Entity

Which key can include additional, unnecessary attributes?

• Candidate Key

• Composite Key

• Primary Key

• Super Key