A(n) ____________________ relationship is also known as an identifying relationship.
Cursor-style processing involves retrieving data from the cursor, one row at a time.
Generalization is based on grouping unique characteristics and relationships of the
subtypes.
In a relational model, if A determines B, C, and D, you write A = B, C, D.
What are the main types of objects in the OLE-DB model?
Rows can be grouped into smaller collections quickly and easily using the SQL
____________________ clause.
What is a server-side extension?
Specialization is based on grouping ____________________ characteristics and
relationships of the subtypes.
A left outer joinon tables CUSTOMER and AGENT yields all of the rows in the
CUSTOMER table, including those that do not have a matching value in the AGENT
table.
To support a(n) ____________________ adequately, the DBMS might be required to
use advanced hardware, such as multiple disk arrays, and even more importantly, to
support multiple-processor technologies, such as a symmetric multiprocessor (SMP) or
a massively parallel processor (MPP).
The last step in the write-through technique recovery procedure is to identify the last
checkpoint in the transaction log.
Incomplete or improper transactions can have a devastating effect on database integrity.
Placing the DBA function in a(n) ____________________ position often creates a
consulting environment in which the DBA is able to devise the data administration
strategy but does not have the authority to enforce it or to resolve possible conflicts.
The system’s ____________________ defines the extent of the design according to
operational requirements.
A full backup, or database dump, produces a complete copy of the entire database.
What is a data mart? Why do some organizations prefer to create a data mart rather than
a data warehouse?
Operational data and decision support data serve the same purpose.
Fully equivalent means that the optimized query results are always the same as the
original query.