Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
____ provide(s) a description of the data characteristics and the set of relationships that
link the data found within the database.
a. Queries
b. End-user data
c. Metadata
d. Information
Business rules are derived from ____.
a. a detailed description of an organization's operations
b. standards and practices developed over the years
c. managers' recommendations
d. governmental oversight organization standards
Controlled ____ makes a relational database work.
a. relations
b. logic
c. chaos
d. redundancy
The ____ manager is responsible for assigning and policing the locks used by the
transactions.
a. transaction
b. database
c. lock
d. schedule
____ are required to prevent another transaction from reading inconsistent data.
a. Locks
b. Schedules
c. Stamps
d. Logs
In the context of a database table, the statement "A ____ B" indicates that if you know
the value of attribute A, you can look up the value of attribute B.
a. contains
b. is related to
c. owns
d. determines
The ____ table space is used to store end-user data.
a. system
b. user data
c. temporary
d. rollback segment
____ relationships are most common.
a. Unary
b. Binary
c. Ternary
d. Higher-degree
To list all the contents of the PRODUCT table, you would use ____.
a. LIST * FROM PRODUCT;
b. SELECT * FROM PRODUCT;
c. DISPLAY * FROM PRODUCT;
d. SELECT ALL FROM PRODUCT;
Partial completeness is symbolized by ____.
a. a dotted line
b. two dashed lines
c. a circle over a single line
d. a circle over a double line
The ____ special operator is used to check whether an attribute value is null.
a. BETWEEN
b. IS NULL
c. LIKE
d. IN
Client-side extensions are available in various forms, such as ____.
a. COBOL
b. Java and JavaScript
c. Visual Basic .NET
d. Visor.Net
The majority of primary memory resources will be allocated to the ____ cache.
a. data
b. SQL
c. sort
d. optimizer
____ databases reflect the ever-growing demand for greater scope and depth in the data
on which decision support systems increasingly rely.
a. Normalized
b. Data warehouse
c. Temporary
d. Report
____ CASE tools provide support for the coding and implementation phases.
a. Front-end
b. Back-end
c. Vertical
d. Horizontal
The following step occurs first in the process of building an ERD: ____.
a. Develop the initial ERD.
b. Create a detailed narrative of the organization's description of operations.
c. Identify the attributes and primary keys that adequately describe the entities.
d. Identify the business rules based on the description of operations.
A(n) ____ is a query that is embedded (or nested) inside another query.
a. alias
b. operator
c. subquery
d. view
____ keys work with primary keys to properly implement relationships in the relational
model.
a. Foreign
b. Composite
c. Natural
d. Surrogate
Decision support data tend to be non-normalized, ____, and pre-aggregated.
a. unique
b. duplicated
c. relational
d. sorted
An atomic attribute ____.
a. cannot exist in a relational table
b. cannot be further subdivided
c. displays multiplicity
d. is always chosen to be a foreign key
____ refers to the number of different values a column could possibly have.
a. Database statistics
b. Data sparsity
c. Primary keys
d. Query optimization
The database is loaded during the ____ phase of the SDLC.
a. analysis
b. detailed systems design
c. implementation
d. maintenance
The ____ statement in SQL combines rows from two queries and returns only the rows
that appear in the first set but not in the second.
a. UNION
b. UNION ALL
c. INTERSECT
d. MINUS
A transaction is a ____ unit of work that must be either entirely completed or aborted.
a. timed
b. practical
c. logical
d. physical
The ERD represents the ____ database as viewed by the end user.
a. condensed
b. physical
c. logical
d. conceptual
According to naming conventions described in Chapter 2, ____ would be the best name
for a column representing the charges per hour in a table named JOB.
a. JOB_CHG_HOUR
b. CHARGES_PER_HOUR_FOR_JOB
c. CHARGES_PER_HOUR
d. CHG_HR
Codd's Rule of ____ states:
If the system supports low-level access to the data, users must not be allowed to bypass
the integrity rules of the database
a. Nonsubversion
b. Logical Data Independence
c. Comprehensive Data Sublanguage
d. Integrity Independence
A(n) ____ database is used by an organization and supports many users across many
departments.
a. desktop
b. workgroup
c. enterprise
d. transactional
The relational model's creator, E. F. Codd, used the term relation as a synonym for
____.
a. index
b. key
c. table
d. relationship
An attribute that is part of a key is known as a(n) ____ attribute.
a. important
b. nonprime
c. prime
d. entity
____ are general statements of direction or action that communicate and support DBA
goals.
a. Standards
b. Policies
c. Documentation
d. Procedures
Conceptually, MDBMS end users visualize the stored data as a three-dimensional cube
known as a ____.
a. multi cube
b. data matrix
c. data cube
d. hyper cube
Explain the transaction log. What is its function?
Queries against operational data typically are broad in scope and high in complexity.
The implementation of the logical design in IBM's DB2 would require that you assign
the rights to use the database to a(n) _________________________.
The end user's role requires a broad understanding of DBMS functions, configuration,
programming languages, data modeling and design methodologies, and so on.
The DBMS can easily handle multivalued attributes.
Database programming languages receive all application requests and translate them
into the complex operations required to fulfill those requests.
Multidimensional data analysis techniques include advanced computational functions.
Describe the five types of users identified in a database system.
In SQL, all ____________________ expressions evaluate to true or false.
____________________ transactionsthe sale of products or servicescan take place
between businesses or between a business and a consumer.
The ER model refers to a specific table row as an entity instance.
Database transaction ____________________ restores a database from an inconsistent
state to a previously consistent state.
The ____________________ hierarchy provides the capability to perform drill-down
and roll-up searches in a data warehouse.
An alternate syntax for a join is SELECT column-list FROM table1 JOIN table2
____________________ (common-column).
The security, privacy, and integrity of the data in the database are of minimal concern to
DBAs who manage current DBMS installations.
During the testing phase, the system is subjected to exhaustive testing until it is ready
for use.
To remedy the lack of procedural functionality in SQL, and to provide some
standardization within the many vendor offerings, the SQL-99 standard defined the use
of persistent stored modules.
