Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
A table that is in 2NF and contains no transitive dependencies is said to be in ____.
a. 1NF
b. 2NF
c. 3NF
d. 4NF
A(n) ____ database stores each database fragment at a single site.
a. partially replicated
b. unreplicated
c. fully replicated
d. partitioned
Surrogate primary keys are especially helpful when there is no ____ key.
a. primary
b. natural
c. foreign
d. composite
The Oracle equivalent to an MS Access AutoNumber is a(n) ____.
a. auto-number
b. sequence
c. TO_NUMBER function
d. trigger
Accurate, relevant, and timely information is the key to ____.
a. data management
b. good decision making
c. knowledge
d. understanding
The ____ command is used to restore the table's contents to their previous values.
a. COMMIT; RESTORE;
b. COMMIT; BACKUP;
c. COMMIT; ROLLBACK;
d. ROLLBACK;
A consistent database state is ____.
a. one in which all tables have foreign keys
b. one in which all data integrity constraints are satisfied
c. one in which all tables are normalized
d. one in which all SQL statements only update one table at a time
A data dictionary contains metadatadata about data.
What is a feature of a Web application server?
a. It is Microsoft's implementation of a superset of the SQL Access Group CLI standard
for database access.
b. It is automatically invoked by the browser when needed.
c. It runs on the client machine, freeing server resources.
d. It provides an integrated development environment with session management and
support for persistent application variables.
Ideally, an entity identifier is composed of ____ attribute(s).
a. zero
b. one
c. two
d. six
The extended entity relationship model (EERM) is sometimes referred to as the ____.
a. entity relationship model
b. enhanced entity relationship model
c. entity clustering relationship model
d. extended entity relationship diagram
Procedures and standards must be revised at least ____ to keep them up-to-date.
a. weekly
b. monthly
c. every six months
d. annually
Using ____, you can extract data from an XML document and convert it into a text file.
a. XMLD
b. XSLT
c. DTD
d. XML schema
Analyzing the company situation is part of the ____ phase of the DBLC.
a. database initial study
b. database design
c. implementation and loading, testing, and evaluation
d. operation
1NF, 2NF, and 3NF are ____.
a. normalization stages
b. anomalies
c. repeating groups
d. atomic attributes
The special operator used to check whether an attribute value is within a range of values
is ____.
a. BETWEEN
b. NULL
c. LIKE
d. IN
Microsoft's alternative to Java is ____.
a. Active X
b. JavaScript
c. VBScript
d. Visual C++
A ____ join returns rows with matching values and includes all rows from both tables
(T1 and T2) with unmatched values.
a. natural
b. cross
c. full outer
d. left outer
The database structure in a DBMS is stored as a ____.
a. file
b. collection of files
c. set of key/value pairs
d. collection of queries
To generate a surrogate key, Microsoft Access uses a(n) ____ data type.
a. surrogate
b. sequence
c. AutoNumber
d. identity
When setting optimizer hints, ____ instructs the optimizer to minimize the overall
execution time, that is, to minimize the time it takes to return all rows in the query
result set. This hint is generally used for batch mode processes.
a. ALL_ROWS
b. FIRST_ROWS
c. INDEX(P_QOH_NDX)
d. OPTIMIZATION_ROWS
Any attribute that is part of a key is known as a ____.
a. key attribute
b. logical attribute
c. key determiner
d. selector
A(n) ____ model represents a global view of the database as viewed by the entire
organization.
a. external
b. conceptual
c. internal
d. physical
The ____ query combines rows from two queries and excludes duplicates.
a. UNION
b. UNION ALL
c. INTERSECT
d. MINUS
When setting optimizer hints, ____ forces the optimizer to use the P_QOH_NDX index
to process this query.
a. ALL_ROWS
b. FIRST_ROWS
c. INDEX(P_QOH_NDX)
d. OPTIMIZATION_ROWS
____ are important because they help to ensure data integrity.
a. Attributes
b. Entities
c. Relationships
d. Constraints
A(n) ____________________physically stores the database's data.
In the Oracle Enterprise Manager, a ____ is basically any object created by end users;
for example, tables, views, indexes, stored procedures, and triggers.
a. component
b. database object
c. policy
d. role
A ____ is a logically connected set of one or more fields that describes a person, place,
or thing.
a. database
b. column
c. record
d. file
____ is an OO programming language developed by Sun Microsystems that runs on top
of the Web browser software.
a. Visual Basic
b. Java
c. JavaScript
d. VBScript
A system table space, a user data table space, an index table space, and a temporary
table space are examples of ____.
a. procedure caches
b. file groups
c. data files
d. extends
A specialization hierarchy can have ____ level(s) of supertype/subtype relationships.
a. zero
b. only one
c. one or many
d. many
In an ER diagram, primary keys are usually bolded.
To join tables, simply enumerate the tables in the FROM clause of the SELECT
statement. The DBMS will create a Cartesian product of every table in the FROM
clause. To get the correct results, you need to select the rows in which the common
attribute values do not match.
The ____________________ interleaves the execution of database operations to ensure
serializability.
____________________ are underlined in an ER diagram.
The SDLCtraces the history of an information system.
A database server-side extension is known as Web-to-database middleware.
In a typical ____________________ schema, each dimension record is related to
thousands of fact records.
The order of the rows and columns is important to the DBMS.
What are the classical approaches to database design?
How do you delete a table from the database? Provide an example.
The IN subquery uses a(n) ____________________ operator.
In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose
errors found in PL/SQL blocks.
____________________ decisions are short term and affect only daily operations; for
example, deciding to change the price of a product to clear it from inventory.
The CGI is a newer Web-server interface standard that is much more efficient and faster
than a dynamic link library (DLL).
What components should an implementation-ready data model contain?
____________________ relationships cannot be implemented as such in the relational
model.
Cloud services allow any organization to quickly and economically add information
technology services such as applications, storage, servers, processing power, databases,
and infrastructure to its IT portfolio.
A(n) ____________________ keycan be described as a superkey without unnecessary
attributes.
The most common design trap is known as a(n) ____________________.
The main concern with redundant relationships is that they remain
____________________ across the model.
