CS614 Midterm MCQs by Team Aiza

Q1. Which of the following is an example of slowly changing dimensions?

1. Asset disposal
2. Inheritance
3. Association
4. Aggregation

Correct answer: Asset disposal

Q2. Which is not a class of aggregation functions?

1. Holistic
2. Distributive
3. Associative
4. Algebraic

Correct answer: Associative

Q3. Which is not an issue of ROLAP in the following?

1. Maintenance
2. Standard hierarchy of dimensions
3. Aggregation pit-falls
4. Non-standard conventions

Correct answer: Non-standard conventions

Q4. In Extract, Load, Transform (ELT) process, data transformation _____

1. Depends on the nature of the source database
2. Does not take place
3. Takes place on the data warehouse server
4. Takes place on a separate transformation server

Correct answer: Takes place on the data warehouse server

Q5. Which of the following is NOT an example of dimension?

1. Region
2. Product
3. Date
4. Sales Volume

Correct answer: Sales Volume

Q6. Simple scalar transformation is a ________________ mapping from one set of values to another set of values using

1. One-to-one
2. Many-to-one
3. Many-to-many
4. One-to-many

Correct answer: One-to-one

Q7. Which of the following is NOT an example of derived attribute?

1. Age
2. Annual Salary
3. GPA
4. Email Address

Correct answer: Email Address

Q8. OLAP is:

1. Physical database design
2. Implementation technique
3. None of the given options
4. Framework

Correct answer: Framework

Q9. Which is not a class of anomalies in the following?

1. Semantically Dirty Data
2. Coverage Anomalies
3. Syntactically Dirty Data
4. Dirty Anomalies

Correct answer: Dirty Anomalies

Q10. _____________ facilitates a mobile computing paradigm.

1. MOLAP
2. DOLAP
3. HOLAP
4. ROLAP

Correct answer: DOLAP

Q1. The divide and conquer cube partitioning approach helps alleviate the ____________ limitations of MOLAP implementation.

1. Security
2. Maintainability
3. Flexibility
4. Scalability

Correct answer: Scalability

Q2. Which of the following is NOT one of the advantages of changed data capture (CDC) technique?

1. Flat files are not required
2. Extraction of changed data occurs immediately
3. No incremental on-line I/O required for log tape
4. Limited query interface is required for data extraction

Correct answer: No incremental on-line I/O required for log tape

Q3. The main reason(s) for the increase in cube size may be

1. All of the given options
2. Increase in the number of dimensions
3. Increase in the cardinality of the dimensions
4. Increase in the amount of detail data

Correct answer: All of the given options

Q4. __________________ is the lowest level of detail or the atomic level of data stored in the warehouse.

1. Fact
2. Cube
3. Grain
4. Dimensions

Correct answer: Grain

Q5. Which is not an issue of ROLAP in the following?

1. Aggregation pit-falls
2. Non-standard conventions
3. Standard hierarchy of dimensionsD. Maintenance

Correct answer: Standard hierarchy of dimensionsD. Maintenance

Q6. _____ allows download of “cube” structures to a desktop platform without the need for shared relational or cube server.

1. DOLAP
2. HOLAP
3. ROLAP
4. MOLAP

Correct answer: DOLAP

Q7. Which of the following is not an example of dimension?

1. Sales amount
2. ATM card no
3. ATM_LocationD. Time/Date

Correct answer: Sales amount