Denormalization produces a lower normal form.
a. True
b. False
The process of database design is a sequential process.
a. True
b. False
“Linked SQL” is a term used to refer to SQL statements that are contained within an
application programming language such as COBOL, C++, ASP, Java, or ColdFusion.
a. True
b. False
Among client-side extensions,______________ is a Microsoft specification for writing
programs that run inside the Internet Explorer browser.
a. COBOL
b. ActiveX
c. JavaScript
d. Visor.Net
Which of the following queries 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;
Database connectivity software is also known as database middleware because it
interfaces between the application program and the database.
a. True
b. False
Field refers to a collection of related records.
a. True
b. False
Data type selection is usually dictated by the nature of the data and by the intended use.
a. True
b. False
Testing procedures and standards must already be in place before any application
program can be approved for use in the company.
a. True
b. False
The___________ rule requires that all copies of data fragments be identical.
a. shared fragment
b. mutual consistency
c. horizontal fragmentation
d. replication
Which of the following is a hardware-induced database failure?
a. Memory chip errors
b. Viruses
c. Malware
d. Abortion due to deadlock
_________________is the central activity during the parsing phase in query processing.
a. Clustering
b. Partitioning
c. Query validation
d. Query optimization
Protecting the security and integrity of a database is a function of authorization
management.
a. True
b. False
The use of HTML does not equip a web browser with computational abilities beyond
formatting output text and accepting form field inputs.
a. True
b. False
Using index characteristics, a database designer can determine the best type of index to
use.
a. True
b. False
Cursors are held in a reserved memory area in the client computer.
a. True
b. False
In the____________ model, the user perceives the database as a collection of records in
1:M relationships, where each record can have more than one parent.
a. hierarchical
b. network
c. object-oriented
d. entity relationship
The__________ cache is used as a temporary storage area for ORDER BY or GROUP
BY operations, as well as for index-creation functions.
a. data
b. SQL
c. sort
d. optimizer
________________code is embedded inside an HTML page and is activated by
triggering events such as clicking on a link.
a. XML
b. SQL
c. Visual Basic
d. VBScript
A table that is in 1NF and includes no partial dependencies is said to be
in______________ .
a. BCNF
b. 2NF
c. 3NF
d. 4NF
A(n)__________ can use a shared connection to the database instead of creating a new
one every time.
a. DLL
b. API
c. web browser
d. HTTP GET request
In specialization hierarchies with multiple levels of supertype and subtypes, a
lower-level subtype can inherit only a few of the attributes and relationships from its
upper-level supertypes.
a. True
b. False
Atomicity indicates the permanence of the database’s consistent state.
a. True
b. False
The term “database development” is used to describe the process of database design and
implementation.
a. True
b. False
________________transparency allows the integration of several different local
database management systems (DBMS) under a common, or global, schema.
a. Transaction
b. Performance
c. Distribution
d. Heterogeneity
An entity cluster is a “virtual” entity type used to represent multiple entities and
relationships in the ERD.
a. True
b. False
The implementation phase of database design includes creating the database storage
structure and loading the database, but does not provide for data management.
a. True
b. False
_________________is a type of cloud infrastructure that is built by a third-party
organization to sell cloud services to the general public.
a. Community
b. Public
c. Exclusive
d. Private
The term_____ refers to an organization of components that define and regulate the
collection, storage, management and use of data within a database environment.
a. structured data
b. transaction
c. management system
d. database system
A table that has all key attributes defined, has no repeating groups, and all its attributes
are dependent on the primary key is said to be in__________ .
a. 1NF
b. 2NF
c. 3NF
d. 4NF
The testing and evaluation phase of the Database Life Cycle (DBLC) occurs after
applications programming.
a. True
b. False
A(n)________ attribute is an attribute that must have a value.
To determine the appropriate order of the operations, the scheduler bases its actions on
concurrency control algorithms, such as___________ or time stamping methods.
If a(n)_____________ is issued before the termination of a transaction, the DBMS will
restore the database only for that particular transaction, rather than for all transactions,
in order to maintain the durability of the previous transactions.
A___________ occurs when a relationship is improperly or incompletely identified and
is therefore represented in a way that is not consistent with the real world.
List and describe the different levels at which database backups can be performed.
How does a shared/exclusive lock schema increase the lock manager’s overhead?
The scheduler’s main job is to create a(n) _______________of a transaction’s operation,
in which the interleaved executions of transactions yield the same results as if the
transactions were executed in serial order.
A(n)_____________ subquery is a subquery that executes once for each row in the
outer query.
A data _____ is a centralized, consolidated database that integrates data derived from
the entire organization and from multiple sources with diverse formats.
A(n)______________ is a spur-of-the-moment question.
What is transaction transparency? What are some of the basic concepts that one should
know to understand how transactions are managed in a distributed database
management system (DDBMS)?
A__________ is good for simple and fast lookup operations based on equality
conditions.
Uniqueness ensures that no equal time stamp values can exist, and__________ ensures
that time stamp values always increase.
The testing and evaluation of a database application cover all aspects of the systemfrom
the simple collection and creation of data to its use and retirement. What is covered by
the evaluation process?
The provides the big picture, or macro view, of an organization’s data requirements and
operations.
The term________ describes the strength of the relationships found among a module’s
entities.
One characteristic of generalization hierarchies is that they are implemented as
_____________relationships.
What is a ternary relationship? Provide some business rules examples that specify the
need for a ternary or higher- order relationship.
When selecting DBMS ______________, items to consider include processors, RAM,
and disk space.