Recursive Views MCQs with Answers PDF Download – Test 178

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

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

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

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

A relation schema consists of a list of attributes and their corresponding

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

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