13833523
Beschreibung
Quiz von Brandon Gagon, aktualisiert more than 1 year ago
|
Erstellt von Brandon Gagon
vor fast 6 Jahre
|
|
Frage 1
Frage
The entity integrity rule requires that ____.
Antworten
-
all primary key entries are unique
-
a part of the key may be null
-
foreign key values do not reference primary key values
-
duplicate object values are allowed
Frage 2
Frage
The referential integrity rule requires that ____.
Antworten
-
every null foreign key value must reference an existing primary key value
-
an attribute have a corresponding value
-
every non-null foreign key value reference an existing primary key value
-
you delete a row in one table whose primary key does not have a matching foreign key value in another table
Frage 3
Frage
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
Antworten
-
subtype discriminator
-
inheritance
-
specialization hierarchy
-
entity supertype
Frage 4
Frage
Every subtype can have ____ supertype to which it is directly related.
Antworten
-
none
-
only one
-
one or many
-
many
Frage 5
Frage
Every subtype can have ____ supertype to which it is directly related.
Antworten
-
none
-
only one
-
one or many
-
many
Frage 6
Frage
A specialization hierarchy can have ____ levels of supertype/subtype relationships.
Antworten
-
none
-
only one
-
one or many
-
many
Frage 7
Frage
The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
Antworten
-
subtype discriminator
-
inheritance
-
specialization hierarchy
-
entity supertype
Frage 8
Frage
One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.
Antworten
-
primary key
-
natural key
-
foreign key
-
surrogate key
Frage 9
Frage
What feature is a DDBMS disadvantage?
Antworten
-
Processor independence
-
User-friendly interface
-
Security
-
Faster data access
Frage 10
Frage
What feature is a DDBMS advantage?
Antworten
-
Reduced operating cost
-
Complexity of management and control
-
Increased storage requirements
-
Increased training cost
Frage 11
Frage
A database is composed of several parts known as database ____.
Antworten
-
sections
-
fragments
-
partitions
-
parts
Frage 12
Frage
Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
Antworten
-
Homogeneous
-
a
Frage 13
Frage
The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
Antworten
-
a
-
b
Frage 14
Frage
____ distributed database systems integrate only one type of centralized DBMS over a network.
Antworten
-
Homogenous
-
Heterogeneous
-
Fully heterogeneous
-
Fully homogeneous
Frage 15
Frage
____ transparency allows the integration of several different local DBMSs under a common, or global, schema.
Antworten
-
Transaction
-
Performance
-
Distribution
-
Heterogeneity
Frage 16
Frage
The ____ contains the description of the entire database as seen by the database administrator.
Antworten
-
distributed global dictionary
-
distributed data dictionary
-
distributed global schema
-
distributed data schema
Frage 17
Frage
____ fragmentation allows us to break a single object into two or more segments or fragments.
Antworten
-
Horizontal
-
Vertical
-
Data
-
Mixed
Frage 18
Frage
With ____ data allocation, the database is divided into several disjointed parts and stored at several sites.
Antworten
-
centrialized
-
decentralized
-
partitioned
-
replicated
Frage 19
Frage
The ____ rule requires that all copies of data fragments be identical.
Antworten
-
shared fragment
-
mutual consistency
-
horizontal fragmentation
-
replication
Frage 20
Frage
Which of the following is a problem with a centralized database?
Antworten
-
high cost
-
Good performance from remote locations
-
Poor performance from the main location
-
Lack of storage
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.