Aggregate Functions Practice Test PDF Download eBook p. 252

MCQ: The output of the query:
select avg (salary)
from instructor
where dept name='Comp. Sci.';

1. Average salary of instructors in the Computer Science department.
2. Salary of instructors in the Computer Science department.
3. Average salary in the Computer Science department.
4. Maximum salary of instructors in the computer science department

MCQ: A modification to the database expressed in terms of a view must be translated to a

1. Physical model of database
2. Logical model of database
3. View model of database
4. Virtual model of database

MCQ: SQL provides a rich DDL that allows one to define

1. Tables
2. Integrity Constraints
3. Assertions
4. All of the Above

MCQ: Multiples of rollup and cube operations can be used in a single

1. having by clause
2. Group by clause
3. select clause
4. define clause

MCQ: To find logically implied functional dependencies, the types of rules to be followed are of type

1. 2 types
2. 3 types
3. 4 types
4. 5 types