Recursive Views MCQs with Answers PDF Download – Test 178

MCQ 886: Any recursive view must be defined as the union of subqueries of number:

1. Two
2. Three
3. Four
4. Five

MCQ 887: The associated number of parallel execution servers with a single operation is called its:

1. Degree of parallelism
2. Degree of dependency
3. Degree of dimension
4. Degree of direction

MCQ 888: SQL allows subqueries wherever an expression returning a value is permitted, provided the subquery returns:

1. Single attribute
2. One tuple
3. Single value
4. Both A and B

MCQ 889: A relation schema consists of a list of attributes and their corresponding:

1. Variables
2. Instances
3. Domains
4. Tuples

MCQ 890: The relationship of specialization may also be known as a/an:

1. Subclass-superclass relationship
2. Superclass-subclass relationship
3. Higher-level relationship
4. Lower-level relationship