Explore topic-wise MCQs in Uncategorized topics.

This section includes 15 Mcqs, each offering curated multiple-choice questions to sharpen your Uncategorized topics knowledge and support exam preparation. Choose a topic below to get started.

1.

The important aspect of the data warehouse environment is that data found within the data warehouse is___________.

A. subject-oriented.
B. time-variant.
C. integrated.
D. All of the above.
Answer» E.
Discussion
2.

The biggest drawback of the level indicator in the classic star-schema is that it limits_________.

A. quantify.
B. qualify.
C. flexibility.
D. ability.
Answer» D. ability.
Discussion
3.

Transient data is _____________.

A. data in which changes to existing records cause the previous version of the records to be eliminated.
B. data in which changes to existing records do not cause the previous version of the records to be eliminated.
C. data that are never altered or deleted once they have been added.
D. data that are never deleted once they have been added.
Answer» B. data in which changes to existing records do not cause the previous version of the records to be eliminated.
Discussion
4.

____________ contains information that gives users an easy-to-understand perspective of the information stored in the data warehouse.

A. Business metadata.
B. Technical metadata.
C. Operational metadata.
D. Financial metadata.
Answer» B. Technical metadata.
Discussion
5.

_______________ helps to integrate, maintain and view the contents of the data warehousing system.

A. Business directory.
B. Information directory.
C. Data dictionary.
D. Database.
Answer» C. Data dictionary.
Discussion
6.

Data marts that incorporate data mining tools to extract sets of data are called ______.

A. independent data mart.
B. dependent data marts.
C. intra-entry data mart.
D. inter-entry data mart.
Answer» C. intra-entry data mart.
Discussion
7.

Effect of one attribute value on a given class is independent of values of other attribute is called _________.

A. value independence.
B. class conditional independence.
C. conditional independence.
D. unconditional independence.
Answer» B. class conditional independence.
Discussion
8.

________ is data that is distilled from the low level of detail found at the current detailed leve.

A. Highly summarized data.
B. Lightly summarized data.
C. Metadata.
D. Older detail data.
Answer» C. Metadata.
Discussion
9.

A directory to help the DSS analyst locate the contents of the data warehouse is seen in ______.

A. Current detail data.
B. Lightly summarized data.
C. Metadata.
D. Older detail data.
Answer» D. Older detail data.
Discussion
10.

Non-additive measures can often combined with additive measures to create new _________.

A. additive measures.
B. non-additive measures.
C. partially additive.
D. All of the above.
Answer» B. non-additive measures.
Discussion
11.

__________ are designed to overcome any limitations placed on the warehouse by the nature of the relational data model.

A. Operational database.
B. Relational database.
C. Multidimensional database.
D. Data repository.
Answer» D. Data repository.
Discussion
12.

The main organizational justification for implementing a data warehouse is to provide ______.

A. cheaper ways of handling transportation.
B. decision support.
C. storing large volume of data.
D. access to data.
Answer» D. access to data.
Discussion
13.

___________ of data means that the attributes within a given entity are fully dependent on the entire primary key of the entity.

A. Additivity.
B. Granularity.
C. Functional dependency.
D. Dimensionality.
Answer» D. Dimensionality.
Discussion
14.

The data administration subsystem helps you perform all of the following, except__________.

A. backups and recovery.
B. query optimization.
C. security management.
D. create, change, and delete information.
Answer» E.
Discussion
15.

________ are responsible for running queries and reports against data warehouse tables.

A. Hardware.
B. Software.
C. End users.
D. Middle ware.
Answer» D. Middle ware.
Discussion