Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
In the SQL environment, the word ____________________covers both questions and
actions.
In order to develop an accurate data ____________________, the designer must have a
thorough understanding of the company's data types, extent, and uses.
Triggers are critical to proper database operation and management. What are some of
the ways that triggers are used?
The SDLC provides the big picture within which the database design and application
development can be mapped out and evaluated.
A(n) ____________________ is a specific request issued to the DBMS for data
manipulation.
Tables within a database share common attributes that enable the tables to be linked
together.
You cannot insert a row containing a null attribute value using SQL.
Codd's rule of ____________________ states that every value in a table is guaranteed
to be accessible through a combination of table name, primary key value, and column
name.
One of the advantages of a DDBMS is less danger of a single-____________________
failure.
Decision support data are a snapshot of the operational data at a given point in time.
In a DDBMS, ____________________ control is used to manage simultaneous data
access and ensure data consistency across database fragments.
SAP is a portal vendor.
The advantage of higher processing speed must be carefully weighed against the
disadvantage of data anomalies.
In order to meet ____________________ requirements, you may have to denormalize
some portion of the database.
Attributes should clearly define participation, connectivity, and document cardinality.
Tables must have the same attribute characteristics (the columns and domains must be
compatible) to be used in a UNION.
DBMS implementations are typically similar in complexity to two-tier client/server
configurations.
