View more random threads:
- Sta630 Research methods unsolved midterm papers
- mth101 unsolved midterm paper fall 2010
- Mgt502 Organizational behavior Unsolved current mcq's fall...
- FINALTERM EXAMINATION Spring 2010 ENG101- English...
- cs402 all old papers can downloaded
- ENG201 Business and Technical English Writing MIDTERM...
- IT430 E-Commerce Fall 2009 Final Term
- MGT101 Financial Accounting 2009 Final Term
- cs201 introduction to programing midterm paper fall 2010
- CS402- Theory of Automata latest mid term paper 2011...FINALTERM EXAMINATION
CS614- Data Warehousing
Question No: 1 ( Marks: 1 ) - Please choose one
It is observed that every year the amount of data recorded in an organization is
- Remains same as previous year
Question No: 2 ( Marks: 1 ) - Please choose one
Multidimensional databases typically use proprietary __________ format to store
pre-summarized cube structures.
Question No: 3 ( Marks: 1 ) - Please choose one
Pre-computed _______ can solve performance problems
Question No: 4 ( Marks: 1 ) - Please choose one
_______________, if fits into memory, costs only one disk I/O access to locate a
record by given key.
- A Dense Index
- A Sparse Index
- An Inverted Index
- None of These
Question No: 5 ( Marks: 1 ) - Please choose one
The degree of similarity between two records, often measured by a numerical
value between _______, usually depends on application characteristics.
- 0 and 1
- 0 and 10
- 0 and 100
- 0 and 99
Question No: 6 ( Marks: 1 ) - Please choose one
The purpose of the House of Quality technique is to reduce ______ types of risk.
Question No: 7 ( Marks: 1 ) - Please choose one
NUMA stands for __________
- Non-uniform Memory Access
- Non-updateable Memory Architecture
- New Universal Memory Architecture
Question No: 8 ( Marks: 1 ) - Please choose one
Which is the least appropriate join operation for Pipeline parallelism?
- Hash Join
- Inner Join
- Outer Join
- Sort-Merge Join
Question No: 9 ( Marks: 1 ) - Please choose one
There are many variants of the traditional nested-loop join. If the index is built as
part of the query plan and subsequently dropped, it is called
- Naive nested-loop join
- Index nested-loop join
- Temporary index nested-loop join
- None of these
Question No: 10 ( Marks: 1 ) - Please choose one
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
Question No: 11 ( Marks: 1 ) - Please choose one
With data mining, the best way to accomplish this is by setting aside some of
your data in a ________ to isolate it from the mining process; once the mining is
complete, the results can be tested against the isolated data to confirm the
Question No: 12 ( Marks: 1 ) - Please choose one
The Kimball s iterative data warehouse development approach drew on decades
of experience to develop the _____________.
- Business Dimensional Lifecycle
- Data Warehouse Dimension
- Business Definition Lifecycle
- OLAP Dimension
Question No: 13 ( Marks: 1 ) - Please choose one
We must try to find the one access tool that will handle all the needs of their
Question No: 14 ( Marks: 1 ) - Please choose one
For a smooth DWH implementation we must be a technologist.
Question No: 15 ( Marks: 1 ) - Please choose one
During the application specification activity, we also must give consideration to
the organization of the applications.
Question No: 16 ( Marks: 1 ) - Please choose one
Investing years in architecture and forgetting the primary purpose of solving
business problems, results in inefficient application. This is the example of
- Extreme Technology Design
- Extreme Architecture Design
- None of these
Question No: 17 ( Marks: 1 ) - Please choose one
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
Question No: 18 ( Marks: 1 ) - Please choose one
The users of data warehouse are knowledge workers in other words they are
_________ in the organization.
- Decision maker
- Database Administrator
- DWH Analyst
Question No: 19 ( Marks: 1 ) - Please choose one
_________ breaks a table into multiple tables based upon common column
- Horizontal splitting
- Vertical splitting
Question No: 20 ( Marks: 1 ) - Please choose one
Execution can be completed successfully or it may be stopped due to some
error. In case of successful completion of execution all the transactions will be
- Committed to the database
- Rolled back
Question No: 21 ( Marks: 2 )
What is meant by the statement Be a diplomat NOT a technologist in the
context of a data warehouse development project?
Question No: 22 ( Marks: 2 )
Elaborate the concept of data parallelism.
Question No: 23 ( Marks: 2 )
What will be the effect if we program a package by using DTS object model?
Question No: 24 ( Marks: 3 )
What is meant by the classification process? How we measure the accuracy of
Question No: 25 ( Marks: 3 )
How page dimension captures the static and dynamic nature of different web
Question No: 26 ( Marks: 3 )
Write down the limitations of pipelining parallelism?
Question No: 27 ( Marks: 5 )
For a maximum performance of Bitmapped index, what characteristics a query
Question No: 28 ( Marks: 5 )
How the three parallel tracks capture the user requirements in the Kimball s data
warehouse life cycle Road Map?
Question No: 29 ( Marks: 5 )
How time contiguous log entries and HTTP secure socket layer are used for user
session identification? What are the limitations of these techniques?
Question No: 30 ( Marks: 10 )
What are the issues regarding the record management tools at campuses where
text files are used to store data?
Question No: 31 ( Marks: 10 )
Shared RDBMS architecture requires a static partitioning. How do you perform the
[B]The more knowledge you have, the greater will be your fear of Allah.[/B]
Please Join My [B]Group Vuhelp[/B][B], Birthday Wishing, Daily Hadees[/B] [CODE][B]http://vuhelp.net/groups/vuhelp.html[/B]
There are currently 1 users browsing this thread. (0 members and 1 guests)