Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Describe specialization and generalization.
Current relational database software generally provides only a system catalog (and not a
data dictionary).
The Web server is the main hub through which all Internet services are accessed.
ODBC, OLE-DB, and ADO.NET form the backbone of the
______________________________ architecture.
Data warehouse data are organized and summarized by table, such as CUSTOMER and
ADDRESS.
When you ____________________ data, you are aggregating the data to a higher level.
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?
A(n) ____________________ attribute need not be physically stored within the
database.
Describe what metadata are and what value they provide to the database system.
The same data might be simultaneously structured and unstructured depending on the
intended processing.
The logical view of the relational database is facilitated by the creation of data
relationships based on a logical construct known as a(n) ____________________.
A transaction processor is the software component residing on each computer that
stores and retrieves data located at the site.
The ____________________ rule states that only one transaction at a time can own an
exclusive lock on the same object.
The conditional LIKE must be used in conjunction with wildcard characters.
To determine the appropriate order of the operations, the scheduler bases its actions on
concurrency control algorithms, such as ____________________ or time stamping
methods.
The only way to access the data in a database is through the DBMS.
XML tags must be well formed; that is, each opening tag has a corresponding
____________________ tag.
The combination of ____________________ and ER modeling yields a useful ERD,
whose entities may now be translated into appropriate table structures.
In a real-world environment, changing granularity requirements might dictate changes
in primary key selection, and those changes might ultimately require the use of
____________________ keys.
