|
CS614
|
The Automated Prospective Analyses Offered By Data Mining Move Beyond The Analyses Of Past Events Provided By __________ Tools Typical Of Decision Support Systems
|
Introspective
|
Intuitive
|
Reminiscent
|
Retrospective
|
D
|
|
CS614
|
Data Transformation Services (Dts) Provide A Set Of That Lets You Extract Transform And Consolidate Data From Disparate Sources Into Single Or Multiple Destinations Supported By Dts Connectivity
|
Documentations
|
Guidelines
|
Tools
|
None Of These
|
C
|
|
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
|
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
|
There Are Many Variants Of The Traditional Nested-Loop Join If There Is An Index Is Exploited Then It Is Called__________
|
Navy Nested Loop Join Index
|
Nested Loop Join Temporary Index
|
Index Nested-Loop Joins
|
None Of These
|
B
|
|
CS614
|
___________ Breaks A Table Into Multiple Tables Based Upon Common Column Values
|
Horizontal Splitting
|
Vertical Splitting
|
Both
|
None Of These
|
A
|
|
CS614
|
The Technique That Is Used To Perform These Feats In Data Mining Modeling And This Act Of Model Building Is Something That People Have Been Doing For Long Time Certainly Before The Of Computers Or Data Mining Technology
|
Access Advent
|
Ascent Avowal
|
Both
|
None Of These
|
A
|
|
CS614
|
To Judge Effectiveness We Perform Data Profiling Twice
|
One Before Extraction And The Other After Extraction
|
One Before Transformation And The Other After Transformation
|
One Before Loading And The Other After Loading
|
All Of Above
|
B
|
|
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
|
When Performing Objective Assessments Companies Follow A Set Of Principles To Develop Metrics Specific To Their Needs There Is Hard To Have One Size Fits All Approach. Which Of The Following Statement Represents The Pervasive Functional Forms?
|
Only Min Or Max Operation Weighted Average
|
Only Simple Ratio Min Or Max Operation
|
Only Complex Ratio Min Operation Max Operation
|
Simple Ratio Min Or Max Operation Weighted Average
|
D
|
|
CS614
|
During Etl Process Of An Organization Suppose You Have Data Which Can Be Transformed Using Any Of The Transformation Method. Which Of The Following Strategy Will Be Your Choice For Least Complexity?
|
One-To-One Scalar Transformation
|
One-To-Many Element Transformation
|
Many-To-Many Element Transformation
|
Many-To-One Element Transformation
|
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
|
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
|
___________ 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
|
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
|
Data Mining Derives Its Name From The Similarities Between Searching For Valuable Business Information In A Large Database For Example Finding Linked Products In Gigabytes Of Store Scanner Data And Mining A Mountain For A ___________ Of Valuable Ore
|
Furrow
|
Streak
|
Trough
|
Vein
|
D
|
|
CS614
|
The Performance In A Molap Cube Comes From The O(1) Look-Up Time For The Array Data Structure
|
True
|
False
|
Na
|
Na
|
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
|
A Data Warehouse Implementation Without An Olap Tool Is Always Possible
|
True
|
False
|
Na
|
Na
|
B
|
|
CS614
|
The Most Recent Attack Is The __________ Attack On The Cotton Crop During 2003- 04 Resulting In A Loss Of Nearly 0.5 Million Bales
|
Boll Worm
|
Purple Worm
|
Blue Worm
|
Cotton Worm
|
A
|