Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Storing ____________________ attributes requires constant maintenance.
The database administrator must be prepared to perform routine maintenance activities
within the database.
You can select partial table contents by naming the desired fields and by placing
restrictions on the rows to be included in the output.
Date procedures are often more software-specific than other SQL procedures.
The DO-UNDO-REDO protocol defines three types of operations. What are they?
What is a weak relationship? Provide an example.
Each column in a relation represents a(n) ____________________.
In the relational model, ____________________ are important because they are used to
ensure that each row in a table is uniquely identifiable.
Most multiuser ______________________________ automatically initiate and enforce
locking procedures, where all locking information is managed by the lock manager.
Procedural code is executed on the database client machine.
A(n) ____________________ is a collection of similar objects with a shared structure
and behavior.
Many organizations rely on their IT departments to create universal data access
architectures based on Internet standards.
How should storage volumes be allocated for indexes, system, and high-usage tables?
A dependency of one nonprime attribute on another nonprime attribute is a partial
dependency.
A(n) ____________________ log backup backs up only the transaction log operations
that are not reflected in a previous backup copy of the database.
A(n) ____________________ links tables on the basis of an equality condition that
compares specified columns of each table.
Cursors are held in a reserved memory area in the client computer.
Working with data in the data cache is many times faster than working with data in the
data files.
The Chen notation identifies the weak entity by using a double-walled entity
____________________.
