MCQs > Database Management > Database MCQs > Advance Database MCQs

Advance Database MCQ

Vba procedures are created, modified, and displayed in the ____ window.

Answer

Correct Answer: Code

Note: This Question is unanswered, help us to find answer for this one

A correlated subquery is evaluated _____ for each row processed by the parent statement.

Answer

Correct Answer: ONCE

Note: This Question is unanswered, help us to find answer for this one

The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.

Answer

Correct Answer: Dimensions

Note: This Question is unanswered, help us to find answer for this one

In _______, transactions are collected over time and then processed all at once.

Answer

Correct Answer: Batch processing

Note: This Question is unanswered, help us to find answer for this one

In _______, data is processed at the same time the transaction occurs.

Answer

Correct Answer: Real-time processing

Note: This Question is unanswered, help us to find answer for this one

Fact and dimension tables are related by ____ keys.

Answer

Correct Answer: Foreign

Note: This Question is unanswered, help us to find answer for this one

Data mining is part of the “____” section of the business intelligence framework.

Answer

Correct Answer: Processes

Note: This Question is unanswered, help us to find answer for this one

A characteristic of decision support data is ____.

Answer

Correct Answer: High query activity

Note: This Question is unanswered, help us to find answer for this one