This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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.
Trusted by Thousands of
Students
Here are what students say about us.
Resources
Company
Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.