A.An alias name must always be specified in quotes.

B.An alias name must not be used in an ORDER BY clause.

C.An allas name must not contain space characters.

D.An alias name must not be used in a GROUP BY clause.

A.An object privilege can be granted to other users only by the owner of that object

B.A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table

C.The owner of an object acquires all object privilege on that object by default

D.An object privilege can be granted to a role only by the owner of that object

E.The WITH GRANT OPTION clause can be used only by DBA users

A.truncate leavers any indexes on the table in an UNUSABLE STATE.

B.the result of a delete can be undone by issuing a rollback

C.the result of a truncate can be undone by issuing a ROLLBACK.

D.TRUNCATE can use a where clause to determine which row(s) should be removed.

E.delete can use a where clause to determine which row(s) should be removed.

A.SELECT MAX (salary)
FROM employees
GROUP BY department_id;

B.SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

C.SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

D.SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

E.SELECT MAX (salary)
FROM employees;

A.The WITH CHECK clause prevents certain rows from being updated or inserted.

B.Tables in the defining query of a view must always exist in order to create the view.

C.Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

D.Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error.

E.Date Manipulation Language (DML) can always be used on views.

F.Views can be updated without the need to re-grant privileges on the view.

G.The WITH CHECK clause prevents certain rows from being displayed when querying the view.