_____________transparency allows data to be updated simultaneously at several
network sites.
a. Transaction
b. Distribution
c. Failure
d. Performance
The DBA must supervise the installation of all software and hardware designated to
support the data administration strategy.
a. True
b. False
______________occurs when a transaction accesses data before and after one or more
other transactions finish working with such data.
a. Inconsistent retrievals
b. The phenomena of uncommitted data
c. Lost update problems
d. Dirty read problems
Master data management’s main goal is to provide a partial and segmented definition of
all data within an organization.
a. True
b. False
In the context of database security measures, enforcing complex password policies will
address the security vulnerabilities of the operating system component.
a. True
b. False
To model time-variant data, one must create a new entity in an M:N relationship with
the original entity.
a. True
b. False
A_________ lock locks the entire diskpage.
a. transaction-level
b. table-level
c. page-level
d. row-level
A stored function is another name for a stored procedure.
a. True
b. False
A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the
occurrence of a given data manipulation event.
a. True
b. False
Data processing can be as simple as organizing data to reveal patterns.
a. True
b. False
_________________refers to the number of different values a column could possibly
have.
a. Database statistics
b. Data sparsity
c. A bitmap index
d. Clustering
It is possible for a table in 2NF to exhibit transitive dependency, where the primary key
may rely on one or more nonprime attributes to functionally determine other nonprime
attributes.
a. True
b. False
The attribute hierarchy provides a top-down data organization that is used for two main
purposes:______ and drill-down/roll-up data analysis.
a. decomposition
b. de-normalization
c. normalization
d. aggregation
Which of the following is true of business rules?
a. They allow the designer to set company policies with regard to data.
b. They allow the designer to develop business processes.
c. They can serve as a communication tool between the users and designers.
d. They provide a framework for the company’s self-actualization.
Which of the following is a reason why a DBMS’s daily operations must be clearly
documented?
a. Documentation of the daily operations help a company set its long-term goals.
b. Documentation of the daily operations help manage the manual data resources of a
company.
c. Documentation of the daily operations help pinpoint causes and solutions of database
problems.
d. Documentation of the daily operations help free the DBA from many lower-level
technology-oriented tasks.
If there is no index, the DBMS will perform a__________ scan.
a. loop
b. range
c. row ID table access
d. full table
Bitmap indexes tend to use less space than a___________ because they use bits instead
of bytes to store their data.
a. hash index
b. sparse index
c. B-tree index
d. reverse index
Relational data warehouses use multidimensional data schema support to handle
multidimensional data.
a. True
b. False
_____________transparency exists when the end user or programmer must specify the
database fragment names but does not need to specify where these fragments are
located.
a. Transaction
b. Location
c. Local mapping
d. Fragmentation
The default comparison condition for the subtype discriminator attribute is
the___________ comparison.
a. nonequality
b. less than
c. greater than
d. equality
The data warehouse development life cycle differs from classical systems development.
a. True
b. False
The SQL command that allows a user to insert rows into a table is______________ .
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
Some RDBMSs, such as Oracle, automatically____________________ data changes
when issuing data definition commands.
a. COMMIT
b. ROLLBACK
c. UNSAVE
d. UPDATE
The ____________role of a DBA covers activities that involve evaluating, selecting,
installing, and maintaining a DBMS and its related utilities and applications.
a. technical
b. administrative
c. managerial
d. interactive
The purpose of a(n)___________ is to simplify an entity-relationship diagram (ERD)
and thus enhance its readability.
a. entity constraint
b. entity cluster
c. entity interface
d. entity discriminator
A _____________is a collection of related records.
a. schema
b. field
c. column
d. file
Queries against operational data typically are broad in scope and high in complexity.
a. True
b. False
One important inheritance characteristic is that all entity subtypes inherit their primary
key attribute from their supertype.
a. True
b. False
The basic star schema has four components: facts,________ , attributes, and attribute
hierarchies.
a. keys
b. relationships
c. cubes
d. dimensions
The following SQL statement uses a(n)____________ .
SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT,
VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
a. set operator
b. natural join
c. “oldstyle” join
d. procedural statement
Database administration operations are commonly defined and divided according to the
phases of the ________.
a. SLA
b. DBLC
c. SDLC
d. MRA
NoSQL databases:
a. are geared toward transaction consistency; not performance.
b. support only small amounts of sparse data.
c. are based on the relational model.
d. provide fault tolerance.
Decision support data are a snapshot of the operational data at a given point in time.
a. True
b. False
Attributes should clearly define participation, connectivity, and document cardinality.
a. True
b. False
Since a partial dependency can exist only if a table’s primary key is composed of
several attributes, if a table in 1NF has a single-attribute primary key, then the table is
automatically in 2NF.
a. True
b. False