MIS 309 CH 5 Test Banks
The purpose of a(n) _____ is to keep track of things. - (correct Answer) - Database
Which of the following is the smallest data element in a database? - (correct Answer) - Byte
The columns in a database are called - (correct Answer) - Fields
The rows in a database are called - (correct Answer) - records
The tables that appear in a database are known as ________. - (correct Answer) - files
Which of the following data elements is placed higher than records in the data hierarchy? - (correct
Answer) - File
A primary key used in a database is a - (correct Answer) - column or group of columns that identifies a
unique row in a table
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) ________. - (correct Answer) - Primary key
Columns that belong to a different table than the one in which they reside are called ________. -
(correct Answer) - Foreign keys
Relational databases represent relationships using - (correct Answer) - Foreign keys
Metadata are ______. - (correct Answer) - Data that describe data
A(n) ________ is a program used to create, process, and administer a database. - (correct Answer) -
DBMS
Which of the following is an example of a database management system? - (correct Answer) - Access
From among the following, identify the open source DMBS product. - (correct Answer) - MySQL
Which of the following is a valid observation of MySQL? - (correct Answer) - It is license-free for most
applications
When you modify or delete data present in a database, you are_____. - (correct Answer) - Processing the
database
Which of the following is an international standard language for processing a database? - (correct
Answer) - SQL
Which of the following is a development task of database administration? - (correct Answer) - Creating
and staffing the DBA function
Identify the type of task that a database administrator is performing when validating the data model to
be used in a database management system - (correct Answer) - Development
The database administrator of an organization constantly manages the processing rights and
The purpose of a(n) _____ is to keep track of things. - (correct Answer) - Database
Which of the following is the smallest data element in a database? - (correct Answer) - Byte
The columns in a database are called - (correct Answer) - Fields
The rows in a database are called - (correct Answer) - records
The tables that appear in a database are known as ________. - (correct Answer) - files
Which of the following data elements is placed higher than records in the data hierarchy? - (correct
Answer) - File
A primary key used in a database is a - (correct Answer) - column or group of columns that identifies a
unique row in a table
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) ________. - (correct Answer) - Primary key
Columns that belong to a different table than the one in which they reside are called ________. -
(correct Answer) - Foreign keys
Relational databases represent relationships using - (correct Answer) - Foreign keys
Metadata are ______. - (correct Answer) - Data that describe data
A(n) ________ is a program used to create, process, and administer a database. - (correct Answer) -
DBMS
Which of the following is an example of a database management system? - (correct Answer) - Access
From among the following, identify the open source DMBS product. - (correct Answer) - MySQL
Which of the following is a valid observation of MySQL? - (correct Answer) - It is license-free for most
applications
When you modify or delete data present in a database, you are_____. - (correct Answer) - Processing the
database
Which of the following is an international standard language for processing a database? - (correct
Answer) - SQL
Which of the following is a development task of database administration? - (correct Answer) - Creating
and staffing the DBA function
Identify the type of task that a database administrator is performing when validating the data model to
be used in a database management system - (correct Answer) - Development
The database administrator of an organization constantly manages the processing rights and
