MIS 309 Chapter 5 Exam Questions With All Correct Solved Answers
Study online at https://quizlet.com/_i0o43a
1. A(n) ________ is a self-describing collection of integrated records.: Database
2. Which of the following is the smallest data element in a database?: Byte
3. The columns in a database are called ________.: fields
4. The rows in a database are called ________.: records
5. The tables that appear in a database are known as ________.: Files
6. Which of the following data elements is placed higher than records in the data
hierarchy?: File
7. A primary key used in a database is a ________.: column or group of columns that identifies a
unique row in a table
8. Albert creates a relational database to store employee performance statistics.
He stores each employee's data in independent rows and creates a column
named "Employee Number" to assign unique numbers to each employee. This
column is referred to as a(n) ________.: primary key
9. Columns that belong to a different table than the one in which they reside are
called ________.: foreign keys
10. Relational databases represent relationships using ________.: foreign keys
11. Metadata are ________.: data that describe data
12. A(n) ________ is a program used to create, process, and administer a data-
base.: DBMS
13. Which of the following is an example of a database management system?: -
Access
14. From among the following, identify the open source DBMS product.: MySQL
15. Which of the following is a valid observation of MySQL?: It is license-free for most
applications.
16. When you modify or delete data present in a database, you are ________.: pro-
cessing the database
17. Which of the following is an international standard language for processing
a database?: SQL
18. Which of the following is a developmental task of database administration?-
: creating and staffing the DBA function
1/4
Study online at https://quizlet.com/_i0o43a
1. A(n) ________ is a self-describing collection of integrated records.: Database
2. Which of the following is the smallest data element in a database?: Byte
3. The columns in a database are called ________.: fields
4. The rows in a database are called ________.: records
5. The tables that appear in a database are known as ________.: Files
6. Which of the following data elements is placed higher than records in the data
hierarchy?: File
7. A primary key used in a database is a ________.: column or group of columns that identifies a
unique row in a table
8. Albert creates a relational database to store employee performance statistics.
He stores each employee's data in independent rows and creates a column
named "Employee Number" to assign unique numbers to each employee. This
column is referred to as a(n) ________.: primary key
9. Columns that belong to a different table than the one in which they reside are
called ________.: foreign keys
10. Relational databases represent relationships using ________.: foreign keys
11. Metadata are ________.: data that describe data
12. A(n) ________ is a program used to create, process, and administer a data-
base.: DBMS
13. Which of the following is an example of a database management system?: -
Access
14. From among the following, identify the open source DBMS product.: MySQL
15. Which of the following is a valid observation of MySQL?: It is license-free for most
applications.
16. When you modify or delete data present in a database, you are ________.: pro-
cessing the database
17. Which of the following is an international standard language for processing
a database?: SQL
18. Which of the following is a developmental task of database administration?-
: creating and staffing the DBA function
1/4
