Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
A derived attribute is indicated in the Chen notation by a ___________that connects the
attribute and an entity.
a. single line
b. dashed line
c. double dashed line
d. double line
In a database context, a(n)________ indicates the use of different names to describe the
same attribute.
a. entity
b. duplicate
c. synonym
d. homonym
Which of the following is a specialization hierarchy overlapping constraint scenario in
case of partial completeness?
a. Subtype sets are unique.
b. Supertype has optional subtypes.
c. Subtype discriminators cannot be null.
d. Subtype does not have a supertype.
____________are required to prevent another transaction from reading inconsistent
data.
a. Locks
b. Schedules
c. Stamps
d. Logs
The result of analysis phase of the Systems Development Life Cycle (SDLC) should be
a better understanding of the system's functional areas, actual and potential problems,
and opportunities.
a. True
b. False
The___________ command is used to restore the database to its previous condition.
a. COMMIT; RESTORE;
b. COMMIT; BACKUP;
c. COMMIT; ROLLBACK;
d. ROLLBACK;
_____________is defined as the condition in which all of the data in the database are
consistent with the real-world events and conditions.
a. Data integrity
b. Data anomaly
c. Data ubiquity
d. Data quality
A(n)___________ file provides the composition of the database's logical model and
defines the syntax rules for an XML document.
a. XMLD
b. XHTML
c. DTD
d. meta
Complex________ requirements may dictate data transformations, and they may
expand the number of entities and attributes within the design.
a. information
b. entity
c. design
d. processing
The overall purpose of the database initial study is to create the conceptual design.
a. True
b. False
A____________ key can be described as a minimal superkey, a superkey without any
unnecessary attributes.
a. secondary
b. candidate
c. primary
d. foreign
The maintenance activities of the DBA are an extension of the operational activities.
a. True
b. False
A table is in 2NF if it is in 1NF, and it includes no partial dependencies.
a. True
b. False
The initial costs of using cloud services tend to be significantly higher than building
on-premise IT infrastructures.
a. True
b. False
The Oracle string concatenation function is_______________ .
a. CONCAT
b. +
c. ||
d. &&
The person responsible for the control of the centralized and shared database is the
database______________ .
a. analyst
b. administrator
c. programmer
d. user
___________refer to a type of database that stores most of its data in RAM rather than
in hard disks.
a. Integrated databases
b. Cloud databases
c. Desktop databases
d. In-memory databases
Data _____ tools are tools that provide advanced statistical analysis to uncover
problems and opportunities hidden within business data.
The___________ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. database tuple
b. systematic database
c. unique index
d. system catalog
From a structural point of view, 2NF is better than___________ .
a. 1NF
b. 3NF
c. 4NF
d. BCNF
A _______________-is any key that uniquely identifies each row.
a. superkey
b. special key
c. foreign key
d. candidate key
Every PL/SQL block must be given a name.
a. True
b. False
In a database context, the word_____________- indicates the use of the same attribute
name to label different attributes.
a. redundancy
b. homonym
c. duplicate
d. synonym
A_________ attribute can be further subdivided to yield additional attributes.
a. composite
b. simple
c. single-valued
d. multivalued
Stored procedures must have at least one argument.
a. True
b. False
A distributed ___________can reference several different local or remote data
processing sites.
a. request
b. site
c. data location
d. transaction
You must use plug-ins and other client-side extensions:
a. to create an open communication line between a server and its clients.
b. to eliminate the need for running external programs for each client request.
c. to improve processing capabilities of a browser.
d. to create dynamic web search pages.
The property of a subtype discriminator enables an entity supertype to inherit the
attributes and relationships of the subtype.
a. True
b. False
In the entity relationship diagram (ERD), cardinality is indicated using the_________
notation, where max is the maximum number of associated entities and min represents
the minimum number of associated entities.
a. (max, min)
b. (min, max)
c. [min ... max]
d. {min|max}
An entity cluster is formed by combining multiple interrelated entities
into_______________ .
a. a single abstract entity object
b. multiple abstract entity objects
c. a single entity object
d. multiple entity objects
A(n)_____________ data dictionary is automatically updated by the DBMS with every
database access.
a. dynamic
b. active
c. passive
d. static
A___________ request lets a single SQL statement reference data located at several
different local or remote DP sites.
a. distributed
b. transaction
c. fragmented
d. remote
Instructions to create a password are an example of a_______________ .
a. rule
b. policy
c. standard
d. procedure
The entity supertype contains common characteristics, and the entity subtypes each
contain their own unique characteristics.
a. True
b. False
At the implementation level, the supertype and its subtype(s) depicted in a
specialization hierarchy maintain a(n)__________ relationship.
a. self-referencing
b. 1:1
c. 1:M
d. M:N
