MIS 309 Chapter 5 Exam Questions With All Correct Solved Answers

MIS 309 Chapter 5 Exam Questions With All Correct Solved Answers A(n) ________ is a self-describing collection of integrated records. - Answer- Database Which of the following is the smallest data element in a database? - Answer- Byte The columns in a database are called ________. - Answer- fields The rows in a database are called ________. - Answer- records The tables that appear in a database are known as ________. - Answer- Files Which of the following data elements is placed higher than records in the data hierarchy? - Answer- File A primary key used in a database is a ________. - 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) ________. - Answer- primary key Columns that belong to a different table than the one in which they reside are called ________. - Answer- foreign keys Relational databases represent relationships using ________. - Answer- foreign keys Metadata are ________. - Answer- data that describe data A(n) ________ is a program used to create, process, and administer a database. - Answer- DBMS Which of the following is an example of a database management system? - Answer- Access From among the following, identify the open source DBMS product. - Answer- MySQL Which of the following is a valid observation of MySQL? - Answer- It is license-free for most applications. When you modify or delete data present in a database, you are ________. - Answer- processing the database Which of the following is an international standard language for processing a database? - Answer- SQL Which of the following is a developmental task of database administration? - 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. - Answer- Development The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task. - Answer- Operational Which of the following database administration tasks is related to adaptation? - Answer- managing configuration changes in systems A ________ is a collection of forms, reports, queries, and programs that process a database. - Answer- database application ________ forms are used to read, insert, modify, and delete data. - Answer- data entry A ________ is a request for data from a database. - Answer- query Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants. - Answer- query Which of the following refers to the problem that exists in database applications when two users update the same data item, but only one of those changes is recorded? - Answer- lost-update problem A(n) ________ DBMS is designed to process large organizational and workgroup databases. - Answer- Enterprise An organization buys a proprietary database application to be used by a small workgroup of five people. This is an example of a(n) ________ DBMS - Answer- personal Which of the following is an example of an enterprise DBMS? - Answer- SQL Server Which of the following types of DBMS products is designed for smaller and simpler database applications? - Answer- personal DBMS ________ is an example of a personal DBMS. - Answer- Access