Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
____________________ databases focus primarily on storing data used to generate
information required to make tactical or strategic decisions.
A data ____________________ is a centralized, consolidated database that integrates
data derived from the entire organization and from multiple sources with diverse
formats.
A shared lock produces no conflict as long as all the concurrent transactions are
read-write only.
Atomicity indicates the permanence of the database's consistent state.
You should always load data from the 1 side of a 1:M relationship.
Most real-world database transactions are formed by only one database request.
The SQL execution activities are performed by the query optimizer.
Describe the three parts involved in any SQL-based relational database application.
Security breaches can yield a database whose integrity is either preserved or corrupted.
The database contents may be loaded interactively or in ____________________ mode.
What is a key and why is it important in the relational model?
Most SQL implementations yield case-insensitive searches.
Software vendors have adopted the Chen representation because of its compact
representation.
A good API makes it easy to develop a program by providing all of the building blocks.
Describe the characteristics of an Oracle sequence.
To provide better performance, some OLAP systems merge the data warehouse and data
mart approaches by storing small extracts of the data warehouse at end-user
workstations.
The DBMS reveals much of the database's internal complexity to the application
programs and users.
A DDBMS governs the storage and processing of logically related data over
interconnected computer systems.
When using a subquery, the output of a(n) ____________________ query is used as the
input for the outer query.
