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 |
__________ If Fits Into Memory Costs Only One Disk I/O Access To Locate A Record By Given Key
|
An Inverted Index
|
A Sparse Index
|
A Dense Index
|
None Of These
|
C |
| CS614 |
__________ If Too Big And Does Not Fit Into Memory Will Be Expensive When Used To Find A Record By Given Key
|
An Inverted Index
|
A Sparse Index
|
A Dense Index
|
None Of These
|
C |
| CS614 |
__________ In Agriculture Extension Is That Pest Population Beyond Which The Benefit Of Spraying Outweighs Its Cost
|
Profit Threshold Level
|
Economic Threshold Level
|
Medicine Threshold Level
|
None Of These
|
A |
| CS614 |
__________ Is A Process Which Involves Gathering Of Information About Column Through Execution Of Certain Queries With Intention To Identify Erroneous Records
|
Record Duplicate Detection
|
Data Anomaly Detection
|
Data Profiling
|
None Of These
|
C |
| CS614 |
__________ Is The Technique In Which Existing Heterogeneous Segments Are Reshuffled Relocated Into Homogeneous Segments
|
Clustering
|
Aggregation
|
Segmentation
|
Partitioning
|
A |
| CS614 |
___________ Breaks A Table Into Multiple Tables Based Upon Common Column Values
|
Horizontal Splitting
|
Vertical Splitting
|
Both
|
None Of These
|
A |
| CS614 |
___________ Contributes To An Under-Utilization Of Valuable And Expensive Historical Data And Inevitably Results In A Limited Capability To Provide Decision Support And Analysis
|
The Lack Of Data Integration And Standardization
|
Missing Data
|
Data Stored In Heterogeneous Sources
|
None Of These
|
A |
| CS614 |
A __________ Dimension Is A Collection Of Random Transactional Codes Flags And/Text Attributes That Are Unrelated To Any Particular Dimension. The Dimension Is Simply A Structure That Provides A Convenient Place To Store The Attributes
|
Junk
|
Time
|
Parallel
|
None Of These
|
A |
| CS614 |
A Data Warehouse Implementation Without An Olap Tool Is Always Possible
|
True
|
False
|
Na
|
Na
|
B |
| CS614 |
A Data Warehouse May Include
|
Legacy Systems
|
Only Internal Data Sources
|
Privacy Restrictions
|
Small Data Mart
|
A |
| CS614 |
A Dense Index If Fits Into Memory Costs Only Disk I/O Access To Locate A Record By Given Key
|
One
|
Two
|
Linear
|
Quadratic
|
A |
| CS614 |
Ad-Hoc Access Means To Run Such Queries Which Are Known Already
|
True
|
False
|
Na
|
Na
|
B |
| CS614 |
All Data Is __________ Of Something Real. (I) An Abstraction (Ii) A Representation. Which Of The Following Option Is True?
|
I Only
|
Ii Only
|
Both I & Ii
|
None Of I & Ii
|
A |
| CS614 |
An Optimized Structure Which Is Built Primarily For Retrieval With Update Being Only A Secondary Consideration Is
|
Oltp
|
Olap
|
Dss
|
Inverted Index
|
D |
| CS614 |
Analytically Processing Uses __________ Instead Of Record Level Access
|
Multi-Level Aggregates
|
Single-Level Aggregates
|
Single-Level Hierarchy
|
None Of The Given
|
A |
| CS614 |
As Apposed To The Out Come Of Classification Estimation Deal With __________ Value Outcome
|
Discrete
|
Isolated
|
Continuous
|
Distinct
|
C |
| CS614 |
Change Data Capture Is One Of The Challenging Technical Issues In __________
|
Data Extraction
|
Data Loading
|
Data Transformation
|
Data Cleansing
|
A |
| CS614 |
Collapsing Tables Can Be Done On The __________ Relationships
|
One-To-One
|
Many-To-Many
|
Both One-To-One And Many-To-Many
|
None Of These
|
C |
| CS614 |
Companies Collect And Record Their Own Operational Data But At The Same Time They Also Use Reference Data Obtained From Sources Such As Codes Prices Etc.
|
Operational
|
Internal
|
External
|
None Of These
|
C |
| CS614 |
Cube Is A __________ Entity Containing Values Of A Certain Fact At A Certain Aggregation Level At An Intersection Of A Combination Of Dimensions
|
Logical
|
Physical
|
Analytical
|
None Of These
|
A |