If a task takes “T” time units to execute on a single data item, then execution of this task on “N” data items will take _______ time units.

• A) N+T
• B) N/T
• C) N*T
• D) N-T

In context of bitmap index, the length of the bit vector is:

• A) The possible number of bitmap tables formed for corresponding field (column)
• B) The possible number of domain values in corresponding field (column)
• C) The number of records in the base table
• D) None of the given options

________ is known as state of being only one of its kind or being without an equal or parallel.

• A) Consistency
• B) Completeness
• C) Accessibility
• D) Uniqueness

If a product meets formally defined "requirement specifications," yet fails to be a quality product from the customers' perspective, this means the requirements were________.

• A) Unclear
• B) Unrefined
• C) Undefined
• D) Defective

The ___________ operator proves useful in more complex metrics applicable to the dimensions of timeliness and accessibility.

• A) None of given
• B) Min and Max
• C) Min
• D) Max

In B-tree index, the lowest level index blocks are called leaf blocks, and these blocks contain:

• A) Every indexed data value and a corresponding ROWID
• B) Every indexed data value and pointer to next level block
• C) Every indexed data value and pointer to root block
• D) NULL value to make the leaf terminal node

__________ is making all efforts to increase effectiveness and efficiency in meeting accepted customer expectations.

• A) Quality Establishment
• B) Quality Maintenance
• C) Quality assurance
• D) Quality improvement

One of the preconditions to decide about operations to be parallelized is that:

• A) Operations share same namespace
• B) Operations can be implemented independent of each other
• C) Operations share same memory location
• D) Output of one operation becomes input of other

In nested-loop join case, if there are ‘M’ rows in outer table and ‘N’ rows in inner table, time complexity is

• A) O (M log N)
• B) O (log MN)
• C) O (M + N)
• D) O (MN)

Most DWH implementations today do not use ______________ enforced by the database, but as TQM methods improve overall data quality and database optimizers.

• A) Using Data Quality Rules
• B) Attribute domain
• C) Consistency Integrity
• D) Referential Integrity

If every key in the data file is represented in the index file then it is called

• A) Sparse Index
• B) A Multi level Sparse Index
• C) Dense Index
• D) Inverted Index

_______ refers to “Parallel execution of single data operation across multiple partitions of data”

• A) Hardware parallelism
• B) Software parallelism
• C) Data parallelism
• D) Operational parallelism

As the number of processors increase, the speedup should also increase. Thus we should have linear speedup. Which of the following is NOT one of the barriers to achieve this linear speed-up?

• A) Skew
• B) Amdahl’ Law
• C) Startup
• D) No Interference

Which of the following is NOT one of the variants of Nested-loop join?

• A) Binary index nested-loop join
• B) Indexed nested-loop join
• C) Naïve nested-loop join
• D) Temporary index nested-loop join

_________ lists each term in the collection only once and then shows a list of all the documents that contain the given term.

• A) Join index
• B) Bitmap index
• C) Cluster index
• D) Inverted index

_____________ is the degree of utility and value the data has to support the enterprise processes that enable accomplishing enterprise objectives.

• A) Intrinsic Data Quality
• B) Weak Data Quality
• C) Realistic Data Quality
• D) Strong Data Quality

In context of data parallelism, the work done by query processor should be:

• A) Pipelined
• B) Maximum
• C) Filtered across partitions
• D) Almost zero

“If resources increase in proportion to increase in data size, time is constant”. The statement refers to:

• A) Size-up
• B) Scale-Up
• C) Speed-Up
• D) Over-utilized system

Which is not a/an characteristics of data quality?

• A) Accessibility
• B) Reliability
• C) Consistency
• D) Uniqueness

Two interesting examples of quality dimensions that can make use of the min operator are _________________.

• A) Reliability and appropriate amount of data
• B) Believability and Consistency
• C) Believability and appropriate amount of data
• D) Believability and Redundancy