C192 DataStorage / DML / Data Architectures

Beschreibung

College C192 Databases Quiz am C192 DataStorage / DML / Data Architectures, erstellt von Craig Willey am 29/06/2020.
Craig Willey
Quiz von Craig Willey, aktualisiert more than 1 year ago
Craig Willey
Erstellt von Craig Willey vor mehr als 4 Jahre
7
0

Zusammenfassung der Ressource

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 refer-ence 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 extended entity relationship model (EERM) is sometimes referred to as the ____.
Antworten
  • entity relationship model
  • enhanced entity relationship model
  • entity clustering relationship model
  • extended entity relationship diagram

Frage 4

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 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 su-pertype.
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
  • single-site processing, single-site data
  • multiple-site processing, single-site data
  • single-site processing, multiple-site data
  • multiple-site processing, multiple-site data

Frage 13

Frage
The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.
Antworten
  • multiple-site processing, single-site data
  • single-site processing, multiple-site data
  • single-site processing, single-site data
  • multiple-site processing, multiple-site data

Frage 14

Frage
____ distributed database systems integrate only one type of centralized DBMS over a network.
Antworten
  • Homogeneous
  • 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 sev-eral sites.
Antworten
  • centralized
  • 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

Frage 21

Frage
The components of a data warehouse are ____.
Antworten
  • integrated
  • volatile
  • object-oriented
  • decentralized

Frage 22

Frage
Which of the following is a rule that defines the data warehouse?
Antworten
  • Environments are integrated
  • Data warehouse contains historical data over a long time horizon
  • Data are object-oriented
  • Data are subject-oriented

Frage 23

Frage
Which of the following is a characteristic of an OLAP?
Antworten
  • Uses single dimensional data analysis techniques
  • Provides introductory database support and complex end user interfaces
  • Provides introductory end-user interfaces
  • Supports client/server architecture

Frage 24

Frage
____ data must conform to uniform structures and formats to avoid data conflicts.
Antworten
  • Data mart
  • Database
  • Data warehouse
  • Data analysis

Frage 25

Frage
Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.
Antworten
  • semidimensional
  • multidimensional
  • one-dimensional
  • two-dimensional

Frage 26

Frage
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Antworten
  • online
  • database
  • processing
  • data

Frage 27

Frage
MOLAP's premise is that ____ databases are best suited to manage, store, and analyze multi-dimensional data.
Antworten
  • multidimensional
  • one-dimensional
  • two-dimensional
  • relational

Frage 28

Frage
The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Antworten
  • relational
  • dimensional
  • multidimensional
  • attribute

Frage 29

Frage
During the data ____ phase of data mining, common characteristics or patterns are identified.
Antworten
  • analysis
  • preparation
  • extraction
  • acquisition

Frage 30

Frage
During the ____ phase of data mining, the data-mining findings are used to predict future behav-ior and forecast business outcomes.
Antworten
  • analysis and classification
  • preparation
  • prognosis
  • knowledge acquisition

Frage 31

Frage
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Antworten
  • star
  • square
  • OLAP
  • ROLAP

Frage 32

Frage
____ backups take place while the user is working on the database.
Antworten
  • Full
  • Incremental
  • Concurrent
  • Sequential

Frage 33

Frage
A ____ is a named collection of database access privileges that authorize a user to connect to the database and use the database system resources.
Antworten
  • user
  • role
  • profile
  • manager

Frage 34

Frage
At the level of top management, the database must be able to ____.
Antworten
  • represent and support the company operations as closely as possible
  • deliver the data necessary for tactical decisions and planning
  • produce query results within specified performance levels
  • provide access to external and internal data to identify growth opportunities and to chart the direction of such growth

Frage 35

Frage
As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.
Antworten
  • control and planning
  • conflict and problem resolution
  • policies and standards
  • security and privacy

Frage 36

Frage
User-access management is a subset of ____.
Antworten
  • password protection
  • authorization management
  • data integrity
  • managerial control

Frage 37

Frage
Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.
Antworten
  • user groups
  • sections
  • authorization schemes
  • policy definitions
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

Quiz-Allgemeinwissen
AntonS
Elektrischer Widerstand
Peter Kasebacher
Kunststoffe - Einführung
Fabian B.
PR VO part2
Anda Muresan
DELF B1/B2 Vocabulaire 1/...
Chiara Braun
Vetie - Tierzucht & Genetik - S I
Fioras Hu
BAS 7 - Schwimmen, Turnen, Leichtathletik
B G
HNO Patho
Sabine Gechter
Meth: QUANTI
max knoll
Innere Schwein Vetie
Anne Käfer
Vetie Reprospaß
Tropsi B