Advance Database MCQs
Advance Database MCQs
These Advance Database multiple-choice questions and their answers will help you strengthen your grip on the subject of Advance Database. You can prepare for an upcoming exam or job interview with these Advance Database MCQs.
So scroll down and start answering.
1: A characteristic of decision support data is ____.
A. Data warehouse
B. High query activity
C. High normalization
D. Governance
2: Data mining is part of the “____” section of the business intelligence framework.
A. Processes
B. Governance
C. Portals
D. Data warehouse
3: Fact and dimension tables are related by ____ keys.
A. Portals
B. Metrics
C. Matrix-like
D. Foreign
4: In _______, data is processed at the same time the transaction occurs.
A. Batch processing
B. Group processing
C. Real-time processing
5: In _______, transactions are collected over time and then processed all at once.
A. Batch processing
B. Group processing
C. Real-time processing
6: The basic star schema has four components: facts, _____, attributes, and attribute hierarchies.
A. Dimensions
B. Data store
C. Data marts
D. Aggregation
7: A correlated subquery is evaluated _____ for each row processed by the parent statement.
A. ONCE
B. EVERY TIME
C. COMPLETELY
8: Vba procedures are created, modified, and displayed in the ____ window.
A. Immediate
B. Code
C. VBA
D. Query
List of Advance Database MCQs ...
Available in:
Advance Database MCQs
