In the context of the Oracle Enterprise Manager, a ______________is a named
collection of settings that control how much of the database resource a given user can
use.
a. license
b. role
c. profile
d. constraint
If a designer wishes to create an inner join, but the two tables do not have a commonly
named attribute, he can use a(n) _____ clause.
a. OF
b. USING
c. HAS
d. JOIN ON
Installing the DBMS, creating the database, and loading or converting the data are part
of the________ phase of the Database Life Cycle (DBLC).
a. database initial study
b. database design
c. implementation and loading
d. testing and evaluation
A ___________relationship exists when three entities are associated.
a. unary
b. strong
c. ternary
d. weak
One disadvantage of a database system over previous data management approaches is
increased costs.
a. True
b. False
The database contents might be loaded interactively or in batch mode using a variety of
methods and devices including customized user programs.
a. True
b. False
___________data exist in a format that does not lend itself to processing that yields
information.
a. Structured
b. Semistructured
c. Unstructured
d. Historical
In a subquery, the ___________query is executed first.
a. left
b. right
c. inner
d. outer
The property of_____________ enables an entity subtype to inherit the attributes and
relationships of the supertype.
a. subtype discriminator
b. inheritance
c. specialization hierarchy
d. entity supertype
Which of the following is the first step in the exchange between a web browser and a
database?
a. The HTML output is displayed on the client computer’s web browser.
b. The middleware receives the query result and creates the HTML-formatted page.
c. The client’s web browser requests a page from a web server.
d. The web-to-database middleware uses ODBC to connect to the database.
According to the rules of precedence, which of the following computations should be
completed first?
a. Performing additions and subtractions
b. Performing multiplications and divisions
c. Performing operations within parentheses
d. Performing power operations
The__________ isolation level ensures that queries return consistent results.
a. Read Uncommitted
b. Read Committed
c. Serializable
d. Repeatable Read
A(n)__________ join will select only the rows with matching values in the common
attribute(s).
a. natural
b. cross
c. full
d. outer
The DBA function provides data modeling and design services to the end-user
community, often through coordination with an application development group within
the data-processing department.
a. True
b. False
One advantage of a database system over previous data management approaches is that
the database system is considerably less complex.
a. True
b. False
In a star schema, attributes are often used to search, filter, or classify___________ .
a. tables
b. sales
c. facts
d. dimensions
Data integrity is enforced by the database management system (DBMS) through the
proper use of primary and foreign key rules.
a. True
b. False
The onetomany (1:M) relationship is easily implemented in the relational model by
putting the foreign key of the “1” side in the table of the “many” side as a primary key.
a. True
b. False
The________ is a shared, reserved memory area that stores the most recently executed
SQL statements or PL/SQL procedures, including triggers and functions.
a. buffer cache
b. procedure cache
c. data cache
d. permanent storage
The first step in developing the conceptual model using ER diagrams is to
____________.
a. normalize the entities
b. complete the initial ER diagram
c. identify, analyze, and refine the business rules
d. define the attributes, primary keys, and foreign keys for each of the entities
When moving data from permanent storage to RAM, an I/O disk operation retrieves:
a. an entire table.
b. an entire physical disk block.
c. only the row containing the attribute requested.
d. only the attribute which was requested.
Installation and fine tuning are part of the_________ phase of the Systems
Development Life Cycle (SDLC).
a. planning
b. analysis
c. detailed systems design
d. implementation
The first line of an XML document represents the document declaration, and it is
mandatory.
a. True
b. False
The use of the__________ operator allows you to compare a single value with a list of
values returned by the first subquery (sqA) using a comparison operator other than
EQUALS.
A lock guarantees the open use of a data item to multiple transactions.
a. True
b. False
A(n)_________ is anything about which data are to be collected and stored.
a. attribute
b. entity
c. relationship
d. constraint
Some designs use redundant relationships as a way to simplify the design.
a. True
b. False
Incremental backups produce a backup of all data.
a. True
b. False
The ANSI SQL standards are also accepted by the ISO.
a. True
b. False
VMS/VSAM is an example of the_______________ .
a. hierarchical model
b. file system data model
c. relational data model
d. XML data model
The DBA is responsible for ensuring that the data are distributed to the right persons, at
the right time, and in the right format.
a. True
b. False
To reveal meaning, information requires___________ .
Programmers use database tools to___________ the applications during coding of the
programs.
The____________ specifies whether each entity supertype occurrence must also be a
member of at least one subtype.
_____ are qualifying characteristics that provide additional perspectives to a given fact.
The _____________specification is used to avoid having duplicated values in a
column.
The ___________statement combines the output of two SELECT queries.
A(n)___________- defines the environment in which data can be managed and is used
to work with the data in the database.
Raw data must be properly_____________ for storage, processing and presentation.
End users and the DBMS interact through the use of_________ to generate information.
Describe the DBA’s managerial role.
____________________helps provide a balance between performance and fault
tolerance.
Explain the different basic types of join operations. What are they and how do they
work?
The_______________ interleaves the execution of database operations to ensure
serializability.
XML is derived from the___________ , an international standard for the publication
and distribution of highly complex technical documents.
While using a surrogate key, one must ensure that the candidate key of the entity in
question performs properly through the use of the “_________ ” and “not null”
constraints.
Describe the use of null values in a database.
It becomes difficult to create a suitable_________ key when the related table uses a
composite primary key.
After testing is concluded, the final________ is reviewed and printed and end users are
trained.