Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
Oracle 11g is an example of the____________ .
a. hierarchical model
b. file system data model
c. relational data model
d. XML/Hybrid data model
Assume you are using the INTERSECT operator to combine the results from two tables
with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table
contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne
and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the INTERSECT operator?
a. 0
b. 2
c. 7
d. 10
The ______________operator could be used in place of MINUS if the DBMS does not
support it.
a. IN
b. NOT IN
c. AND
d. UNION
In the context of total completeness, in a(n)________________ , every supertype
occurrence is a member of at least one subtype.
a. unique constraint
b. disjoint constraint
c. overlapping constraint
d. foreign key constraint
Normalization is a very important database design ingredient, and the highest level is
always the most desirable.
a. True
b. False
_______________provide a description of the data characteristics and the set of
relationships that link the data found within the database.
a. Queries
b. End-user data
c. Metadata
d. Schemas
The data cache is where the data read from the database data files are stored_______
the data have been read or_______ the data are written to the database data files.
a. after; before
b. after; after
c. before; before
d. before; after
According to Codd's________ rule of relational database, "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
Dependencies based on only a part of a composite primary key are known as
__________dependencies.
a. primary
b. partial
c. incomplete
d. composite
The DBMS________ the data and sends the result set back to the client.
a. parses
b. executes
c. fetches
d. processes
In the___________ category, the cloud service provider offers the capability to build
and deploy consumer-created applications using the provider's cloud infrastructure.
a. Application as a Service (AaaS)
b. Infrastructure as a Service (IaaS)
c. Software as a Service (SaaS)
d. Platform as a Service (PaaS)
A(n)__________join links tables by selecting only the rows with common values in
their common attribute(s).
a. attribute
b. unique
c. foreign
d. natural
To list the contents of a table, you must use the DISPLAY command.
a. True
b. False
The__________ schema must support complex (non-normalized) data representations.
a. snowflake
b. online analytical processing
c. decision support database
d. multidimensional database
The _________special operator is used to check whether an attribute value is null.
a. BETWEEN
b. IS NULL
c. LIKE
d. NOT NULL
_________________is a string function that returns the number of characters in a string
value.
a. LENGTH
b. SUBSTRING
c. CONCAT
d. UCASE
In star schema representation, a fact table is related to each dimension table in a
_________relationship.
a. many-to-one (M:1)
b. many-to-many (M:M)
c. one-to many (1:M)
d. one-to-one (1:1)
The advantage of higher processing speed must be carefully weighed against the
disadvantage of data anomalies.
a. True
b. False
The__________ cache stores the most recently executed SQL statements.
a. data
b. procedure
c. sort
d. optimizer
Data warehouse contains historical data obtained from the ________________.
a. operational databases
b. desktop database
c. enterprise databases
d. workgroup databases
A___________ relationship exists when an association is maintained within a single
entity.
a. unary
b. ternary
c. strong
d. weak
Attribute A _______________attribute B if all of the rows in the table that agree in
value for attribute A also agree in value for attribute
B.
a. determines
b. derives from
c. controls
d. owns
_____________is the delay imposed by the amount of time required for a data packet to
make a round trip from point A to point B.
a. Data distribution
b. Replica transparency
c. Network latency
d. Network partitioning
___________is a collection of technologies used to access any type of data source and
manage the data through a common interface.
a. DAO
b. UDA
c. ODBC
d. OLE-DB
The external model is the representation of the database as "seen" by the DBMS.
a. True
b. False
The combination of normalization and ER modeling yields a useful ERD, whose
entities can be translated into appropriate relationship structures.
a. True
b. False
An entity in the entity relationship model corresponds to a table in the relational
environment.
a. True
b. False
The_____________ function returns the current system date in MS Access.
a. TO_DATE()
b. SYSDATE()
c. DATE()
d. TODAY()
__________________transparency allows a physically dispersed database to be
managed as though it were centralized.
a. Distribution
b. Transaction
c. Failure
d. Performance
One important inheritance characteristic is that all entity subtypes inherit
their_________ key attribute from their supertype.
a. primary
b. natural
c. foreign
d. surrogate
Even when a good database blueprint is available, an applications programmer's view of
the data should match that of the manager and the end user.
a. True
b. False
The Crow's foot symbol with two vertical parallel lines indicates___________
cardinality.
a. (0,N)
b. (1,N)
c. (1,1)
d. (0,1)
The Crow's Foot notation is less implementationoriented than the Chen notation.
a. True
b. False
One of the advantages of a distributed database management system (DDBMS) is
improved communication.
a. True
b. False
