A scheduler facilitates data isolation to ensure that two transactions do not update the
same data element at the same time.
a. True
b. False
In organizations that generate large number of transactions,____________ are often a
top priority in database design.
a. relationships among entities
b. logical design standards
c. naming conventions
d. high processing speeds
To analyze the company situation, the database designer must discover what the
company’s operational components are, how they function, and how they interact.
a. True
b. False
A(n)___________ exists when there are functional dependencies such that Y is
functionally dependent on X, Z is functionally dependent on Y, and X is the primary
key.
a. partial dependency
b. repeating group
c. atomic attribute
d. transitive dependency
A data warehouse can store data derived from many sources.
a. True
b. False
A distributed database management system (DDBMS) must be
communications-media-dependent.
a. True
b. False
Knowing the minimum and maximum number of___________ occurrences is very
helpful at the application software level.
a. object
b. attribute
c. data
d. entity
A remote transaction, composed of several requests, may access data at multiple sites.
a. True
b. False
_______________CASE tools provide support for the coding and implementation
phases.
a. Front-end
b. Back-end
c. Vertical
d. Horizontal
The COUNT function is designed to tally the number of non-null “values” of an
attribute, and is often used in conjunction with the DISTINCT clause.
a. True
b. False
All transaction management commands are processed during the parsing and execution
phases of query processing.
a. True
b. False
A diskpage, or page, is the equivalent of a____________ .
a. database table
b. disk sector
c. database schema
d. diskblock
Nonoverlapping subtypes are subtypes that contain a(n)________ subset of the
supertype entity set.
a. entity
b. subtypes
c. unique
d. nonunique
Automating business procedures and automatically maintaining data integrity and
consistency are trivial in a modern business environment.
a. True
b. False
From a system functionality point of view, __________attribute values can be
calculated when they are needed to write reports or invoices.
a. derived
b. atomic
c. granular
d. historical
An attribute that is part of a key is known as a(n)__________ attribute.
a. important
b. nonprime
c. prime
d. entity
Data redundancy produces data anomalies.
a. True
b. False
An enterprise database can be defined as the company’s data representation that
provides support for all present and expected future operations.
a. True
b. False
The practical significance of taking the logical view of a database is that it serves as a
reminder of the simple file concept of data storage.
a. True
b. False
The Systems Development Life Cycle (SDLC) is a sequential process rather than an
iterative process.
a. True
b. False
The completeness constraint can be partial or total.
a. True
b. False
The SQL aggregate function that gives the number of rows containing non-null values
for a given column is____________________.
a. COUNT
b. MIN
c. MAX
d. SUM
__________________is a higher-level, object-oriented application interface used to
access remote database servers.
a. UDA
b. ODBC
c. DAO
d. RDO
When an organization employs both a DA and a DBA, the DA’s job has a technical
orientation, whereas the DBA’s job has a managerial orientation.
a. True
b. False
A(n) _________database supports a relatively small number of users (usually fewer
than 50) or a specific department within an organization.
a. desktop
b. workgroup
c. enterprise
d. transactional
Distributed processing shares a database’s logical processing among two or more
physically independent sites that are connected through a network.
a. True
b. False
_____________is the process of determining the data storage organization and data
access characteristics of the database to ensure its integrity, security, and performance.
a. Conceptual design
b. Network design
c. Logical design
d. Physical design
A consistent database state is__________ .
a. one in which all tables have foreign keys
b. one in which all data integrity constraints are satisfied
c. one in which all tables are normalized
d. one in which all SQL statements only update one table at a time
In-memory database systems are optimized to store small portions of the database in
disk storage alone.
a. True
b. False
Normalization represents a micro view of the___________ within the ERD.
a. entities
b. attributes
c. relationships
d. forms
The transaction recovery write-ahead-log protocol ensures that transaction logs are
always written before any database data are actually updated.
a. True
b. False
____________________not only helps database designers to stay on track during the
design process, it also enables them to pick up the design thread when the time comes
to modify the design.
In a basic distributed processing environment, the distributed processing system shares
the database chores among three sites connected through a______________ .
_____ is a measurement of the density of the data held in the data cube and is computed
by dividing the total number of actual values in the cube by the total number of cells in
the cube.
____________relationships cannot be implemented as such in the relational model.
Why do we need to optimize a DBMS with SQL performance tuning, even though they
automatically optimize SQL queries?
From a database point of view, the collection of data becomes meaningful only when
the ___________are defined.
What is a weak relationship? Provide an example.
An entity cluster is considered “virtual” or “_________ ” in the sense that it is not
actually an entity in the final ERD.
What is a subquery? When is it used? Does the RDBMS deal with subqueries any
differently from normal queries?
Describe what metadata are and what value they provide to the database system.
What are the three basic techniques to control deadlocks?
The_______________ scenario is typical of most mainframe and midrange
UNIX/LINUX server database management systems (DBMS).
The Microsoft____________ framework is a component-based platform for developing
distributed, heterogeneous, interoperable applications aimed at manipulating any type
of data over any network under any operating system and any programming language.
Using the__________ command, SQL indexes can be created on the basis of any
selected attribute.
A(n)_________________ is a specific request issued to the DBMS for data
manipulation.
Explain the differences between a centralized and decentralized approach to database
design.
What are the four different types of results that can be returned from a subquery?
The____________ hierarchy provides the capability to perform drill-down and roll-up
searches in a data warehouse.
Explain how database designers design and normalize databases.