Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
The ____________________ cache is a shared, reserved memory area that stores the
most recently executed SQL statements or PL/SQL procedures, including triggers and
functions.
What are database checkpoints?
Business rules must be rendered in writing.
ODBC is ____________________'s implementation of a superset of the SQL Access
Group CLI.
The detailed systems design phase includes all the necessary technical specifications for
the screens, menus, reports, and other devices used to make the system more efficient.
Any attribute whose value determines other values within a row is called a(n)
____________________.
Normalizing fact tables improves data access performance and saves data storage space.
M:N relationships are not appropriate in a relational model.
The Microsoft ____________________ frameworkis a component-based platform for
developing distributed, heterogeneous, interoperable applications aimed at manipulating
any type of data over any network under any operating system and any programming
language.
To work with data, the DBMS must retrieve the data from permanent storage and place
it in RAM.
Data integrity is enforced by the DBMS through the proper use of primary and foreign
key rules.
From a data modeling point of view, ____________________ data refer to data whose
values change over time and for which you must keep a history of the data changes.
It is possible for a table in 2NF to exhibit transitive dependency, where the primary key
may rely on one or more nonprime attributes to functionally determine other nonprime
attributes.
At the implementation level, the supertype and its subtype(s) depicted in the
specialization hierarchy maintain a 1:1 relationship.
Indexes do not facilitate join operations.
What are the sources of business rules, and what is the database designer's role with
regard to business rules?
