Quiz
Data Architecture
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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
Informações
- Descrição
- Data Architecture
- Autor
- Brandon Gagon
- Idioma
- English
- Visualizações
- 240
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz