FINAL EXAM 3230 DBMS QUESTIONS AND
ANSWERS
When you read from and/or write to a database, you have created a(n)
____________________. - Correct Answers -Transaction
Most real-world database transactions are formed by two or more
____________________ requests. - Correct Answers -database
A transaction is a ____________________ unit of work that must be either entirely
completed or aborted. - Correct Answers -logical
To ensure consistency of the database, every transaction must begin with the database
in a known ____________________ state. - Correct Answers -consistent
Although the DBMS is designed to recover a database to a previous consistent state
(when an interruption prevents the completion of a required set of transactions), the
transactions themselves are defined by the end user or programmer and must be
____________________ correct. - Correct Answers -semantically
A(n) ____________________ is an information system component that handles a
specific function, such as inventory, orders, payroll, and so on. - Correct Answers -
module
The term "module ____________________" describes the extent to which modules are
independent of one another. - Correct Answers -coupling
Data ____________________ is enforced through the proper use of primary and
foreign key rules. - Correct Answers -integrity
Incomplete or improper transactions can have a devastating effect on database
__________________ - Correct Answers -integrity
____________________ databases, whether mainframe or LAN-based, are typically
subject to multiple concurrent transactions. - Correct Answers -Multiuser
The ANSI has defined standards that govern SQL database transactions. Transaction
support is provided by two SQL statements: ____________________ and ROLLBACK.
- Correct Answers -COMMIT
If a(n) ____________________ is issued before the termination of a transaction, the
DBMS will restore the database only for that particular transaction, rather than for all
ANSWERS
When you read from and/or write to a database, you have created a(n)
____________________. - Correct Answers -Transaction
Most real-world database transactions are formed by two or more
____________________ requests. - Correct Answers -database
A transaction is a ____________________ unit of work that must be either entirely
completed or aborted. - Correct Answers -logical
To ensure consistency of the database, every transaction must begin with the database
in a known ____________________ state. - Correct Answers -consistent
Although the DBMS is designed to recover a database to a previous consistent state
(when an interruption prevents the completion of a required set of transactions), the
transactions themselves are defined by the end user or programmer and must be
____________________ correct. - Correct Answers -semantically
A(n) ____________________ is an information system component that handles a
specific function, such as inventory, orders, payroll, and so on. - Correct Answers -
module
The term "module ____________________" describes the extent to which modules are
independent of one another. - Correct Answers -coupling
Data ____________________ is enforced through the proper use of primary and
foreign key rules. - Correct Answers -integrity
Incomplete or improper transactions can have a devastating effect on database
__________________ - Correct Answers -integrity
____________________ databases, whether mainframe or LAN-based, are typically
subject to multiple concurrent transactions. - Correct Answers -Multiuser
The ANSI has defined standards that govern SQL database transactions. Transaction
support is provided by two SQL statements: ____________________ and ROLLBACK.
- Correct Answers -COMMIT
If a(n) ____________________ is issued before the termination of a transaction, the
DBMS will restore the database only for that particular transaction, rather than for all
