Measures of Query Cost Practice Test PDF Download eBook p. 309

MCQ: 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: 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: 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: 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: 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