Quiz
C192 DataStorage / DML / Data Architectures
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 (37)
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 refer-ence 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 extended entity relationship model (EERM) is sometimes referred to as the ____.
- Aentity relationship model
- Benhanced entity relationship model
- Centity clustering relationship model
- Dextended entity relationship diagram
4The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
- Asubtype discriminator
- Binheritance
- Cspecialization hierarchy
- Dentity supertype
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 su-pertype.
- 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.
- Asingle-site processing, single-site data
- Bmultiple-site processing, single-site data
- Csingle-site processing, multiple-site data
- Dmultiple-site processing, multiple-site data
13The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
- Amultiple-site processing, single-site data
- Bsingle-site processing, multiple-site data
- Csingle-site processing, single-site data
- Dmultiple-site processing, multiple-site data
14____ distributed database systems integrate only one type of centralized DBMS over a network.
- AHomogeneous
- 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 sev-eral sites.
- Acentralized
- 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
21The components of a data warehouse are ____.
- Aintegrated
- Bvolatile
- Cobject-oriented
- Ddecentralized
22Which of the following is a rule that defines the data warehouse?
- AEnvironments are integrated
- BData warehouse contains historical data over a long time horizon
- CData are object-oriented
- DData are subject-oriented
23Which of the following is a characteristic of an OLAP?
- AUses single dimensional data analysis techniques
- BProvides introductory database support and complex end user interfaces
- CProvides introductory end-user interfaces
- DSupports client/server architecture
24____ data must conform to uniform structures and formats to avoid data conflicts.
- AData mart
- BDatabase
- CData warehouse
- DData analysis
25Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.
- Asemidimensional
- Bmultidimensional
- Cone-dimensional
- Dtwo-dimensional
26MOLAP extends OLAP functionality to multidimensional ____ management systems.
- Aonline
- Bdatabase
- Cprocessing
- Ddata
27MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multi-dimensional data.
- Amultidimensional
- Bone-dimensional
- Ctwo-dimensional
- Drelational
28The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
- Arelational
- Bdimensional
- Cmultidimensional
- Dattribute
29During the data ____ phase of data mining, common characteristics or patterns are identified.
- Aanalysis
- Bpreparation
- Cextraction
- Dacquisition
30During the ____ phase of data mining, the data-mining findings are used to predict future behav-ior and forecast business outcomes.
- Aanalysis and classification
- Bpreparation
- Cprognosis
- Dknowledge acquisition
31The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
- Astar
- Bsquare
- COLAP
- DROLAP
32____ backups take place while the user is working on the database.
- AFull
- BIncremental
- CConcurrent
- DSequential
33A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
- Auser
- Brole
- Cprofile
- Dmanager
34At the level of top management, the database must be able to ____.
- Arepresent and support the company operations as closely as possible
- Bdeliver the data necessary for tactical decisions and planning
- Cproduce query results within specified performance levels
- Dprovide access to external and internal data to identify growth opportunities and to chart the direction of such growth
35As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
- Acontrol and planning
- Bconflict and problem resolution
- Cpolicies and standards
- Dsecurity and privacy
36User-access management is a subset of ____.
- Apassword protection
- Bauthorization management
- Cdata integrity
- Dmanagerial control
37Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.
- Auser groups
- Bsections
- Cauthorization schemes
- Dpolicy definitions
Information
- Description
- College C192 Databases Quiz on C192 DataStorage / DML / Data Architectures, created by Craig Willey on 29/06/2020.
- Author
- Craig Willey
- Language
- English
- Views
- 18
- Tags
- Rating
- No ratings yet Rate this quiz