Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 123

Which two are true about granting privileges on objects? (Choose two.)

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

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

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

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

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

Correct Answer: B, E

The owner of an object acquires all object privileges on that object by default, which is true because ownership implies full control over the object. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table, as the REFERENCES privilege is specifically required to reference a table in a foreign key constraint.

Discussion

lucemqyOptions: BE

BE is the correct answer