Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
According to Codd's________ rule of relational database, "If the system supports
lowlevel access to the data, users must not be allowed to bypass the integrity rules of
the database."
a. nonsubversion
b. rule zero
c. view updating
d. information
____________is a cursor attribute that returns TRUE if the last FETCH returned a row,
and FALSE if not.
a. %ROWCOUNT
b. %NOTFOUND
c. %FOUND
d. %ISOPEN
A distributed database is composed of several parts known as
database_______________ .
a. sections
b. fragments
c. partitions
d. parts
Generalization is based on grouping unique characteristics and relationships of the
subtypes.
a. True
b. False
____________transparency ensures that the system will continue to operate in the event
of a node or network malfunction.
a. Transaction
b. Distribution
c. Failure
d. Performance
Mathematical operators cannot be used to place restrictions on character-based
attributes.
a. True
b. False
An inequality condition is also known as a natural join and an equality condition is also
called a theta join.
a. True
b. False
A(n)_________ is bidirectional.
a. attribute
b. entity
c. relationship
d. constraint
The__________ model is the end users' view of the data environment.
a. abstract
b. external
c. conceptual
d. internal
All relational tables satisfy the 1NF requirements.
a. True
b. False
In the context of SELECT subquery types, a_______________ is returned when an
UPDATE subquery is used.
a. NULL
b. single value
c. list of values
d. virtual table
Periodicity, usually expressed as current year only, previous years, or all years, provides
information about the time span of the data stored in a table.
a. True
b. False
In the context of the data-information-decision cycle, decisions made by high-level
managers trigger actions in an organization's:
a. lower levels.
b. top levels.
c. target markets.
d. customer base.
Another name for a composite entity is a(n)___________ entity.
a. bridge
b. linked
c. directive
d. associative
_____ provide a unified, single point of entry for information distribution.
a. Decision support systems
b. Portals
c. Data warehouses
d. Dashboards
One of the disadvantages of stored procedures is that they increase network traffic.
a. True
b. False
The SQL aggregate function that gives the total of all values for a selected attribute in a
given column is____________________.
a. COUNT
b. MIN
c. MAX
d. SUM
A(n)__________ is a restriction placed on the data.
a. attribute
b. entity
c. relationship
d. constraint
Business rules must be rendered in writing.
a. True
b. False
A(n) _____________phase in a two-phase lock is when a transaction releases all locks
and cannot obtain any new lock.
a. growing
b. shrinking
c. locking
d. unlocking
The hierarchical model is software-independent.
a. True
b. False
Based on Microsoft's Component Object Model (COM),__________ is database
middleware that adds objectoriented functionality for access to relational and
nonrelational data.
a. MS-DB
b. OLE-DB
c. COM-DB
d. ODBC
A passive data dictionary is one that is updated automatically with every database
access to keep its access information up to date.
a. True
b. False
Cursor-style processing involves retrieving data from the cursor, one row at a time.
a. True
b. False
Date attributes contain calendar dates stored in a special format known as
the___________ date format.
a. Epoch
b. calendar
c. Julian
d. logical
In standard SQL, the optimizer hint ALL_ROWS is generally used for______________
mode processes.
a. interactive
b. real-time
c. batch
d. transaction
One disadvantage of the DBMS is that it increases the risk of data security breaches.
a. True
b. False
An advantage of database systems is that you needn"t perform frequent updates and
apply latest patches.
a. True
b. False
The information stored in the is used by the DBMS for a recovery requirement
triggered by a ROLLBACK statement, a program's abnormal termination, or a system
failure such as a network discrepancy or a disk crash.
a. data dictionary
b. metadata
c. rollback manager
d. transaction log
One of the important functions provided by the database________________ is to
reserve the resources that must be used by the database at run time.
a. security component
b. authorization manager
c. initialization parameters
d. administrator
Based on the type of decision-making support required, database users may be
classified into: operational, tactical, or _____.
In MS Access, a designer can use the____________ data type to define a column in his
table that will be automatically populated with unique numeric values.
_____________functions extract a value of a given data type and convert it to the
equivalent value in another data type.
What are the problems associated with file systems? How do they challenge the types
of information that can be created from the data as well as the accuracy of the
information?
