Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
The "____" characteristic of a primary key states the following:
The selected primary key must not be composed of any attribute(s) that might be
considered a security risk or violation. For example, using a Social Security number as
a PK in an EMPLOYEE table is not a good idea.
a. unique values
b. nonintelligent
c. preferably single-attribute
d. security-compliant
____ transparency is the highest level of transparency. The end user or programmer
does not need to know that a database is partitioned.
a. Performance
b. Fragmentation
c. Location
d. Local mapping
The special operator used to check whether a subquery returns any rows is ____.
a. BETWEEN
b. EXISTS
c. LIKE
d. IN
Creating the conceptual design and selecting DBMS software are part of the ____ phase
of the DBLC.
a. database initial study
b. database design
c. implementation and loading
d. testing and evaluation
____________________ online analytical processing provides OLAP functionality by
using relational databases and familiar relational query tools to store and analyze
multidimensional data.
Data redundancy produces ____.
a. slower lookups
b. robust design
c. efficient storage use
d. data integrity problems
Most data you encounter is best classified as ____.
a. structured
b. semistructured
c. unstructured
d. historical
When the PK of one entity does not contain the PK of a related entity, the relationship is
____.
a. missing
b. weak
c. strong
d. neutral
Oracle recommends ____ for creating audit logs.
a. triggers
b. stored procedures
c. stored functions
d. tables
Some very specialized applications may require normalization beyond the ____.
a. 1NF
b. 2NF
c. 3NF
d. 4NF
The ____ data model uses the concept of inheritance.
a. relational
b. network
c. object-oriented
d. entity relationship
Which of the following is used to select partial table contents?
a. SELECT <column(s)> FROM <Table name> BY <Conditions>;
b. LIST <column(s)> FROM <Table name> BY <Conditions>;
c. SELECT <column(s)> FROM <Table name> WHERE <Conditions>;
d. LIST<column(s)> FROM <Table name> WHERE <Conditions>;
The Crow's foot symbol with two parallel lines indicates ____ cardinality.
a. (0,N)
b. (1,N)
c. (1,1)
d. (0,1)
If you wish to create an inner join, but the two tables do not have a commonly named
attribute, you can use a(n) ____ clause.
a. OF
b. USING
c. HAS
d. JOIN ON
Improving ____ leads to more flexible queries.
a. atomicity
b. normalization
c. denormalization
d. derived attributes
MOLAP is a logical choice for companies that already use relational databases for their
operational data.
If the focus is on data-retrieval speed, you might also be forced to include ____
attributes in the design, which would not ordinarily be done.
a. multivalued
b. composite
c. weak
d. derived
The DBMS ____ the data and sends the result set back to the client.
a. parses
b. executes
c. fetches
d. processes
Codd's Rule of ____ states:
Application programs and ad hoc facilities are logically unaffected when changes are
made to the table structures that preserve the original table values (changing order of
columns or inserting columns).
a. Nonsubversion
b. Logical Data Independence
c. Comprehensive Data Sublanguage
d. Integrity Independence
A ____ database supports data distributed across several different sites.
a. single-user
b. multiuser
c. centralized
d. distributed
A ____ is a uniquely identifiable object that allows a given person to log on to the
database.
a. user
b. role
c. profile
d. manager
The ____ cache stores the most recently executed SQL statements.
a. data
b. SQL
c. sort
d. optimizer
____ is a set of tools that work together to provide an advanced data analysis
environment for retrieving, processing, and modeling data from the data warehouse.
a. Online analytical processing
b. Semistructured processing
c. Enterprise processing
d. XML processing
Normalization represents a micro view of the ____ within the ERD.
a. entities
b. attributes
c. relationships
d. forms
A(n) ____ is perceived as a two-dimensional structure composed of rows and columns.
a. table
b. rowset
c. attribute
d. intersection
Composite primary keys are particularly useful as identifiers of composite entities,
where each primary key combination is allowed only once in the ____ relationship.
a. 0:1
b. 1:1
c. 1:M
d. M:N
____ data refer to data whose values change over time and for which you must keep a
history of the data changes.
a. Time-sensitive
b. Time-variant
c. Historical
d. Change-based
A(n) ____ is a restriction placed on the data.
a. attribute
b. entity
c. relationship
d. constraint
The ____ serve(s) as the intermediary between the user and the database.
a. DBMS
b. metadata
c. end-user data
d. programming language
The entity supertype contains the common characteristics and the entity subtypes
contain the unique characteristics of each entity subtype.
Explain conflict and problem resolution as part of the DBA's end-user support services.
What are the four different result types that can be returned from a subquery? For each
type, explain what it is and when it is used.
Typically, the __________________________________________________ scenario
requires a network file server running conventional applications that are accessed
through a network.
Connectivities and cardinalities are established by business rules.
A data store is used by the data analyst to create the queries that access the database.
A(n) ____________________ join returns all rows with matching values in the
matching columns and eliminates duplicate columns.
Subtypes that contain nonunique subsets of the supertype entity set are known as
____________________ subtypes.
Because ____________________ e-commerce integrates business processes among
companies, it requires the transfer of business information among different business
entities.
The ____________________ statement can be used to combine rows from two queries,
returning only the rows that appear in both sets.
What are the characteristics of a relational table?
Normalization purity is easy to sustain in the modern database environment.
In early computer file systems, a(n) ___________________________________ was
hired to create a computer-based system that would track data and produce required
reports.
___________________________________ is an application programming interface
that allows a Java program to interact with a wide range of data sources (relational
databases, tabular data sources, spreadsheets, and text files).
Entity subtypes do not inherit the relationships in which the supertype entity
participates.
