The ____ table space is used for transaction-recovery purposes.
a. system
b. user data
c. temporary
d. rollback segment
Non-overlapping subtypes are subtypes that contain a(n) ____ subset of the supertype
entity set.
a. entity
b. subtypes
c. unique
d. nonunique
____ requires that all operations of a transaction be completed.
a. Specificity
b. Atomicity
c. Durability
d. Time stamping
A stored function uses the ____ statement to return a value.
a. EXIT
b. END
c. RETURN
d. PROCESS
The existence of a(n) ____ relationship indicates that the minimum cardinality is at
least 1 for the mandatory entity.
a. mandatory
b. optional
c. multivalued
d. single-valued
There are ____ classical approaches to database design.
a. two
b. three
c. four
d. five
A ____ contains the description of the entire database as seen by the database
administrator.
a. distributed global dictionary
b. distributed data dictionary
c. distributed global schema
d. distributed data schema
In 2006, ____ began using the term cloud computing to describe a new set of innovative
Web-based services.
a. Google and Amazon
b. Google and Sun
c. Microsoft and Sun
d. XML
The ____ function returns the current system date in MS Access.
a. TO_DATE()
b. SYSDATE()
c. DATE()
d. TODAY()
A ____ distributed database system will support different DBMSs that may even
support different models running under different computer systems.
a. fully heterogeneous
b. fully homogeneous
c. homogeneous
d. heterogeneous
The ____ table space is used to store the data dictionary tables.
a. system
b. user data
c. temporary
d. rollback segment
An entity cluster is formed by combining multiple interrelated entities into ____.
a. a single abstract entity object
b. multiple abstract entity objects
c. a single entity object
d. multiple entity objects
A derived attribute ____.
a. must be stored physically within the database
b. need not be physically stored within the database
c. has many values
d. must be based on the value of three or more attributes
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
The SQL query to output the contents of the EMPLOYEE table sorted by last name,
first name, and initial is ____.
a. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE LIST BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;
b. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE ORDER BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;
c. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE DISPLAY BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;
d. SELECT EMP_LNAME, EMP_FNAME, EMP_INITIAL, EMP_AREACODE,
EMP_PHONE FROM EMPLOYEE SEQUENCE BY EMP_LNAME, EMP_FNAME,
EMP_INITIAL;
____ is a disadvantage of a DDBMS.
a. Data is located near the “greatest demand” site
b. Growth facilitation
c. Danger of a single-point failure
d. Lack of standards
____ transparency allows a distributed database to be treated as a single logical
database.
a. Distribution
b. Transaction
c. Failure
d. Performance
As a manager, the DBA must concentrate on the ____ dimensions of the database
administration function.
a. control and planning
b. conflict and problem-resolution
c. policies and standards
d. security and privacy
Before converting a table into 3NF, it is imperative the table already be in ____.
a. 1NF
b. 2NF
c. 4NF
d. BCNF
Another name for a database server-side extension is ____.
a. a Web server
b. a Web application server
c. Web-to-database middleware
d. a database application server
The ____ operator could be used in place of MINUS if the RDBMS does not support it.
a. IN
b. NOT IN
c. AND
d. UNION
____ fragmentation refers to the division of a relation into subsets of tuples.
a. Vertical
b. Horizontal
c. Data
d. Mixed
There is a growing trend toward ____ in the data-management function.
a. cross-training
b. encapsulation
c. specialization
d. centralization
If there is no index, the DBMS will perform a ____ scan.
a. loop
b. range
c. row ID table access
d. full table
____activities cover all tasks directly related to the day-to-day operations of the DBMS
and its applications.
a. Backup and recovery
b. System support
c. Performance monitoring and tuning
d. Security auditing and monitoring
The design of the system’s processes is completed during the ____ phase of the SDLC.
a. planning
b. analysis
c. detailed systems design
d. implementation
The SQL command that modifies an attribute“s values in one or more table“s rows is
____.
a. INSERT
b. SELECT
c. COMMIT
d. UPDATE
If an employee within an EMPLOYEE entity has a relationship with itself, that
relationship is known as a ____ relationship.
a. self
b. self-referring
c. looping
d. recursive
The Web browser’s job is to ____the HTML code that it receives from the Web server.
a. analyze
b. interpret
c. transform
d. save
In a star schema, dimensions are normally stored in ____.
a. attributes
b. indexes
c. fact tables
d. dimension tables
One of the limitations of the ____ model is that there is a lack of standards.
a. hierarchical
b. network
c. relational
d. entity relationship
A ____ key is defined as a key that is used strictly for data retrieval purposes.
a. lookup
b. foreign
c. candidate
d. secondary
A ____ is an external application that is automatically invoked by the browser when
needed.
a. Web client
b. plug-in
c. Web service
d. Web server
A(n) ____ database is designed to support a company’s day-to-day operations.
a. desktop
b. workgroup
c. enterprise
d. transactional
Decentralized design is typical of relatively simple and/or small databases and can be
successfully done by a single person.
Raw data must be properly ____________________ for storage, processing and
presentation.
A(n) ____________________ is a relatively simple representation of more complex
real-world data structures.
HTML is designed to facilitate the exchange of structured documents, such as orders
and invoices, over the Internet.
_________________________ is a higher-level object-oriented application interface
used to access remote database servers.
ANSI-standard SQL allows the use of special operators in conjunction with the
WHERE clause.
The Web has helped create a new information dissemination standard.
____________________ completeness means that every supertype occurrence must be
a member of at least one subtype.
In the prognosis phase, the data-mining findings are used to predict future behavior and
forecast business outcomes.
Because a partial dependency can exist only if a table’s primary key is composed of
several attributes, a table whose ____________________ key consists of only a single
attribute is automatically in 2NF if it is in 1NF.
RAID systems use a single disk to create storage volumes.
An implicit cursor is automatically created in procedural SQL when the SQL statement
returns only one value.
____________________ joins are especially useful when you are trying to determine
what value(s) in related tables cause(s) referential integrity problems.
To ensure consistency of the database, every transaction must begin with the database in
an unstable state.
Regardless of the type of Web-server interface used, the Web-to-database
____________________ program must be able to connect with the database.
Normalization works through a series of stages called ____________________ forms.
A table is in fourth normal form if it is in third normal form and has no independent
multivalued dependencies.