A transaction processor (TP) is the software component residing on each computer that
stores and retrieves data located at the site.
a. True
b. False
A database management system needs_____________ to prepare the data for
presentation to the end user or to an application program.
a. security
b. concurrency control
c. formatting
d. I/O interface
A is optimized for decision support and is generally represented by a data warehouse or
a data mart.
a. data store
b. ETL tool
c. data visualization
d. data analysis tool
In a page-level lock, the DBMS will lock an entire diskpage.
a. True
b. False
The purpose of an I/O operation is to move data to and from different computer
components or devices.
a. True
b. False
In the wait/die scheme,:
a. the older transaction rolls back the younger transaction and reschedules it.
b. the younger, preempted transaction is rescheduled using the same time stamp.
c. the older transaction waits for the younger one to complete and release its locks.
d. both the younger and older transactions wait indefinitely to be released.
The extended entity relationship model (EERM) is sometimes referred to as the .
a. enclosed entity relationship model
b. enhanced entity relationship model
c. entity clustering relationship model
d. extended entity relationship diagram
______________data refer to data whose values change over time and for which one
must keep a history of the data changes.
a. Time-sensitive
b. Time-variant
c. Historical
d. Change-based
A design trap occurs when a relationship is improperly or incompletely identified and is
therefore represented in a way that is not consistent with the real world.
a. True
b. False
In the context of RAID levels,__________ refers to writing the same data blocks to
separate drives.
a. striping
b. mirroring
c. partitioning
d. aggregating
A(n)_____________ database stores each database fragment at a single site.
a. partially replicated
b. unreplicated
c. fully replicated
d. partitioned
The most important characteristic of an entity is its__________ key, used to uniquely
identify each entity instance.
a. primary
b. natural
c. foreign
d. surrogate
A composite identifier is a primary key composed of more than one attribute.
a. True
b. False
An internal___________ refers to a specific representation of an internal model, using
the database constructs supported by the chosen database.
a. tuple
b. schema
c. object
d. value
Some very specialized applications may require normalization beyond
the_______________ .
a. 1NF
b. 2NF
c. 3NF
d. 4NF
The transaction processor (TP) is the software component found in each computer that
requests data.
a. True
b. False
Data is the result of processing raw facts to reveal its meaning.
a. True
b. False
A null is created when you press the Enter key or the Tab key to move to the next entry
without making a prior entry of any kind.
a. True
b. False
The syntax for creating an index is_________________ .
a. CREATE [NOT NULL] INDEX indexname FROM viewname(column1 [,
column2]);
b. CREATE [UNIQUE] INDEX indexname ON tablename( column1 [, column2]);
c. CREATE [UNIQUE] INDEX indexname FROM tablename(column1 [, column2]);
d. CREATE [DEFAULT] INDEX indexname ON viewname(column1 [, column2]);
The implementation of_________ applications tends to prolong the operational life of
systems by making them easier to update and maintain.
a. database-produced
b. network-produced
c. CASE-produced
d. design-produced
The__________ administrator is responsible for strategic planning.
a. system
b. data
c. database
d. program
RAID systems use a single disk to create storage volumes.
a. True
b. False
A centralized database management is subject to a problem such
as_______________________ .
a. a growing number of remote locations
b. maintaining and operating small database systems
c. dependence on multiple sites
d. organizational flexibility of the database
A full backup, or database dump, produces a complete copy of the entire database.
a. True
b. False
_____________________allows for the translation of the company’s strategic goals
into the data and applications that will help the company achieve those goals.
a. Access Management
b. Business Intelligence
c. Information engineering (IE)
d. MOLAP
The command would be used to delete the table row where the P_CODE is “BRT-345”.
a. DELETE FROM PRODUCT WHERE P_CODE = “BRT-345”;
b. REMOVE FROM PRODUCT WHERE P_CODE = “BRT-345”;
c. ERASE FROM PRODUCT WHERE P_CODE = “BRT-345”;
d. ROLLBACK FROM PRODUCT WHERE P_CODE = “BRT-345”;
Before converting a table into 3NF, it is imperative that the table already be
in_________- .
a. 1NF
b. 2NF
c. 4NF
d. BCNF
_____________are normally expressed in the form of rules.
a. Attributes
b. Entities
c. Relationships
d. Constraints
A database management system (DBMS) must have validation, transformation, and
mapping functions, as well as other functions, in order to be classified as distributed.
a. True
b. False
Which of the following queries will use the given columns and column aliases from the
PRODUCT table to determine the total value of inventory held on hand?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE FROM PRODUCT;
Good database performance is easy to evaluate.
a. True
b. False