Quiz
Data Architecture
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (20)
1The entity integrity rule requires that ____.
- Aall primary key entries are unique
- Ba part of the key may be null
- Cforeign key values do not reference primary key values
- Dduplicate object values are allowed
2The referential integrity rule requires that ____.
- Aevery null foreign key value must reference an existing primary key value
- Ban attribute have a corresponding value
- Cevery non-null foreign key value reference an existing primary key value
- Dyou delete a row in one table whose primary key does not have a matching foreign key value in another table
3The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
- Asubtype discriminator
- Binheritance
- Cspecialization hierarchy
- Dentity supertype
4Every subtype can have ____ supertype to which it is directly related.
- Anone
- Bonly one
- Cone or many
- Dmany
5Every subtype can have ____ supertype to which it is directly related.
- Anone
- Bonly one
- Cone or many
- Dmany
6A specialization hierarchy can have ____ levels of supertype/subtype relationships.
- Anone
- Bonly one
- Cone or many
- Dmany
7The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.
- Asubtype discriminator
- Binheritance
- Cspecialization hierarchy
- Dentity supertype
8One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.
- Aprimary key
- Bnatural key
- Cforeign key
- Dsurrogate key
9What feature is a DDBMS disadvantage?
- AProcessor independence
- BUser-friendly interface
- CSecurity
- DFaster data access
10What feature is a DDBMS advantage?
- AReduced operating cost
- BComplexity of management and control
- CIncreased storage requirements
- DIncreased training cost
11A database is composed of several parts known as database ____.
- Asections
- Bfragments
- Cpartitions
- Dparts
12Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
- AHomogeneous
- Ba
13The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
- Aa
- Bb
14____ distributed database systems integrate only one type of centralized DBMS over a network.
- AHomogenous
- BHeterogeneous
- CFully heterogeneous
- DFully homogeneous
15____ transparency allows the integration of several different local DBMSs under a common, or global, schema.
- ATransaction
- BPerformance
- CDistribution
- DHeterogeneity
16The ____ contains the description of the entire database as seen by the database administrator.
- Adistributed global dictionary
- Bdistributed data dictionary
- Cdistributed global schema
- Ddistributed data schema
17____ fragmentation allows us to break a single object into two or more segments or fragments.
- AHorizontal
- BVertical
- CData
- DMixed
18With ____ data allocation, the database is divided into several disjointed parts and stored at several sites.
- Acentrialized
- Bdecentralized
- Cpartitioned
- Dreplicated
19The ____ rule requires that all copies of data fragments be identical.
- Ashared fragment
- Bmutual consistency
- Chorizontal fragmentation
- Dreplication
20Which of the following is a problem with a centralized database?
- Ahigh cost
- BGood performance from remote locations
- CPoor performance from the main location
- DLack of storage
Information
- Description
- Data Architecture
- Author
- Brandon Gagon
- Language
- English
- Views
- 240
- Tags
- Rating
- No ratings yet Rate this quiz