OMIS 452 Questions with Correct
Answers
Which of the following is a function of the DBMS in a database system? - 🧠
ANSWER ✔✔Perform backup and recovery
An advantage of keeping data in lists is that if you update a data value in
one row of data in a list, other occurrences of the same data item in other
rows will be automatically updated as well. - 🧠 ANSWER ✔✔False
Web 2.0 web sites were popular due to their static, unchanging content. - 🧠
ANSWER ✔✔False
Which of the following is a function of the database application in a
database system? - 🧠 ANSWER ✔✔Create and transmit queries
,Microsoft Access 2013 database files are stored using the file extension
________. - 🧠 ANSWER ✔✔.accdb
Referential integrity constraints must be enforced by the application
program. - 🧠 ANSWER ✔✔False
Regarding Big Data, what does the term NoSQL really mean? - 🧠 ANSWER
✔✔Non-Relational Database
The purpose of a database is to help people keep track of things. - 🧠
ANSWER ✔✔True
The Microsoft Access 2013 data type of AutoNumber is used when there is
a specific need for a ________. - 🧠 ANSWER ✔✔surrogate key
In the general division of labor between database applications and the
DBMS, the application program formats the results of a query into a report.
- 🧠 ANSWER ✔✔True
A relational database can be defined as a self-describing collection of
related tables. - 🧠 ANSWER ✔✔True
Microsoft Access 2016 is a personal database that combines a DBMS with
an application generator. - 🧠 ANSWER ✔✔True
, Metadata is the user data stored in the database. - 🧠 ANSWER ✔✔False
SQL stands for Structural Question Language. - 🧠 ANSWER ✔✔False
Microsoft Access 2016 uses the AutoNumber data type to create surrogate
keys. - 🧠 ANSWER ✔✔True
Microsoft SQL Server is an example of a ________. - 🧠 ANSWER
✔✔database management system
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. - 🧠 ANSWER ✔✔True
A database may be used to help people with all of the following except
________. - 🧠 ANSWER ✔✔debug existing program code
Which of the following is not a function of the database application in a
database system? - 🧠 ANSWER ✔✔Control concurrency
SQL stands for ________. - 🧠 ANSWER ✔✔Structured Query Language
A database is a set of one or more computer programs that serves as an
intermediary between the users and the database management system
(DBMS). - 🧠 ANSWER ✔✔False
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
Answers
Which of the following is a function of the DBMS in a database system? - 🧠
ANSWER ✔✔Perform backup and recovery
An advantage of keeping data in lists is that if you update a data value in
one row of data in a list, other occurrences of the same data item in other
rows will be automatically updated as well. - 🧠 ANSWER ✔✔False
Web 2.0 web sites were popular due to their static, unchanging content. - 🧠
ANSWER ✔✔False
Which of the following is a function of the database application in a
database system? - 🧠 ANSWER ✔✔Create and transmit queries
,Microsoft Access 2013 database files are stored using the file extension
________. - 🧠 ANSWER ✔✔.accdb
Referential integrity constraints must be enforced by the application
program. - 🧠 ANSWER ✔✔False
Regarding Big Data, what does the term NoSQL really mean? - 🧠 ANSWER
✔✔Non-Relational Database
The purpose of a database is to help people keep track of things. - 🧠
ANSWER ✔✔True
The Microsoft Access 2013 data type of AutoNumber is used when there is
a specific need for a ________. - 🧠 ANSWER ✔✔surrogate key
In the general division of labor between database applications and the
DBMS, the application program formats the results of a query into a report.
- 🧠 ANSWER ✔✔True
A relational database can be defined as a self-describing collection of
related tables. - 🧠 ANSWER ✔✔True
Microsoft Access 2016 is a personal database that combines a DBMS with
an application generator. - 🧠 ANSWER ✔✔True
, Metadata is the user data stored in the database. - 🧠 ANSWER ✔✔False
SQL stands for Structural Question Language. - 🧠 ANSWER ✔✔False
Microsoft Access 2016 uses the AutoNumber data type to create surrogate
keys. - 🧠 ANSWER ✔✔True
Microsoft SQL Server is an example of a ________. - 🧠 ANSWER
✔✔database management system
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. - 🧠 ANSWER ✔✔True
A database may be used to help people with all of the following except
________. - 🧠 ANSWER ✔✔debug existing program code
Which of the following is not a function of the database application in a
database system? - 🧠 ANSWER ✔✔Control concurrency
SQL stands for ________. - 🧠 ANSWER ✔✔Structured Query Language
A database is a set of one or more computer programs that serves as an
intermediary between the users and the database management system
(DBMS). - 🧠 ANSWER ✔✔False
COPYRIGHT©PROFFKERRYMARTIN 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE.
PRIVACY STATEMENT. ALL RIGHTS RESERVED
