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
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
You can think of a table as a persistent representation of a logical relation.
a. True
b. False
A table where all attributes are dependent on the primary key but 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
A ________________key is a real-world, generally accepted identifier used to uniquely
identify real-world objects.
a. primary
b. natural
c. foreign
d. surrogate
Of the following normal forms,_________ is mostly of theoretical interest.
a. 1NF
b. 3NF
c. BCNF
d. DKNF
Which of the following is a specialization hierarchy disjoint constraint scenario in case
of partial completeness?
a. Subtype discriminator can be null.
b. Subtype discriminator cannot be null.
c. Each supertype occurrence is a member of only one subtype.
d. Each supertype occurrence is a member of at least one subtype.
A subtype contains attributes that are common to all of its supertypes.
a. True
b. False
To work with data, a DBMS must retrieve the data from________ and place them in
_____________.
a. data files; procedure cache
b. RAM; data cache
c. permanent storage; RAM
d. temporary files; procedure cache
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).
a. True
b. False
At the implementation level, the supertype and its subtype(s) depicted in the
specialization hierarchy maintain a 1:1 relationship.
a. True
b. False
Automatic query optimization means that the:
a. optimization takes place at compilation time by the programmer.
b. DBMS finds the most cost-effective access path without user intervention.
c. optimization process is scheduled and selected by the end user or programmer.
d. database access strategy is defined when the program is executed.
Stored procedures are executed using the EXEC command.
a. True
b. False
The statement SELECT * FROM T1, T2 produces a(n)___________ join.
a. cross
b. natural
c. equi-
d. full
The syntax for the UNION query is__________ .
a. query + query
b. UNION (query, query)
c. UNION: query query
d. query UNION query
Decision support data tend to be non-normalized,______ , and pre-aggregated.
a. unique
b. duplicated
c. optimized
d. sorted
_____________is a technique that creates logical representations of computing
resources that are independent of the underlying physical computing resources.
a. Normalization
b. Virtualization
c. Specialization
d. Generalization
In the context of total completeness, in a(n)___________ , every supertype occurrence
is a member of only one subtype.
a. foreign key constraint
b. nonunique constraint
c. overlapping constraint
d. disjoint constraint
When using the Oracle TO_DATE function, the code____________ represents a
three-letter month name.
a. MON
b. MM3
c. MONTH
d. MM
Data redundancy produces_________ .
a. slower lookups
b. robust design
c. efficient storage use
d. data integrity problems
The reason for the different levels of isolation is to increase transaction concurrency.
a. True
b. False
Rapid ad hoc data became unnecessary in the quick-response decision-making
environment.
a. True
b. False
Once the data has been loaded into the database, the____________ tests and fine-tunes
the database for performance, integrity, concurrent access, and security constraints.
a. programmer
b. manager
c. database administrator
d. systems administrator
Database performance is one of the least important factors in all database
implementations.
a. True
b. False
The________ pseudo-column is used to select the next value from a sequence.
a. CURRVAL
b. NEXTVAL
c. NEXT
d. GET_NEXT
_______________CASE tools provide support for the planning, analysis, and design
phases.
a. Front-end
b. Back-end
c. Vertical
d. Horizontal
The SQL aggregate function that gives the arithmetic mean for a specific column
is_______________ .
a. COUNT
b. AVG
c. MAX
d. SUM
_____________databases reflect the ever-growing demand for greater scope and depth
in the data on which decision support systems increasingly rely.
a. Normalized
b. Data warehouse
c. Temporary
d. Report
The Oracle__________ function returns the current date.
a. DATE
b. SYSDATE
c. CURRENT_DATE
d. TO_DATE
_____ 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
The SQL data manipulation command HAVING:
a. restricts the selection of rows based on a conditional expression.
b. restricts the selection of grouped rows based on a condition.
c. modifies an attribute’s values in one or more table’s rows.
d. groups the selected rows based on one or more attributes.
In theory, a(n)___________ can be an independent centralized database management
system with proper interfaces to support remote access from other independent database
management systems in the network.
a. transaction processor
b. application processor
c. transaction manager
d. data processor
_____________is a generic entity type that is related to one or more entity subtypes.
a. A subtype discriminator
b. Inheritance
c. A specialization hierarchy
d. An entity supertype
The phenomenon of uncommitted data occurs when two transactions are executed
concurrently and the first transaction is rolled back after the second transaction has
already accessed the uncommitted datathus violating the isolation property of
transactions.
a. True
b. False