Oracle Database SQL — Question 173

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

Answer options

• A. An object privilege can be granted to other users only by the owner of that object.
• B. The owner of an object acquires all object privileges on that object by default.
• C. The WITH GRANT OPTION clause can be used only by DBA users.
• D. An object privilege can be granted to a role only by the owner of that object.
• E. A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY constraints using that table.

Correct answer: B, E

Explanation

Option B is correct because the owner of an object inherently has all privileges on that object. Option E is also correct as it specifies the necessity for a table owner to grant the REFERENCES privilege for others to create FOREIGN KEY constraints. Options A, C, and D are incorrect because they incorrectly limit the ability to grant privileges or misstate the privileges associated with object ownership.