Database Management System Quiz

What is a Database Management System (DBMS)?

• A software program that allows users to create, edit, and update data in database files.

• Known facts that can be recorded and have implicit meaning.

• A collection of related data.

• Composed of 5 major parts: Hardware, Software (DBMS), People, Procedures, and Data.

Which of the following is a common feature of a DBMS?

• Storing known facts that can be recorded and have implicit meaning.

• Composed of 5 major parts: Hardware, Software (DBMS), People, Procedures, and Data.

• Ensuring completeness, integrity, flexibility, efficiency, and usability of data.

• A set of software programs that allows users to create, edit, and update data in database files.

Which of the following is a feature of the relational database model?

• Hierarchical structure

• Table structure

• Network structure

• Graph structure

A primary key is used to ______.

• uniquely identify a row

• uniquely identify a column

• sort the data

• relate two tables

Which of the following keys can be a candidate key?

• Foreign key

• Composite key

• Primary key

• All of the above

The degree of a relation is the number of _______.

• attributes

• tuples

• constraints

• indexes

The collection of information stored in a database at a particular moment is known as ______.

• database instance

• database schema

• data model

• data dictionary

In a relational database, a tuple is a synonym for a _______.

• column

• row

• key

• table

A foreign key is used to establish a ______ between two tables.

• one-to-many relationship

• many-to-many relationship

• one-to-one relationship

• either one-to-many or many-to-many

Which of the following statements about indexes is true?

• Indexes speed up query execution

• Indexes increase data redundancy

• Indexes are only used in hierarchical databases

• Indexes prevent data modification