Dbasysprivs d dbacolprivs answer c explanation answer

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: COL_PRIVS Answer: C Explanation: Answer C is correct. You can find information about system privileges granted to all users in the DBA_SYS_PRIVS view. Incorrect Answers: A: DBA_PRIVS view shows all available privileges, disregarding of privileges for users. B: DBA_TAB_PRIVS view shows privileges on tables, not system privileges for users. D: DBA_COL_PRIVS view as DBA_TAB_PRIVS view provides information about the object privileges granted in the database. Actualtests.com - The Power of Knowing 1Z0-023 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 489 Chapter 10: Managing Database Use QUESTION 80: User A grants the SELECT privilege WITH GRANT OPTION on the table EMP to User B. User B then grants SELECT on a EMP to User C. What will happen if User A revokes User B's SELECT privilege? A. User B will not be able to SELECT, and User C will be unaffected. B. An error will occur unless User B first revokes SELECT from user C. C. Nothing, unless the CASCADE CONSTRAINTS option was used. D. Both User B and User...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online