MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 8 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Roll-up performs aggregation on a data cube. |
| A. | Yes |
| B. | No |
| C. | Can be yes or no |
| D. | Can not say |
| E. | |
| Answer» B. No | |
| 2. |
The pivot operation is also known as? |
| A. | dice |
| B. | rotation |
| C. | roll up |
| D. | None of the above |
| Answer» C. roll up | |
| 3. |
Which of the following is false about OLAP? |
| A. | Involves historical processing of information |
| B. | Useful in analyzing the business |
| C. | Number or users is in millions |
| D. | Number of records accessed is in millions |
| Answer» D. Number of records accessed is in millions | |
| 4. |
ROLAP servers are placed between relational back-end server and client front-end tools |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 5. |
_________ uses array-based multidimensional storage engines for multidimensional views of data. |
| A. | KOLAP |
| B. | MOLAP |
| C. | ROLAP |
| D. | ZOLAP |
| Answer» C. ROLAP | |
| 6. |
How many types of OLAP servers? |
| A. | 1 |
| B. | 2 |
| C. | 3 |
| D. | 4 |
| Answer» E. | |
| 7. |
OLAP based on? |
| A. | one dimensional data model |
| B. | two dimensional data model |
| C. | multidimensional data model |
| D. | All of the above |
| Answer» D. All of the above | |
| 8. |
OLAP stands for? |
| A. | Offline Analytical Processing Server |
| B. | Online Analysts Processing Server |
| C. | Online Access Processing Server |
| D. | Online Analytical Processing Server |
| Answer» E. | |