CS101
532
CS201
225
CS301
232
CS302
174
CS304
192
CS401
224
CS402
258
CS403
228
CS408
113
CS411
121
CS502
249
CS504
268
CS601
679
CS604
381
CS605
261
CS607
184
CS609
230
CS610
300
CS614
100
CS703
65
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 |