The data cache is where the data read from the database data files are stored ____ the
data have been read or ____ the data are written to the database data files.
a. after, before
b. after, after
c. before, before
d. before, after
The information stored in the ____ is used by the DBMS for a recovery requirement
triggered by a ROLLBACK statement, a program’s abnormal termination, or a system
failure such as a network discrepancy or a disk crash.
a. data dictionary
b. metadata
c. rollback manager
d. transaction log
A workgroup database is a(n)____ database.
a. single-user
b. multiuser
c. enterprise
d. distributed
A(n) ____ is the attribute in the supertype entity that determines to which entity subtype
each supertype occurrence is related.
a. subtype discriminator
b. inheritance discriminator
c. specialization hierarchy
d. entity supertype
The ____ dimension of a data cube provides a framework from which sales patterns can
be analyzed and possibly predicted.
a. time
b. cube
c. third
d. multi-
Testing, fine-tuning, and evaluating the database and its applications are part of the
____ phase of the DBLC.
a. database initial study
b. database design
c. implementation and loading
d. testing and evaluation
If a table has multiple candidate keys and one of those candidate keys is a composite
key, the table can have ____ based on this composite candidate key, even when the
primary key chosen is a single attribute.
a. Boyce-Codd Normal Form
b. redundancy
c. time-variance
d. partial dependencies
A desktop database is a ____ database.
a. single-user
b. multiuser
c. workgroup
d. distributed
Installation and fine tuning are part of the ____ phase of the SDLC.
a. planning
b. analysis
c. detailed systems design
d. implementation
OLAP systems are designed to use both operational and data ____________________
data.
When using an Oracle database, your Web-to-database middleware can connect to the
database via ____.
a. ODBX
b. CGI
c. SQL*Net
d. SQL*Plus
On the client side, the objective is to generate a SQL query that returns the correct
answer in the least amount of time, using the minimum amount of resources at the
server end. The activities required to achieve that goal are commonly referred to as
____ tuning.
a. client and server
b. database
c. SQL performance
d. DBMS performance
The SQL aggregate function that gives the average for the specific column is ____.
a. COUNT
b. AVG
c. MAX
d. SUM
Corporations use only structured data.
During decentralized design, after the ____ process has been completed, all modules
are integrated into one conceptual model.
a. initial
b. verification
c. conceptual
d. logical
____ is a generic entity type that is related to one or more entity subtypes.
a. A subtype discriminator
b. Inheritance
c. A specialization hierarchy
d. An entity supertype
The ____ constraint can be placed on a column to ensure that every row in the table has
a value for that column.
a. HAS VALUE
b. NOT NULL
c. MUST HAVE VALUE
d. NOT EMPTY
A diskpage, or page, is the equivalent of a ____.
a. database table
b. disk sector
c. database schema
d. diskblock
____ distributed database systems integrate different types of centralized DBMSs over
a network.
a. Homogeneous
b. Heterogeneous
c. Fully homogeneous
d. Combination
____provide a unified, single point of entry for information distribution.
a. Decision support systems
b. Portals
c. Data warehouses
d. Dashboards
A characteristic of decision support data is ____.
a. high query activity
b. high update volumes
c. highly normalized
d. low aggregation level
The attribute hierarchyprovides a top-down data organization that is used for two main
purposes: ____ and drill-down/roll-up data analysis.
a. hierarchy
b. de-normalization
c. normalization
d. aggregation
The ____ administrator is responsible for strategic planning.
a. system
b. data
c. database
d. program
Of the following, what is one of the benefits of hardware and software independence of
Internet technologies?
a. Global access
b. Reduced costs of maintaining private networks
c. Savings in equipment and software acquisition
d. Multiple platform development
The ____ object is a specialized object that creates a read-only session with the
database to retrieve data sequentially (forward only) in a very fast manner.
a. Command
b. DataReader
c. DataAdapter
d. DataSet
The logical systems design is created during the ____ phase of the SDLC.
a. planning
b. analysis
c. implementation
d. maintenance
A table is in 4NF if it is in 3NF and ____.
a. all attributes must be dependent on the primary key, and must be dependent on each
other
b. all attributes are unrelated
c. has no multivalued dependencies
d. no column contains the same values
A ____ lock locks the entire diskpage.
a. transaction-level
b. table-level
c. page-level
d. row-level
____ 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 conflicts between design efficiency, information requirements, and processing
speed are often resolved through ____.
a. conversion from 1NF to 2NF
b. conversion from 2NF to 3NF
c. compromises that include denormalization
d. conversion from 3NF to 4NF
Which query uses the correct SQL syntax to list the table contents for either V_CODE =
21344 or V_CODE = 24288?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE <= 24288
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE => 24288
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE > 24288
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344 OR V_CODE = 24288
Data ____________________ tools are tools that provide advanced statistical analysis
to uncover problems and opportunities hidden within business data.
Using an XML ____________________, a company would be able to validate the data
for values that may be out of range, incorrect dates, valid values, and so on.
The effects of bad database design, implementation, and management are multiplied in
an environment in which transactions may be measured in hundreds of thousands per
day, rather than in hundreds per day.
A data ____________________ is a small, single-subject data warehouse subset that
provides decision support to a small group of people.
The relationship ____________________ is difficult to establish if you know only one
side of the relationship.
Ideally, a primary key is composed of several attributes.
Composite primary keys are particularly useful as identifiers of composite entities,
where each primary key combination is allowed ____________________ in the M:N
relationship.
Stored procedures are executed using the EXEC command.
The ____________________ clause is used to restrict the output of a GROUP BY
query by applying a conditional criteria to the grouped rows.
One of the advantages of a DDBMS is ____________________ operating cost.
A DBMS must have validation, transformation, and mapping functions, as well as other
functions, in order to be classified as distributed.
A user-friendly ____________________ is one advantage of a DDBMS.
Attributes have a domain that specifies the data type of the attribute.
Data warehouses usually have one fact table.
A foreign key must exist in both tables that have a relationship.
The term ____________________ is used to refer to the task of creating a conceptual
data model that could be implemented in any DBMS.