D both user b and user c will no longer have select

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C will no longer have SELECT privilege on EMP. Answer: D Explanation: Answer D is correct. When an object privilege is revoked, there are some cascade events. If user A revokes user B's SELECT privilege, both user B and user C will no longer have SELECT privilege on EMP table. Incorrect Answers: A: Both user will be affected, B and C. B: There is no error if user A revokes from user B SELECT privilege, cascade event will happened. C: You don't need to use CASCADE CONSTRAINTS to revoke privilege. Only if the user has been given the REFERENCES privileges and used it to create a FOREIGN KEY constraint to another table, then there is some cascading that must take place in order to complete the revocation of the REFERENCES privilege: REVOKE REFERENCES ON EMP FROM B CASCADE CONSTRAINTS. But this question does say nothing about constraints. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 485-489 Chapter 10: Managing Database Use QUESTION 81: Which two methods will open a database? (Choose two) A. Issue t...
View Full Document

Ask a homework question - tutors are online