Quiz
C192 DataStorage / DML / Data Architectures
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem 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
Informationen
- Beschreibung
- College C192 Databases Quiz am C192 DataStorage / DML / Data Architectures, erstellt von Craig Willey am 29/06/2020.
- Autor
- Craig Willey
- Sprache
- English
- Aufrufe
- 19
- Schlagwörter
- Bewertung
- Noch keine Bewertungen Bewerte dieses Quiz