Recursive Queries MCQs Quiz Online PDF Download

Learn recursive queries MCQs, database management system test for online learning courses, test prep to practice test. Advanced sql quiz has multiple choice questions (MCQ), recursive queries quiz questions and answers, database triggers, java database connectivity (jdbc), jdbc and java, recursive queries tutorials for online open source DBMS courses distance learning.

Database management system practice test MCQ: construct that a recursive query should not use on recursive view, is with choices aggregation, unions , comparisons and booleans for online entry tests prep for bachelor, masters in computer engineering and diploma in engineering. Free study guide is for online learning recursive queries quiz with MCQs to practice test questions with answers.

MCQs on Recursive Queries Quiz PDF Download

MCQ: Construct that a recursive query should not use on recursive view, is

  1. Aggregation
  2. Unions
  3. Comparisons
  4. Booleans

A

MCQ: There are some restrictions on recursive query in a recursive view, query should be

  1. Increased and decreasing
  2. Stable
  3. Static
  4. Monotonic

D

MCQ: To define a temporary view whose definition is available only to query in which it is defined, clause used is

  1. Declare clause
  2. With clause
  3. Define clause
  4. While clause

B

MCQ: A transitive closure that uses an iterative procedure uses

  1. 2 temporary tables
  2. 3 temporary tables
  3. 4 temporary tables
  4. 5 temporary tables

B

MCQ: Recursive queries should not use not exists on a recursive view used by

  1. Subdomain
  2. Subset
  3. Subquery
  4. Subprocess

C