Bitmap Indices Quiz Questions and Answers 217 PDF Download

Learn bitmap indices quiz, online db test 217 for online courses, distance learning. 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 for computer technology course prep.

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

Quiz on Bitmap Indices Quiz PDF Download Worksheet 217

Bitmap Indices Quiz

MCQ. Hash function in static hashing uses 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 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. Statement that can be used to exit loop, is said to be

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

D

Aspects of Database Design Quiz

MCQ. 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