Database quiz part 1 - D2T4

1. Which of the following best describes a database?

• A collection of unrelated data

• A collection of related data

• A spreadsheet with numbers

• An application for emails

2. The main purpose of a DBMS is to:

• Manage hardware devices

• Store, retrieve, and manage data efficiently

• Create websites

• Compile programming code

Which is an example of a DBMS?

• Microsoft Excel

• MySQL

• Google Chrome

• Notepad

In a database, data is organized into:

• Pages

• Files only

• Rows and columns

• Webpages

Which of the following is NOT a database model?

• Hierarchical model

• Network model

• Relational model

• Browser model

The smallest unit of data in a database is called:

• Record

• Field

• Bit

• Byte

What is a primary key?

• A field that can have duplicate values

• A unique identifier for each record

• A password for database login

• A foreign field in a table

What does SQL stand for?

• Structured Query Language

• Simple Question Language

• Sequential Query Language

• Structured Quick Logic

In relational databases, a table is also called a:

• Relation

• Graph

• Index

• View

In a relational database, columns are also called:

• Attributes

• Tuples

• Records

• Files