Bitmap Indices Quiz Questions and Answers 217 PDF Download

Practice bitmap indices quiz, db quiz online 217 to learn. Free db MCQs questions and answers to learn bitmap indices MCQs with answers. Practice MCQs to test knowledge on bitmap indices, relational operations, aggregate functions, functions and procedures, aspects of database design worksheets.

Free bitmap indices worksheet has multiple choice quiz question as hash function in static hashing uses set of bucket addresses which is, answer key with choices as Variable, Large , Small and fixed problem solving to test study skills. For viva learning help and jobs' interview preparation tips, study online indexing and hashing multiple choice questions based quiz question and answers.

Quiz on Bitmap Indices Quiz PDF Download Worksheet 217

Bitmap Indices Quiz

MCQ. The hash function in static hashing uses the set of bucket addresses which is

  1. Variable
  2. Large
  3. Small
  4. Fixed

D

Relational Operations Quiz

MCQ. Relational operations can be applied to the results of queries as well as to the

  1. Given set of attributes
  2. Given set of tuples
  3. Given set of relations
  4. Given set of domains

C

Aggregate Functions Quiz

MCQ. All aggregate functions ignore null values in their input collection, except the

  1. Sum
  2. Avg
  3. Min/max
  4. Count(*)

D

Functions and Procedures Quiz

MCQ. The statement that can be used to exit the loop, is said to be

  1. EXIT
  2. EXEC EXIT
  3. EXEC END
  4. LEAVE

D

Aspects of Database Design Quiz

MCQ. The amount of time taken by a single transaction from start to finish in any case, is known to be its

  1. Buffer time
  2. Response time
  3. Queue time
  4. Throughput

B