MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 21 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
State true or false: In OLAP, analysts cannot view a dimension in different levels of detail. |
| A. | True |
| B. | False |
| Answer» C. | |
| 2. |
The operation of moving from coarser granular data to finer granular data is called _______ |
| A. | Reduction |
| B. | Increment |
| C. | Roll back |
| D. | Drill down |
| Answer» E. | |
| 3. |
State true or false: OLAP systems can be implemented as client-server systems |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
The _______ function allows substitution of values in an attribute of a tuple |
| A. | Cube |
| B. | Unknown |
| C. | Decode |
| D. | Substitute |
| Answer» D. Substitute | |
| 5. |
What is the full form of OLAP? |
| A. | Online Application Programming |
| B. | Online Application Processing |
| C. | Online Analytical programming |
| D. | Online Analytical Processing |
| Answer» E. | |
| 6. |
THE_OPERATION_OF_MOVING_FROM_COARSER_GRANULAR_DATA_TO_FINER_GRANULAR_DATA_IS_CALLED________?$ |
| A. | Reduction |
| B. | Increment |
| C. | Roll back |
| D. | Drill down |
| Answer» E. | |
| 7. |
WHAT_DO_DATA_WAREHOUSES_SUPPORT??$ |
| A. | OLAP |
| B. | OLTP |
| C. | OLAP and OLTP |
| D. | Operational databases |
| Answer» C. OLAP and OLTP | |
| 8. |
State_true_or_false:_In_OLAP,_analysts_cannot_view_a_dimension_in_different_levels_of_detail.$ |
| A. | True |
| B. | False |
| Answer» C. | |
| 9. |
State true or false: OLAP systems can be implemented as client-server system? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
Which of the following OLAP systems do not exist? |
| A. | HOLAP |
| B. | MOLAP |
| C. | ROLAP |
| D. | None of the mentioned |
| Answer» E. | |
| 11. |
The _______ function allows substitution of values in an attribute of a tuple |
| A. | Cube |
| B. | Unknown |
| C. | Decode |
| D. | Substitute |
| Answer» D. Substitute | |
| 12. |
In SQL the cross-tabs are created using |
| A. | Slice |
| B. | Dice |
| C. | Pivot |
| D. | All of the mentioned |
| Answer» B. Dice | |
| 13. |
How many dimensions of multi-dimensional data do cross tabs enable analysts to view? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | None of the mentioned |
| Answer» C. 3 | |
| 14. |
The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________ |
| A. | Rollup |
| B. | Drill down |
| C. | Dicing |
| D. | Pivoting |
| Answer» B. Drill down | |
| 15. |
The operation of moving from finer granular data to coarser granular data is called _______ |
| A. | Reduction |
| B. | Increment |
| C. | Roll up |
| D. | Drill down |
| Answer» D. Drill down | |
| 16. |
The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is |
| A. | Slicing |
| B. | Dicing |
| C. | Pivoting |
| D. | Both Slicing and Dicing |
| Answer» B. Dicing | |
| 17. |
The operation of changing a dimensions used in a cross-tab is called as ________ |
| A. | Alteration |
| B. | Pivoting |
| C. | Piloting |
| D. | Renewing |
| Answer» C. Piloting | |
| 18. |
The generalization of cross-tab which is represented visually is ____________ which is also called as data cube. |
| A. | Two dimensional cube |
| B. | Multidimensional cube |
| C. | N-dimensional cube |
| D. | Cuboid |
| Answer» B. Multidimensional cube | |
| 19. |
Data that can be modelled as dimension attributes and measure attributes are called ___________ |
| A. | Mono-dimensional data |
| B. | Multi-dimensional data |
| C. | Measurable data |
| D. | Efficient data |
| Answer» C. Measurable data | |
| 20. |
Data that can be modeled as dimension attributes and measure attributes are called _______ data. |
| A. | Multidimensional |
| B. | Singledimensional |
| C. | Measured |
| D. | Dimensional |
| Answer» B. Singledimensional | |
| 21. |
OLAP stands for |
| A. | Online analytical processing |
| B. | Online analysis processing |
| C. | Online transaction processing |
| D. | Online aggregate processing |
| Answer» B. Online analysis processing | |