The SQL command that allows a user to permanently save data changes
is______________ .
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
The _____________data type is compatible with NUMBER.
a. VARCHAR(15)
b. SMALLINT
c. DATE
d. CHAR(10)
A relational table must not contain a(n)______________ .
a. entity
b. attribute
c. relationship
d. repeating group
Indexes are very useful in small tables or tables with low sparsity.
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 and display the
results in a column labeled TOTVALUE?
a. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH*P_PRICE AS TOTVALUE
FROM PRODUCT;
b. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH=P_PRICE AS TOTVALUE
FROM PRODUCT;
c. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH/P_PRICE AS TOTVALUE
FROM PRODUCT;
d. SELECT P_DESCRIPT, P_QOH, P_PRICE, P_QOH-P_PRICE AS TOTVALUE
FROM PRODUCT;
A database language enables the user to perform complex queries designed to transform
the raw data into useful information.
a. True
b. False
One of the advantages of a distributed database management system (DDBMS) is that
the data is located near the site with the least demand.
a. True
b. False
A(n)_____________ database is used by an organization and supports many users
across many departments.
a. desktop
b. workgroup
c. enterprise
d. transactional
Connectivities and cardinalities are established by concise statements known as
business rules.
a. True
b. False
A(n) __________data dictionary is not updated automatically and usually requires a
batch process to be run.
a. active
b. passive
c. static
d. dynamic
Serializability means that data used during the execution of a transaction cannot be used
by a second transaction until the first one is completed.
a. True
b. False
Extending the web server functionality implies that the web server and the
web-to-database middleware will properly communicate with each other.
a. True
b. False
The maintenance and evolution phase of the Database Life Cycle (DBLC)
involves_____________ .
a. defining objectives
b. introducing changes
c. testing the database
d. installing the DBMS
Which of the following queries will output the table contents when the value of
V_CODE is not equal to 21344?
a. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <> 21344;
b. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE <= 21344;
c. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE = 21344;
d. SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT
WHERE V_CODE => 21344;
All SQL commands must be issued on a single line.
a. True
b. False
When a table contains only one candidate key, ________________are considered to be
equivalent.
a. the 1NF and the 2NF
b. the 3NF and the BCNF
c. the 4NF and the 3NF
d. the BCNF and the DKNF
Most designers consider the BCNF as a special case of the______________________ .
a. 1NF
b. 2NF
c. 3NF
d. 4NF
A transaction_____ is a unit of work that must be either entirely completed or aborted.
a. timed
b. practical
c. logical
d. physical
In the context of database administration, standards are written instructions that
describe a series of steps to be followed during the performance of a given activity.
a. True
b. False
In RAID level 5,:
a. the data and the parity data are striped across separate drives.
b. the data blocks are spread over separate drives and are duplicated.
c. the array requires a minimum of two drives and is known as a striped array.
d. the array requires a minimum of five drives and is known as duplexing.
In Chen notation, there is no way to represent cardinality.
a. True
b. False
If an entity can exist apart from all of its related entities, then it is
existence-independent, and it is referred to as a(n)_________ entity.
a. weak
b. alone
c. unary
d. strong
Data and information are essentially the same thing.
a. True
b. False
In the context of the database design process, the conceptual design step that defines the
fragmentation and allocation strategy is__________ .
a. database analysis and requirements
b. ER modeling and normalization
c. data model verification
d. distributed database design
Coordinating, monitoring, and allocating database administration resources is included
in a DBA’s________ role.
a. operative
b. arbitration
c. technical
d. managerial
A table where every determinant is a candidate key is said to be in___________ .
a. BCNF
b. 2NF
c. 1NF
d. 4NF
The last step in the write-through technique recovery procedure is to identify the last
checkpoint in the transaction log.
a. True
b. False
The most likely data type for a surrogate key is__________ .
a. character
b. date
c. logical
d. numeric
The _______________statement combines rows from two queries and excludes
duplicates.
a. UNION
b. UNION ALL
c. INTERSECT
d. MINUS
The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of
coding, testing, and debugging.
a. True
b. False
From the performance point of view,___________ databases eliminate disk access
bottlenecks.
a. RAID
b. distributed
c. index-organized
d. in-memory
If an employee within an EMPLOYEE entity has a relationship with itself, that
relationship is known as a______________relationship.
a. self
b. self-referring
c. looping
d. recursive
To ensure consistency of the database, every transaction must begin with the database in
an unstable state.
a. True
b. False
Regardless of the type of web server interface used, a web-to-database____________
program must be able to connect with a database.
If integer values are relatively small, ___________must be used instead of INT.
PRODUCT yields all possible pairs of rows from two tables, also known as
the___________ product.
Composite keys are useful as identifiers of weak entities, where the weak entity has a
strong _________relationship with the parent entity.
______________is a term used to describe a comprehensive, cohesive, and integrated
set of tools and processes used to capture, collect, integrate, store, and analyze data with
the purpose of generating and presenting information used to support business decision
making.
Dr. Codd’s___________ rule of relational database states that every value in a table is
guaranteed to be accessible through a combination of table name, primary key value,
and column name.
______________are special instructions for the optimizer that are embedded inside the
SQL command text.
A(n) ________________is a brief, precise, and unambiguous description of a policy,
procedure, or principle within a specific organization.
The DBMS uses the_______________ to look up the required data component
structures and relationships, thus relieving programmers from having to code such
complex relationships in each program.
_________________is the term used to describe an environment in which the SQL
statement is not known in advance and is generated at run time.
_________________words are words used by SQL to perform specific functions.
___________________is the first stage in the database design process.
In the context of an organization’s managerial structure, ____________decisions are
short term and affect only daily operations; for example, deciding to change the price of
a product to clear it from inventory.
_____ are quantifiable measurements (numeric or scale based) that assess a company’s
effectiveness or success in reaching its strategic and operational goals.
Discuss some considerations when designing a database.
A(n)____________ is a relatively simple representation of more complex real-world
data structures.
_________________databases focus primarily on storing data used to generate
information required to make tactical or strategic decisions.
The____________ rule states that only one transaction at a time can own an exclusive
lock on the same object.