Which query will output the table contents when the value of P_PRICE is less than or
equal to 10?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE <> 10;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE <= 10;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE => 10;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE P_PRICE = 10;
The XML metalanguage allows the definition of new ____, such as <ProdPrice>, to
describe the data elements used in an XML document.
a. elements
b. tags
c. schemas
d. DTDs
There are currently ____ well-defined Web-server interfaces.
a. one
b. two
c. five
d. ten
____ is the bottom-up process of identifying a higher-level, more generic entity
supertype from lower-level entity subtypes.
a. Specialization
b. Generalization
c. Partial completeness
d. Total completeness
In Oracle, the ____ function converts a date to a character string.
a. CONVERT()
b. TO_DATE
c. TO_CHAR()
d. TO_STRING()
An entity is said to be ____-dependent if it can exist in the database only when it is
associated with another related entity occurrence.
a. existence
b. relationship
c. business
d. weak
In the ____ model, the basic logical structure is represented as an upside-down tree.
a. hierarchical
b. network
c. relational
d. entity relationship
A DBMS facilitates ____.
a. interpretation and presentation of data in useful formats
b. destruction of data and information to the right people at the right time
c. data presentation and data usage monitoring for adequate periods of time
d. automatic auditing of all data changes
If Tiny College had some departments that were classified as “research only,” they
would not offer courses; therefore, the COURSE entity would be ____ to the
DEPARTMENT entity.
a. existence-dependent
b. independent
c. weak
d. optional
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and
lower-level entity subtypes (child entities).
a. subtype discriminator
b. inheritance
c. specialization hierarchy
d. entity supertype
A distributed ____ allows a transaction to reference several different remote database
processing sites.
a. request
b. site
c. data location
d. transaction
A(n) ____ serves as the basis for planning, development, and control of future
information systems
a. access plan
b. active data dictionary
c. information systems architecture (ISA)
d. security policy
A(n) ____ specifically reserves access to the transaction that locked the object.
a. shared lock
b. exclusive lock
c. binary lock
d. deadlock
A(n) ____ condition occurs when two or more transactions wait for each other to
unlock data.
a. deadlock
b. exclusive lock
c. binary lock
d. two-phase lock
The set of possible values for an attribute is a ____.
a. domain
b. range
c. set
d. key
____________________are objects (applications or processes) that request and use
data.
Data ____________________ is a discipline that focuses on proper generation, storage
and retrieval of data.
____ 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
Structural dependence exists when it is possible to make changes in the file structure
without affecting the application program’s ability to access the data.
The preferred placement for a foreign key when working with a 1:1 relationship is to
____.
a. use the same primary key for both entities
b. create a bridge entity
c. place a foreign key in one of the entities
d. place a foreign key in both entities
____________________ exists when it is possible to make changes in the data storage
characteristics without affecting the application program’s ability to access the data.
____ is the delay imposed by the amount of time required for a data packet to make a
round trip from point A to point B.
a. Data distribution
b. Replica transparency
c. Network latency
d. Network partitioning
Several DBMS packages contain features that allow the creation of a(n) ____, which
automatically records a brief description of the database operations performed by all
users.
a. change tracker
b. digital footprint
c. paper trail
d. audit log
The ____ attribute(s) make up the primary key in the table definition:
CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM,
PROF_NUM)
a. CRS_CODE
b. CLASS_SECTION
c. CRS_CODE and CLASS_SECTION
d. There is no primary key
Another word for existence-independent is ____.
a. weak
b. alone
c. unary
d. strong
The phrase ____ refers to an organization of components that define and regulate the
collection, storage, management and use of data within a database environment.
a. database management system
b. database management
c. management system
d. database system
Classifying users into ____ according to common access needs facilitates the DBA’s job
of controlling and managing the access privileges of individual users.
a. user groups
b. sections
c. authorization schemes
d. policy definitions
Although the conceptual model can handle ____ relationhips and multivalued attribues,
you should not implement them in the RDBMS.
a. 1:1
b. M:N
c. 1:M
d. 1:N
XML data is ____.
a. structured
b. multistructured
c. unstructured
d. semistructured
In subquery terminology, the first query in the SQL statement is known as the ____
query.
a. outer
b. left
c. inner
d. base
____ is a relational set operator.
a. MINUS
b. PLUS
c. ALL
d. EXISTS
A composite identifier is a primary key composed of more than one attribute.
The BI architecture is composed of data, people, processes, technology, and the
management of such components.
The traditional SDLC phases are ____________________, analysis, detailed systems
design, implementation, and maintenance.
In practice, _________________________ provides a well-orchestrated framework for
the management of data that works across all levels of the organization.
The ____________________ provides the big picture, or macro view, of an
organization’s data requirements and operations.
In the relationship “EMPLOYEE claims DEPENDENT” the DEPENDENT entity is
____________________ on the EMPLOYEE entity.
The DBA’s function includes educating the ____________________ in the services
provided and how those services enhance data stewardship and data security.
What steps are involved in the conversion to third normal form?
Instead of storing a person’s age, it is better to store the date of birth and use the
difference between that value and the system date as a(n) ____________________
attribute.
Making sure that the final product meets user and system requirements is the most
critical ______________________________ phase.
Database designs that fail to recognize that the database is part of a larger information
system are not likely to be successful.
Periodicity, usually expressed as current year only, previous years, or all years, provides
information about the time span of the data stored in the table.
A field-level lock allows concurrent transactions to access the same row, as long as they
require the use of different fields within that row.
Database backups can be performed at different levels. List and describe these.
An explicit cursor must return two or more rows.