A table that has all key attributes defined, has no repeating groups, and all its attributes
are dependent on the primary key, is said to be in ____.
a. 1NF
b. 2NF
c. 3NF
d. 4NF
With partial dependencies, data redundancies occur because every row entry requires
duplication of data.
The Oracle ____ function returns the current date.
a. DATE
b. SYSDATE
c. CURRENT_DATE
d. TO_DATE
A relational table must not contain a(n) ____.
a. entity
b. attribute
c. relationship
d. repeating group
A(n) ____ is anything about which data are to be collected and stored.
a. attribute
b. entity
c. relationship
d. constraint
A(n) ____ represents a particular type of object in the real world.
a. attribute
b. entity
c. relationship
d. constraint
A relationship is an association between ____.
a. objects
b. entities
c. databases
d. fields
In the ____ model, each parent can have many children, but each child has only one
parent.
a. hierarchical
b. network
c. relational
d. entity relationship
One of the important functions provided by the database ____ is to reserve the
resources that must be used by the database at run time.
a. security component
b. authorization manager
c. initialization parameters
d. administrator
A table where all attributes are dependent on the primary key and are independent of
each other, and no row contains two or more multivalued facts about an entity, is said to
be in ____.
a. 1NF
b. 2NF
c. 3NF
d. 4NF
The reliance on ____ as the design methodology for relational databases is seen as a
stumbling block to its use in OLAP systems.
a. normalization
b. denormalization
c. star schema
d. multidimensional schema
In a(n) ____ diagram, the arrows above the attributes indicate all desirable
dependencies.
a. Chen
b. dependency
c. functionality
d. ER
In a subquery, the ____ query is executed first.
a. left
b. right
c. inner
d. outer
The ____ contains business data extracted from the operational database and from
external data sources.
a. data store
b. ETL tools
c. data visualization tool
d. data analysis tool
A verb associating two nouns in a business rule translates to a(n) ____ in the data
model.
a. entity
b. attribute
c. relationship
d. constraint
The default comparison condition for the subtype discriminator attribute is the ____
comparison.
a. not equality
b. less than
c. greater than
d. equality
In an ER diagram, primary keys are indicated by ____.
a. bolding
b. italics
c. underlining
d. a special font
The basic star schema has four components: facts, ____, attributes, and attribute
hierarchies.
a. keys
b. relationships
c. cubes
d. dimensions
The ____ must be set large enough to permit as many data requests to be serviced from
cache as possible.
a. data cache
b. SQL cache
c. sort cache
d. optimizer mode
____ is a collection of technologies used to access any type of data source and manage
the data through a common interface.
a. DAO c. ODBC
b. UDA d. OLE-DB
____splits a table into subsets of rows or columns and places the subsets close to the
client computer to improve data access time.
a. Normalization
b. Meta modeling
c. Replication
d. Partitioning
To be considered minimally relational, the DBMS must support the key relational
operators ____, PROJECT, and JOIN.
a. INTERSECT
b. UNION
c. DIFFERENCE
d. SELECT
A(n) ____ enables a database administrator to define schema components.
a. extensible markup language (XML)
b. data definition language (DDL)
c. unified modeling language (UML)
d. query language
When using a(n) ____ join, only rows that meet the given criteria are returned.
a. full
b. inner
c. outer
d. set
A ____ key is a real-world, generally accepted identifier used to uniquely identify
real-world objects.
a. primary
b. natural
c. foreign
d. surrogate
A(n) ____ file provides the composition of the database’s logical model and defines the
syntax rules for an XML document.
a. XMLD
b. HTML
c. DTD
d. meta
____deals with ensuring that data is protected against unauthorized access, and if the
data are accessed by an authorized user, that the data are used only for an authorized
purpose.
a. Integrity
b. Compliance
c. Availability
d. Confidentiality
There are ____ stages in the DBLC.
a. four
b. five
c. six
d. seven
The PL/SQL block starts with the ____ clause.
a. IS
b. OPEN
c. DECLARE
d. BEGIN
____ is embedded inside an HTML page and is activated by triggering events such as
clicking on a link.
a. A plug-in
b. A browser
c. Visual Basic
d. VBScript
The hierarchical model is software-independent.
A DDBMS must be communications-media-dependent.
Data constitute the building blocks of information.
____________________ is data about data through which the end-user data are
integrated and managed.
The creation and management of user interfaces and database connectivity are not
affected by the Web’s existence.
The completeness constraint can be partial or total.
____________________ are qualifying characteristics that provide additional
perspectives to a given fact.
The data warehouse designer must define common business dimensions that will be
used by the data analyst to narrow a search, group information, or describe attributes.
When selecting DBMS ____________________, consider processor(s), RAM, disk
space, and so on.
Normalization produces a lower normal form.
Derived attributes are stored in a special database table.
In what two cases are composite primary keys particularly useful?
____________________ is a term used to describe a comprehensive, cohesive, and
integrated set of tools and processes used to capture, collect, integrate, store, and
analyze data with the purpose of generating and presenting information used to support
business decision making.
Depending on the sophistication of the application development software, nulls can
create problems when functions such as COUNT, AVERAGE, and SUM are used.
A(n) ____________________ subquery is a subquery that executes once for each row
in the outer query.