Unformatted text preview: C will no longer have SELECT privilege on EMP.
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.
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
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
Which two methods will open a database? (Choose two)
A. Issue t...
View Full Document
- Fall '09
- Oracle Database, Jason S. Couchman, DBA Certification Exam, Certification Exam Guide