Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
An alias is especially useful when a table must be joined to itself in a(n)
____________________ query.
XML is derived from the _____________________________________________, an
international standard for the publication and distribution of highly complex technical
documents.
A(n) ____________________ in a hierarchical model is the equivalent of a record in a
file system.
The relational model is hardware-dependent and software-independent.
One disadvantage of the DBMS is that it increases the risk of data security breaches.
To delete an index, use the ____________________command.
A(n) ____________________ is a logical group of database objects, such as tables and
indexes, that are related to each other.
Explain the difference between simple and composite attributes. Provide at least one
example of each.
After the initial declarations in a study, the database designer must carefully probe in
order to generate additional information that will help define the problem within the
larger framework of company operations.
PL/SQL functions are executed in the same way as functions such as MIN and AVG.
The NEXT command for a cursor is used to retrieve a row from the cursor and place it
in the respective PL/SQL variables.
In object-oriented terms, a(n) ____________________ defines an object's behavior.
The decision support database query optimizer must be enhanced to support
non-normalized structures.
Data redundancies occur from ____________________ of data on every row entry.
Systems analysis is used to determine the need for an information system and to
establish its limits.
____________________ refers to the level of detail represented by the values stored in
a table's row.
The problem with transitive dependencies is that they still yield data
____________________.
A(n) ____________________ develops when all required changes in the redundant
data are not made successfully.
Facts can be computed or derived at run time.
A weak entity has a primary key that is partially or totally derived from the parent entity
in the relationship.
