OMIS 452 Final Exam Questions with Correct Answers (Grade A+)

OMIS 452 Final Exam Questions with Correct Answers (Grade A+)

Question 1: In the general division of labor between database applications and the DBMS, the
processing of forms is considered a DBMS task. True False

Answer: False


Question 2: By separating data into tables containing data on only one theme each, making changes
to the data is simplified. True False

Answer: True


Question 3: The statement SELECT STUDENT.StudentNumber, STUDENT.StudentName, FROM
STUDENT WHERE STUDENT.StudentNumber = S12345678; is an example of ____ _. QBE Java
C++ QLE SQL

Answer: SQL


Question 4: Theoretically, databases could store instances in columns and characteristics in rows,
instead of the other way around. True False

Answer: TRUE


Question 5: Microsoft Access 2016 databases are stored using the file extension .accdb. True False

Answer: FALSE


Question 6: A possible problem with keeping data in lists is that if you delete a row of data from a
list, you may also delete some data items that you want to keep. True False

Answer: TRUE


Question 7: The default file format for Microsoft Access 2016 database files is the ____ _. Access XP
format Access 2007 format SQL Server format Access 2003 format XBD format

Answer: Access 2007 format


Question 8: Microsoft Access is a personal database system, and a personal database system is
characterized by ____ _. the DBMS product being limited to a maximum of ten tables in any given
database the DBMS not supporting indexes the DBMS removing the metadata from the database the
database being stored inside the DBMS the DBMS product taking the role of the DBMS and the
database application generator


Page 1

, Answer: the DBMS product taking the role of the DBMS and the database application generator


Question 9: Which of the following is not a function of the database application in a database system?
Create and process reports Execute application logic Create and process forms Create and transmit
queries Control concurrency

Answer: Create and process forms


Question 10: Usually, a database table containing both rows and columns is designed to store data
for exactly two themes. True False

Answer: FALSE


Question 11: A database is self-describing because the user maintains a record of the database
structure outside the database itself. True False

Answer: False


Question 12: Microsoft Access 2013 uses the Access 2003 .mdb file format as the default file format
for database files. True False

Answer: FALSE


Question 13: The creation of a database and its tables is a function of which component of the
database system? Application Users Web server Database DBMS

Answer: DBMS


Question 14: Which of the following would not be an example of database metadata? Queries against
records in the database tables Names of tables in a database Properties of columns Names of columns
in a database and their associated tables Properties of tables in a database

Answer: Queries against records in the database tables


Question 15: In the general division of labor between database applications and the DBMS, the
application program determines which tables need to be modified. True False

Answer: TRUE


Question 16: Although users use database systems, they are not considered part of a database system.
True False

Answer: FALSE

Page 2