C192 DataStorage / DML / Data Architectures

Descripción

College C192 Databases Test sobre C192 DataStorage / DML / Data Architectures, creado por Craig Willey el 29/06/2020.
Craig Willey
Test por Craig Willey, actualizado hace más de 1 año
Craig Willey
Creado por Craig Willey hace más de 4 años
7
0

Resumen del Recurso

Pregunta 1

Pregunta
The entity integrity rule requires that ____.
Respuesta
  • 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

Pregunta 2

Pregunta
The referential integrity rule requires that ____.
Respuesta
  • 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

Pregunta 3

Pregunta
The extended entity relationship model (EERM) is sometimes referred to as the ____.
Respuesta
  • entity relationship model
  • enhanced entity relationship model
  • entity clustering relationship model
  • extended entity relationship diagram

Pregunta 4

Pregunta
The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).
Respuesta
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype

Pregunta 5

Pregunta
Every subtype can have ____ supertype to which it is directly related.
Respuesta
  • none
  • only one
  • one or many
  • many

Pregunta 6

Pregunta
A specialization hierarchy can have ____ levels of supertype/subtype relationships.
Respuesta
  • none
  • only one
  • one or many
  • many

Pregunta 7

Pregunta
The property of ____ enables an entity subtype to inherit the attributes and relationships of the su-pertype.
Respuesta
  • subtype discriminator
  • inheritance
  • specialization hierarchy
  • entity supertype

Pregunta 8

Pregunta
One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.
Respuesta
  • primary key
  • natural key
  • foreign key
  • Surrogate key

Pregunta 9

Pregunta
What feature is a DDBMS disadvantage?
Respuesta
  • Processor independence
  • User-friendly interface
  • Security
  • Faster data access

Pregunta 10

Pregunta
What feature is a DDBMS advantage?
Respuesta
  • Reduced operating cost
  • Complexity of management and control
  • Increased storage requirements
  • Increased training cost

Pregunta 11

Pregunta
A database is composed of several parts known as database ____.
Respuesta
  • sections
  • fragments
  • partitions
  • parts

Pregunta 12

Pregunta
Under the ____ scenario, multiple processes run on different computers sharing a single data repository.
Respuesta
  • single-site processing, single-site data
  • multiple-site processing, single-site data
  • single-site processing, multiple-site data
  • multiple-site processing, multiple-site data

Pregunta 13

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

Pregunta 14

Pregunta
____ distributed database systems integrate only one type of centralized DBMS over a network.
Respuesta
  • Homogeneous
  • Heterogeneous
  • Fully heterogeneous
  • Fully homogeneous

Pregunta 15

Pregunta
____ transparency allows the integration of several different local DBMSs under a common, or global, schema.
Respuesta
  • Transaction
  • Performance
  • Distribution
  • Heterogeneity

Pregunta 16

Pregunta
The ____ contains the description of the entire database as seen by the database administrator.
Respuesta
  • distributed global dictionary
  • distributed data dictionary
  • distributed global schema
  • distributed data schema

Pregunta 17

Pregunta
____ fragmentation allows us to break a single object into two or more segments or fragments.
Respuesta
  • Horizontal
  • Vertical
  • Data
  • Mixed

Pregunta 18

Pregunta
With ____ data allocation, the database is divided into several disjointed parts and stored at sev-eral sites.
Respuesta
  • centralized
  • decentralized
  • partitioned
  • replicated

Pregunta 19

Pregunta
The ____ rule requires that all copies of data fragments be identical.
Respuesta
  • shared fragment
  • mutual consistency
  • horizontal fragmentation
  • replication

Pregunta 20

Pregunta
Which of the following is a problem with a centralized database?
Respuesta
  • High cost
  • Good performance from remote locations
  • Poor performance from the main location
  • Lack of storage

Pregunta 21

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

Pregunta 22

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

Pregunta 23

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

Pregunta 24

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

Pregunta 25

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

Pregunta 26

Pregunta
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Respuesta
  • online
  • database
  • processing
  • data

Pregunta 27

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

Pregunta 28

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

Pregunta 29

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

Pregunta 30

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

Pregunta 31

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

Pregunta 32

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

Pregunta 33

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

Pregunta 34

Pregunta
At the level of top management, the database must be able to ____.
Respuesta
  • 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

Pregunta 35

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

Pregunta 36

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

Pregunta 37

Pregunta
Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.
Respuesta
  • user groups
  • sections
  • authorization schemes
  • policy definitions
Mostrar resumen completo Ocultar resumen completo

Similar

Historia Argentina
Nicolas Ñancucheo
Miguel de Unamuno
Diego Santos
Vocabulario unidad 13
Laura Maestro
Mesopotamia y Egipto
irinavalin
Test Ortografía
Omar Vazquez Flores
Modernismo y Generación del 98
David Gracia
Investigación
silvanoperazaiti
Miembro Superior - Anatomía
Ivan Salas
Properties of musical tones
Olga Veiga
¿CUÁNTOS INSTRUMENTOS CONOCES?
Estrella Roba Rodríguez
Sistema óseo
Laura Mon