Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
One of the advantages of a distributed database management system (DDBMS) is
growth facilitation.
a. True
b. False
The design of the system's processes is completed during the___________ phase of the
Systems Development Life Cycle (SDLC).
a. planning
b. analysis
c. detailed systems design
d. implementation
The order of the rows and columns is important to the DBMS.
a. True
b. False
Triggers can only be used to update table values.
a. True
b. False
Using________________ , you can extract data from an XML document and convert it
into a text file.
a. XMLD
b. XSLT
c. DTD
d. XML schema
The data cache or_________ is a shared, reserved memory area that stores the most
recently accessed data blocks in RAM.
a. buffer cache
b. procedure cache
c. SQL cache
d. permanent storage
ROLAP and MOLAP vendors are working toward the integration of their respective
solutions within a unified decision support framework.
a. True
b. False
Which of the following is a feature of a correlated subquery?
a. The inner subquery executes first.
b. The outer subquery initiates the process of execution in a subquery.
c. The inner subquery initiates the process of
d. The outer subquery executes independent
execution in a subquery. of the inner subquery.
The________ data model is said to be a semantic data model.
a. relational
b. network
c. object-oriented
d. entity relationship
An atomic attribute_______________ .
a. cannot exist in a relational table
b. cannot be further subdivided
c. displays multiplicity
d. is always chosen to be a foreign key
The benefits of the web as a data access platform arise from its cross-platform
functionality and the simplicity of its interface.
a. True
b. False
The DBMS reveals much of the database's internal complexity to the application
programs and users.
a. True
b. False
______________is the bottom-up process of identifying a higher-level, more generic
entity supertype from lower-level entity subtypes.
a. Specialization
b. Generalization
c. Normalization
d. Total completeness
Having a computerized DBMS guarantees that the data will be properly used to provide
the best solutions required by managers.
a. True
b. False
The Systems Development Life Cycle (SDLC) traces the history of an information
system.
a. True
b. False
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
A cost-based optimizer uses a set of preset rules and points to determine the best
approach to execute a query.
a. True
b. False
The PL/SQL block starts with the_________ section.
a. IS
b. OPEN
c. DECLARE
d. BEGIN
____________ensure that a disk physical failure will not impair the DBMS's ability to
recover data.
At the level of middle management, the database must be able to_____________ .
a. provide a framework for defining and enforcing organizational policies
b. provide the data necessary for tactical decisions and planning
c. provide feedback to monitor whether a company is achieving its goals
d. provide access to external and internal data to identify growth opportunities
An API (application programming interface) is defined as a set of routines, protocols,
and tools for building software applications.
a. True
b. False
In a______________ situation, one key determines multiple values of two other
attributes and those attributes are independent of each other.
a. multivalued dependency
b. transitive dependency
c. partial dependency
d. functional dependency
______________exists when different versions of the same data appear in different
places.
a. Data inconsistency
b. Poor data security
c. Structural dependence
d. Conceptual dependence
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
semantically correct.
a. True
b. False
A table can be deleted from the database by using the_____________ command.
a. DROP TABLE
b. DELETE TABLE
c. MODIFY TABLE
d. ERASE TABLE
Disjoint subtypes are subtypes that contain nonunique subsets of the supertype entity
set.
a. True
b. False
The__________ model was developed to allow designers to use a graphical tool to
examine structures rather than describing them with text.
a. hierarchical
b. network
c. object-oriented
d. entity relationship
___________are especially useful when you are trying to determine what values in
related tables cause referential integrity problems.
a. Inner joins
b. Outer joins
c. Equijoins
d. Theta joins
________________exists when it is possible to make changes in the data storage
characteristics without affecting an application program's ability to access data.
Most current-generation relational DBMSs perform automatic query optimization at the
client end.
a. True
b. False
