Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
A data dictionary is sometimes described as "the database designer's database" because
it records the design decisions about tables and their structures.
Describe the use of the UNION operator.
____________________ management ensures that data move from one consistent state
to another, including synchronization of local and remote transactions.
In a DDBMS, ____________________ occurs to determine the data location of local
and remote fragments.
The advent of the DBMS and its shared view of data produced a new level of data
management sophistication and led the DP department to evolve into a(n)
_________________________ department.
Testing procedures and standards must already be in place before any application
program can be approved for use in the company.
An API uses script files that perform specific functions on the client's parameters that
are passed to the Web server.
The term "module ____________________" describes the extent to which modules are
independent of one another.
The SELECT operator yields a vertical subset of a table.
SQL supports the conditionalexecution of procedures (if...then...else statements) that are
typically supported by a programming language.
In Chen notation, entities and relationships must be oriented horizontally.
A common practice is to create a(n) ____________________ on any field that is used
as a search key, in comparison operations in a conditional expression, or when you want
to list rows in a specific order.
____________________ design could become a very technical job that affects not only
the accessibility of the data in the storage device(s) but also the performance of the
system.
When a nonkey attribute is the determinant of a key attribute the table is in 3NF but not
____________________.
PL/SQL blocks have a section used to declare variables.
The result of analysis should be a better understanding of the system's functional areas,
actual and potential problems, and opportunities.
The testing and evaluation phase occurs after applications programming.
An optimistic approach is based on the assumption that the majority of the database
operations do not conflict.
