MIS 204 PSU Exam 3 | COMPLETE QUESTIONS AND ANSWERS | 2025
LATEST UPDATED | ALREADY GRADED A+
When you modify or delete present in a database, you are ________ - (answers)Processing the
database
SQL is an international standard language for processing a database - (answers)True
One of the functions of a DBMS is to provide tools to assist in the administration of the database
- (answers)True
Which of the following is an international standard language for processing a database? -
(answers)SQL
Which of the following is a developmental task of database administration? - (answers)Creating
and staffing the DBA function
DBMS is used to set up security systems involving user accounts, passwords, permissions, and
limits for processing the database - (answers)True
One of the developmental tasks of a database administrator is to create a system to record and
manage the resolution of problems - (answers)False
Identify the type of task that a database administrator is performing when validating the data
model to be used in a database management system - (answers)Development
The database administrator of an organization constantly manages the processing rights and
responsibilities of employees. This is an example of a(n) ________ task. - (answers)Operational
Managing the impact of database structure changes on applications and users is an operational
task for a database administrator. - (answers)False
,Which of the following database administration tasks is related to adaption? -
(answers)Managing configuration changes in systems
A ________ is a collection of forms, reports, queries, and programs that process a database -
(answers)Database application
A database must have only one application, though the application can have one or more users -
(answers)False
________ forms are used to read, insert, modify and delete data - (answers)Data entry
A ________ is a request for data from a database - (answers)Query
Data entry forms are used to read, insert, modify and delete data - (answers)True
A drawback of DBMS programs is that they do not provide comprehensive and robust features
for querying database data - (answers)False
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 - (answers)Query
In order to find the data one is looking for in a DBMS, one has to type in the keyword into a
query form - (answers)True
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? - (answers)Lost-update
problem
A(n) ________ DBMS is designed to process large organizational and workgroup databases. -
(answers)Enterprise
Application programs process logic that is specific to a given business need - (answers)True
, The lost-update problem can be resolved by implementing multi-user database processing -
(answers)False
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. - (answers)Personal
Which of the following is an example of an enterprise DBMS? - (answers)SQL Server
Some type of locking must be used to coordinate the activities of users who know nothing about
one another in order to prevent the lost-update problem - (answers)True
Microsoft's SQL Server is an example of a personal DBSMS product - (answers)False
Which of the following types of DBMS products is designed for smaller and simpler database
applications? - (answers)Personal DBMS
Microsoft Access is both a DBMS and an application development product - (answers)True
________ is an example of a personal DBMS - (answers)Access
A ________ describes the data and relationships that will be stores in a database - (answers)Data
model
Developers need to construct a data model before building a database - (answers)True
A data model describes data, whereas a database explains the relationships among the data that
will be stores in the database - (answers)False
An administrator should create ________ before developing a database design - (answers)Data
Model
LATEST UPDATED | ALREADY GRADED A+
When you modify or delete present in a database, you are ________ - (answers)Processing the
database
SQL is an international standard language for processing a database - (answers)True
One of the functions of a DBMS is to provide tools to assist in the administration of the database
- (answers)True
Which of the following is an international standard language for processing a database? -
(answers)SQL
Which of the following is a developmental task of database administration? - (answers)Creating
and staffing the DBA function
DBMS is used to set up security systems involving user accounts, passwords, permissions, and
limits for processing the database - (answers)True
One of the developmental tasks of a database administrator is to create a system to record and
manage the resolution of problems - (answers)False
Identify the type of task that a database administrator is performing when validating the data
model to be used in a database management system - (answers)Development
The database administrator of an organization constantly manages the processing rights and
responsibilities of employees. This is an example of a(n) ________ task. - (answers)Operational
Managing the impact of database structure changes on applications and users is an operational
task for a database administrator. - (answers)False
,Which of the following database administration tasks is related to adaption? -
(answers)Managing configuration changes in systems
A ________ is a collection of forms, reports, queries, and programs that process a database -
(answers)Database application
A database must have only one application, though the application can have one or more users -
(answers)False
________ forms are used to read, insert, modify and delete data - (answers)Data entry
A ________ is a request for data from a database - (answers)Query
Data entry forms are used to read, insert, modify and delete data - (answers)True
A drawback of DBMS programs is that they do not provide comprehensive and robust features
for querying database data - (answers)False
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 - (answers)Query
In order to find the data one is looking for in a DBMS, one has to type in the keyword into a
query form - (answers)True
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? - (answers)Lost-update
problem
A(n) ________ DBMS is designed to process large organizational and workgroup databases. -
(answers)Enterprise
Application programs process logic that is specific to a given business need - (answers)True
, The lost-update problem can be resolved by implementing multi-user database processing -
(answers)False
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. - (answers)Personal
Which of the following is an example of an enterprise DBMS? - (answers)SQL Server
Some type of locking must be used to coordinate the activities of users who know nothing about
one another in order to prevent the lost-update problem - (answers)True
Microsoft's SQL Server is an example of a personal DBSMS product - (answers)False
Which of the following types of DBMS products is designed for smaller and simpler database
applications? - (answers)Personal DBMS
Microsoft Access is both a DBMS and an application development product - (answers)True
________ is an example of a personal DBMS - (answers)Access
A ________ describes the data and relationships that will be stores in a database - (answers)Data
model
Developers need to construct a data model before building a database - (answers)True
A data model describes data, whereas a database explains the relationships among the data that
will be stores in the database - (answers)False
An administrator should create ________ before developing a database design - (answers)Data
Model
