OMIS 452 Final Exam Questions and
Answers
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
By separating data into tables containing data on only one theme each,
making changes to the data is simplified.
True False - 🧠 ANSWER ✔✔True
The statement
,SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________.
QBE
Java
C++
QLE
SQL - 🧠 ANSWER ✔✔SQL
Theoretically, databases could store instances in columns and
characteristics in rows, instead of the other way around.
True False - 🧠 ANSWER ✔✔TRUE
Microsoft Access 2016 databases are stored using the file extension
.accdb.
,True False - 🧠 ANSWER ✔✔FALSE
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
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
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, 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 - 🧠 ANSWER ✔✔the DBMS product taking the role of
the DBMS and the database application generator
Which of the following is not a function of the database application in a
database system?
Create and process reports
Execute application logic
Answers
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
By separating data into tables containing data on only one theme each,
making changes to the data is simplified.
True False - 🧠 ANSWER ✔✔True
The statement
,SELECT STUDENT.StudentNumber, STUDENT.StudentName,
FROM STUDENT
WHERE STUDENT.StudentNumber = S12345678;
is an example of ________.
QBE
Java
C++
QLE
SQL - 🧠 ANSWER ✔✔SQL
Theoretically, databases could store instances in columns and
characteristics in rows, instead of the other way around.
True False - 🧠 ANSWER ✔✔TRUE
Microsoft Access 2016 databases are stored using the file extension
.accdb.
,True False - 🧠 ANSWER ✔✔FALSE
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
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
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
, 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 - 🧠 ANSWER ✔✔the DBMS product taking the role of
the DBMS and the database application generator
Which of the following is not a function of the database application in a
database system?
Create and process reports
Execute application logic
