jacob thomas
Quiz by , created more than 1 year ago

datastorage DML data architectures db admin

35
0
0
No tags specified
jacob thomas
Created by jacob thomas over 6 years ago
Close

C192 - Alt Pre-assessment

Question 1 of 37

1

The entity integrity rule requires that ____.

Select one of the following:

  • 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

Explanation

Question 2 of 37

1

The referential integrity rule requires that ____.

Select one of the following:

  • every null foreign key value must reference 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

Explanation

Question 3 of 37

1

The extended entity relationship model (EERM) is sometimes referred to as the ____.

Select one of the following:

  • entity relationship model

  • enhanced entity relationship model

  • entity clustering relationship model

  • extended entity relationship diagram

Explanation

Question 4 of 37

1

The ____ depicts the arrangement of higher-level entity supertypes (parent entities) and lower-level entity subtypes (child entities).

Select one of the following:

  • subtype discriminator

  • inheritance

  • specialization hierarchy

  • entity supertype

Explanation

Question 5 of 37

1

Every subtype can have ____ supertype to which it is directly related.

Select one of the following:

  • none

  • only one

  • one or many

  • many

Explanation

Question 6 of 37

1

A specialization hierarchy can have ____ levels of supertype/subtype relationships.

Select one of the following:

  • none

  • only one

  • one or many

  • many

Explanation

Question 7 of 37

1

The property of ____ enables an entity subtype to inherit the attributes and relationships of the supertype.

Select one of the following:

  • subtype discriminator

  • inheritance

  • specialization hierarchy

  • entity supertype

Explanation

Question 8 of 37

1

One important inheritance characteristic is that all entity subtypes inherit their ____ attribute from their supertype.

Select one of the following:

  • primary key

  • natural key

  • foreign key

  • Surrogate key

Explanation

Question 9 of 37

1

What feature is a DDBMS disadvantage?

Select one of the following:

  • Processor independence

  • User-friendly interface

  • Security

  • Faster data access

Explanation

Question 10 of 37

1

What feature is a DDBMS advantage?

Select one of the following:

  • Reduced operating cost

  • Complexity of management and control

  • Increased storage requirements

  • Increased training cost

Explanation

Question 11 of 37

1

A database is composed of several parts known as database ____.

Select one of the following:

  • sections

  • fragments

  • partitions

  • parts

Explanation

Question 12 of 37

1

Under the ____ scenario, multiple processes run on different computers sharing a single data repository.

Select one of the following:

  • single-site processing, single-site data

  • multiple-site processing, single-site data

  • single-site processing, multiple-site data

  • multiple-site processing, multiple-site data

Explanation

Question 13 of 37

1

The ____ scenario describes a fully distributed DBMS with support for multiple data processors and transaction processors at multiple sites.

Select one of the following:

  • multiple-site processing, single-site data

  • single-site processing, multiple-site data

  • single-site processing, single-site data

  • multiple-site processing, multiple-site data

Explanation

Question 14 of 37

1

____ distributed database systems integrate only one type of centralized DBMS over a network.

Select one of the following:

  • Homogeneous

  • Heterogeneous

  • Fully heterogeneous

  • Fully homogeneous

Explanation

Question 15 of 37

1

____ transparency allows the integration of several different local DBMSs under a common, or global, schema.

Select one of the following:

  • Transaction

  • Performance

  • Distribution

  • Heterogeneity

Explanation

Question 16 of 37

1

The ____ contains the description of the entire database as seen by the database administrator.

Select one of the following:

  • distributed global dictionary

  • distributed data dictionary

  • distributed global schema

  • distributed data schema

Explanation

Question 17 of 37

1

___ fragmentation allows us to break a single object into two or more segments or fragments.

Select one of the following:

  • Horizontal

  • Vertical

  • Data

  • Mixed

Explanation

Question 18 of 37

1

With ____ data allocation, the database is divided into several disjointed parts and stored at several sites.

Select one of the following:

  • centralized

  • decentralized

  • partitioned

  • replicated

Explanation

Question 19 of 37

1

The ____ rule requires that all copies of data fragments be identical.

Select one of the following:

  • shared fragment

  • mutual consistency

  • horizontal fragmentation

  • replication

Explanation

Question 20 of 37

1

Which of the following is a problem with a centralized database?

Select one of the following:

  • High cost

  • Good performance from remote locations

  • Poor performance from the main location

  • Lack of storage

Explanation

Question 21 of 37

1

The components of a data warehouse are ____.

Select one of the following:

  • integrated

  • volatile

  • object-oriented

  • decentralized

Explanation

Question 22 of 37

1

Which of the following is a rule that defines the data warehouse?

Select one of the following:

  • Environments are integrated

  • Data warehouse contains historical data over a long time horizon

  • Data are object-oriented

  • Data are subject-oriented

Explanation

Question 23 of 37

1

Which of the following is a characteristic of an OLAP?

Select one of the following:

  • Uses single dimensional data analysis techniques

  • Provides introductory database support and complex end user interfaces

  • Provides introductory end-user interfaces

  • Supports client/server architecture

Explanation

Question 24 of 37

1

____ data must conform to uniform structures and formats to avoid data conflicts.

Select one of the following:

  • Data mart

  • Database

  • Data warehouse

  • Data analysis

Explanation

Question 25 of 37

1

Multidimensional data analysis refers to the processing of data such that data are viewed as part of the ____ structure.

Select one of the following:

  • semidimensional

  • multidimensional

  • one-dimensional

  • two-dimensional

Explanation

Question 26 of 37

1

MOLAP extends OLAP functionality to multidimensional ____ management systems.

Select one of the following:

  • online

  • database

  • processing

  • data

Explanation

Question 27 of 37

1

MOLAP's premise is that ___ databases are best suited to manage, store, and analyze multidimensional data.

Select one of the following:

  • multidimensional

  • one-dimensional

  • two-dimensional

  • relational.

Explanation

Question 28 of 37

1

The ___ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.

Select one of the following:

  • relational

  • dimensional

  • multidimensional

  • attribute

Explanation

Question 29 of 37

1

During the data ___ phase of data mining, common characteristics or patterns are identified.

Select one of the following:

  • analysis

  • preparation

  • extraction

  • acquisition

Explanation

Question 30 of 37

1

During the ___ phase of data mining, the data-mining findings are used to predict future behavior and forecast business outcomes.

Select one of the following:

  • analysis and classifications

  • preparation

  • prognosis

  • knowledge acquisition

Explanation

Question 31 of 37

1

The __ schema creates the near equivalent of a multidimensional database schema from the existing relational database.

Select one of the following:

  • star

  • square

  • OLAP

  • ROLAP

Explanation

Question 32 of 37

1

___ backups take place while the user is working on the database.

Select one of the following:

  • Full

  • Incremental

  • Concurrent

  • Sequential

Explanation

Question 33 of 37

1

A ___ is named collection of database access privileges that authorize a user to connect to the database and use the database system resources.

Select one of the following:

  • user

  • role

  • profile

  • manager

Explanation

Question 34 of 37

1

At the level of top management the database must be able to ___.

Select one of the following:

  • 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

Explanation

Question 35 of 37

1

As a manager, the DBA must concentrate on the ____ dimensions of the database administration function.

Select one of the following:

  • control and planning

  • conflict and problem-resolution

  • policies and standards

  • security and privacy

Explanation

Question 36 of 37

1

User-access management is a subset of ____.

Select one of the following:

  • password protection

  • authorization management

  • data integrity

  • managerial control

Explanation

Question 37 of 37

1

Classifying users into ____, according to common access needs, facilitates the DBA’s job of controlling and managing the access privileges of individual users.

Select one of the following:

  • user groups

  • sections

  • authorization schemes

  • policy definitions

Explanation

Previous
Check answer
Next