A.SELECT dept_id, AVG(MAX(salary)) FROM employees GROUP BY dept_id;

B.join_date;
SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

C.SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id,

D.

A.display all suppliers whose list price is more than 1000

B.display the number of products whose list prices are more than the average list price

C.display all products whose minimum list price is more than the average list price of products having the status 'orderable'

D.display the minimum list price for each product status

E.display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'

A.All rows are evaluated by all the three WHEN clauses.

B.The INSERT statement will return an error because the ELSE clause is missing.

C.Each row is evaluated by the first WHEN clause and if the condition is false then the row would be evaluated by the subsequent WHEN clauses.

D.Each row is evaluated by the first WHEN clause and if the condition is true, then the row would be evaluated by the subsequent WHEN clauses.

A.They can be performed on external tables using SQL* Loader.

B.They can be performed on relational tables.

C.They can be performed only by using a subquery.

D.They can insert each computed row into more than one table.

E.They can be performed on views.

F.They can be performed on remote tables.

A.Views cannot be used to query rows from an underlying table if the table has a PRIMARY KEY and the PRIMARY KEY columns are not referenced in the defining query of the view.

B.Views cannot be used to add rows to an underlying table if the table has columns with NOT NULL constraints lacking default values which are not referenced in the defining query of the view.

C.The WITH CHECK clause has no effect when deleting rows from the underlying table through the view.

D.Insert statements can always be done on a table through a view.

E.Delete statements can always be done on a table through a view.

F.Views cannot be used to add or modify rows in an underlying table if the defining query of the view contains the DISTINCT keyword.