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

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

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

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

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

A.It generates an error because the alias is not valid.

B.It generates an error because the concatenation operator can be used to combine only two items.

C.IT executes successfully and gives the correct output.

D.It executes successfully but does not give the correct output.

E.It generates an error because the usage of the ROUND function in the expression is not valid.

A.Views created in the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid.

B.Unique key constraints defined on the COUNTRY column are removed.

C.A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.

D.Indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command is executed.

E.Synonyms existing of the DEPARTMENTS table would have to be re-created.

A.Only the second statement will display departments with no employees.

B.Only the first statement will display departments with no employees.

C.Only the second statement will execute successfully if you add E.AVG_SAL to the select list.

D.Only the first statement will execute successfully if you add E.AVG_SAL to the select list.

E.Both statements will execute successfully If you add E.AVG_SAL. to the select list.

F.Both statements will display departments with no employees.

A.The outer query stops evaluating the result set of the inner query when the first value is found.

B.It is used to test whether the values retrieved by the inner query exist in the result of the outer query.

C.It is used to test whether the values retrieved by the outer query exist in the result set of the inner query.

D.The outer query continues evaluating the result set of the inner query until all the values in the result set are processed.