Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
A(n) ____ join only returns matched records from the tables that are being joined.
a. outer
b. inner
c. direct
d. union
Data ____________________ tools provide advanced visual analysis and techniques to
enhance understanding of business data.
____ data are the result of formatting to facilitate storage, use and generation of
information.
a. Structured
b. Semistructured
c. Unstructured
d. Historical
If the attribute (B) is functionally dependent on a composite key (A) but not on any
subset of that composite key, the attribute (B) is fully functionally dependent on (A).
In the ODBC architecture, a(n) ____ is in charge of managing all database connections.
a. API
b. data source name
c. ODBC driver
d. driver manager
Which of the following is a client-side extension?
a. ActiveX
b. ODBC
c. SQL*Net
d. TCP/IP
In Oracle, ____ make(s) it possible to merge SQL and traditional programming
constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops
(FOR and WHILE loops,) and error trapping.
a. triggers
b. indexes
c. embedded SQL
d. procedural SQL
A(n) ____ join returns not only the rows matching the join condition (that is, rows with
matching values in the common columns) but also the rows with unmatched values.
a. outer
b. inner
c. equi-
d. cross
A(n) ____ exists when there are functional dependencies such that Y is functionally
dependent on X and Z is functionally dependent on Y, and X is the primary key.
a. partial dependency
b. repeating group
c. atomic attribute
d. transitive dependency
The ____ command is used with the ALTER TABLE command to modify the table by
deleting a column.
a. DROP
b. REMOVE
c. DELETE
d. ERASE
BusinessObjects is a(n) ____ tool.
a. OLAP
b. data visualization
c. data mining
d. data warehouse
"Should the existing system be replaced?" is a question that is asked during the ____
stage of the SDLC.
a. planning
b. analysis
c. implementation
d. maintenance
In the optimistic approach, during the ____ phase, changes are permanently applied to
the database.
a. read
b. validation
c. write
d. shared
The ____ model was developed to allow designers to use a graphical tool to examine
structures rather than describing them with text.
a. hierarchical
b. network
c. object-oriented
d. entity relationship
DBMS vendors can publish ____ to facilitate data exchanges and the creation of data
views from multiple applications for multiple industries.
a. metadictionaries
b. database support
c. Web pages
d. XML databases
ANSI defines four events that signal the end of a transaction. Of the following events,
which is defined by ANSI as being equivalent to a ROLLBACK?
a. Five SQL statements are executed.
b. The end of a program is successfully reached.
c. The program is abnormally terminated.
d. The database is shut down for maintenance.
A(n) ____ might be written by a programmer or it might be created through a DBMS
utility program.
a. query
b. operating system
c. database management system
d. application program
Some RDBMSs, such as Oracle, automatically ____ data changes when issuing data
definition commands.
a. COMMIT
b. ROLLBACK
c. UNSAVE
d. UPDATE
The term _________________________ refers to scattered locations storing the same
basic data.
A(n) ____ is an ordered arrangement of keys and pointers.
a. table
b. superkey
c. relationship
d. index
Oracle 11g is an example of a(n) ____.
a. hierarchical model
b. file system data model
c. relational data model
d. XML/Hybrid data model
The DBMS keeps several copies of ____________________ to ensure that a disk
physical failure will not impair the DBMS's ability to recover data.
"All users must have passwords" is an example of a ____.
a. rule
b. policy
c. standard
d. procedure
In a database context, a(n) ____indicates the use of different names to describe the
same attribute.
a. entity
b. duplicate
c. synonym
d. homonym
In the relational model, ____ are important because they are used to ensure that each
row in a table is uniquely identifiable.
a. relations
b. keys
c. indexes
d. logical structures
The ____ table space is used as a temporary storage area for merge, sort, or set
aggregate operations.
a. system
b. user data
c. temporary
d. rollback segment
____ yields a vertical subset of a table.
a. PROJECT
b. SELECT
c. UNION
d. DIFFERENCE
A(n) ____ lock has only two stages (0 and 1).
a. shared
b. exclusive
c. binary
d. two-phase
A ____ relationship exists when two entities are associated.
a. unary
b. binary
c. ternary
d. weak
The equijoin takes its name from the comparison operator ____ used in the condition.
a. *
b. <
c. =
d. >
The DBMS ____ the SQL query and chooses the most efficient access/execution plan.
a. parses
b. executes
c. fetches
d. processes
The Oracle ____ function compares an attribute or expression with a series of values
and returns an associated value or a default value if no match is found.
a. NVL
b. TO_CHAR
c. DECODE
d. CONVERT
The ____________________ analyzes the SQL query and finds the most efficient way
to access the data.
The ____________________ constraint specifies whether each entity supertype
occurrence must also be a member of at least one subtype.
In the detailed systems design phase, steps are laid out for conversion from the old
system to the new system.
The primary objective in database design is to create complete, denormalized,
redundant, and fully integrated conceptual, logical, and physical database models.
Each row in the relational table is known as an entity instance or entity occurrence in
the ER model.
It becomes difficult to create a suitable ____________________ key when the related
table uses a composite primary key.
The CHECK constraint is used to define a condition for the values that the attribute
domain cannot have.
The selection of the DBMS ____________________ involves asking the question, "Are
the company's needs better served by a relational, object-oriented, or object/relational
DBMS?"
When joining three or more tables, you need to specify a join condition for one pair of
tables.
Explain user requirements gathering as part of the DBA's end-user support services.
One of the advantages of a DDBMS is security.
If a DDBMS exhibits ____________________ transparency, the user does not need to
know that the data are partitionedmeaning the table's rows and columns are split
vertically or horizontally and stored among multiple sites.
Protecting the data in the database is a function of authorization management.
A cost-based optimizer uses a set of preset rules and points to determine the best
approach to execute a query.
The general coordinator of all DBAs is sometimes known as the
____________________ administrator.
An enterprise database can be defined as the company's data representation that
provides support for all present and expected future operations.
