Measures of Query Cost Quiz with Answers PDF Download – Test 309

MCQ 1541: Instead of minimizing the response time, optimizers can minimize a query plan's:

1. Disk usage
2. Resource consumption
3. Pipeline size
4. Indices length

MCQ 1542: As an example to find the set of all courses taught in the Fall 2009 as well as in Spring 2010, the operation to be used is:

1. The Union Operation
2. The Union all Operation
3. The Intersect Operation
4. The Except Operation

MCQ 1543: The output of a request such as:
insert into student
select *
from student;
would be:

1. Finite number of tuples
2. Infinite number of tuples
3. Finite number of attributes
4. Infinite number of relations

MCQ 1544: The alternative to phrase "greater than at least one", the > some comparison is used in the:

1. Select clause
2. From clause
3. Where clause
4. Group by clause

MCQ 1545: The operation that takes both the left and right outer join operations, is known as:

1. Whole outer join
2. Full outer join
3. Natural outer join
4. Combination outer join