Online Exam Preparation
MCQs Library
Browse subject-wise multiple choice questions, review answers quickly, and start a test from the same section.
Questions
| Code | Question | Option A | Option B | Option C | Option D | Answer |
|---|---|---|---|---|---|---|
| CS614 |
For A Smooth Dwh Implementation We Must Be A Technologist.
|
True
|
False
|
Na
|
Na
|
B |
| CS614 |
For Good Decision Making Data Should Be Integrated Across The Organization To Cross The Lob (Line Of Business). This Is To Give The Total View Of Organization From
|
Owner’S Perspective
|
Customer’S Perspective
|
Decision Maker’S Perspective
|
Employee’S Perspective
|
B |
| CS614 |
Grain Is The __________ Level Of Data Stored In The Warehouse
|
Atomic
|
Summarized
|
Aggregated
|
Cube
|
A |
| CS614 |
If Every Key In The Data File Is Represented In The Index File Then Index Is
|
Dense Index
|
Sparse Index
|
Inverted Index
|
None Of These
|
A |
| CS614 |
If Some Error Occurs Execution Will Be Terminated Abnormally And All Transactions Will Be Rolled Back. In This Case When We Will Access The Database We Will Find It In The State That Was Before The __________
|
Connection Of Package
|
Execution Of Package
|
Creation Of Package
|
None Of These
|
B |
| CS614 |
If Someone Told You That He Had A Good Model To Predict Customer Usage The First Thing You Might Try Would Be To Ask Him To Apply His Model To Your Customer Where You Already Knew The Answer
|
Base
|
Drive
|
File
|
Log
|
C |
| CS614 |
If W Is The Window Size And N Is The Size Of Data Set Then The Complexity Of Merging Phase In Bsn Method Is__________
|
O (N)
|
O (W)
|
O (W N)
|
O (W Log N)
|
C |
| CS614 |
In A Traditional Mis System There Is An Almost Linear Sequence Of Queries
|
True
|
False
|
Na
|
Na
|
A |
| CS614 |
In Dwh Project It Is Assured That __________ Environment Is Similar To The Production Environment
|
Designing
|
Development
|
Analysis
|
Implementation
|
B |
| CS614 |
In Horizontal Splitting We Split A Relation Into Multiple Tables On The Basis Of
|
Common Column Values
|
Common Row Values
|
Different Index Values
|
Value Resulted By Ad-Hoc Query
|
A |
| CS614 |
Investing Years In Architecture And Forgetting The Primary Purpose Of Solving Business Problems Results In Inefficient Application. This Is The Example Of ___________ Mistake
|
Extreme Technology Design
|
Extreme Architecture Design
|
Both
|
None Of These
|
B |
| CS614 |
It Is Observed That Every Year The Amount Of Data Recorded In An Organization Is
|
Doubles
|
Triples
|
Quartiles
|
Remains Same As Previous Year
|
A |
| CS614 |
Many Data Warehouse Project Teams Waste Enormous Amounts Of Time Searching In Vain For A __________
|
Silver Bullet
|
Golden Bullet
|
Suitable Hardware
|
Compatible Product
|
A |
| CS614 |
Modeling Technique Is More Appropriate For Data Warehouses
|
Entity-Relationship
|
Dimensional
|
Physical
|
None Of The Given
|
A |
| CS614 |
Multi-Dimensional Databases (Mdds) Typically Use __________ Formats To Store Pre-Summarized Cube Structures
|
Sql
|
Proprietary File
|
Object Oriented
|
Non- Proprietary File
|
B |
| CS614 |
Multidimensional Databases Typically Use Proprietary __________ Format To Store Pre-Summarized Cube Structures
|
File
|
Application
|
Aggregate
|
Database
|
A |
| CS614 |
Node Of A B-Tree Is Stored In Memory Block And Traversing A B-Tree Involves Page Faults
|
O (N)
|
O (N2)
|
O (N Log N)
|
O (Log N)
|
D |
| CS614 |
Non Uniform Distribution When The Data Is Distributed Across The Processors Is Called __________
|
Uncontrolled Distribution
|
Pipeline Distribution
|
Distributed Distribution
|
Skew In Partition
|
D |
| CS614 |
Numa Stands For __________
|
Non-Uniform Memory Access
|
Non-Updateable Memory Architecture
|
New Universal Memory Architecture
|
None Of These
|
A |
| CS614 |
Pakistanis One Of The Five Major __________ Countries In The World
|
Cotton-Growing
|
Rice-Growing
|
Weapon Producing
|
None Of These
|
A |