Transformation of Relational Expressions MCQs & Quiz Online PDF Book Download

Transformation of relational expressions multiple choice questions (MCQs), transformation of relational expressions quiz answers to learn online CS courses for database management online classes. Query optimization MCQs, transformation of relational expressions quiz questions and answers for information technology masters degree online. Learn heuristic optimization in dbms, heuristic query optimization, transformation of relational expressions test prep for data analytics certification.

Learn query optimization MCQ: operations of natural-join are, with choices commutative, associative, distributive, and conjunctive for information technology masters degree online. Practice merit scholarships assessment test, online learning transformation of relational expressions quiz questions for competitive exams in computer science major .

MCQs on Transformation of Relational Expressions PDF Book Download

MCQ: Operations of Natural-join are

  1. Commutative
  2. Associative
  3. Distributive
  4. Conjunctive

B

MCQ: Optimizer that explores space of all query-evaluation plans is called

  1. Cost-based
  2. Plan-based
  3. Estimate-based
  4. Count-based

A

MCQ: Process of replacement of a nested query by a query with a join is called

  1. Correlation
  2. Decorrelation
  3. Materialization
  4. Non-materialization

B

MCQ: Operations of theta-join are

  1. Distributive
  2. Conjunctive
  3. Commutative
  4. Associative

C

MCQ: Two expressions generate same set of tuples on every legal database instance, relational expressions are said to be

  1. Dependant
  2. Independent
  3. Equivalent
  4. Non-equivalent

C