Recursive Views MCQs (Multiple Choice Questions) PDF Download - 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