Author Topic: Oracle DBA Question 64  (Read 58 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 64
« on: April 21, 2009, 12:51:52 PM »
Question:
Anne issued this SQL statement to grant Bill access to the CUSTOMERS table in Anne\'s schema:
GRANT SELECT ON customers TO bill WITH GRANT OPTION;
Bill issued this SQL statement to grant Claire access to the Customers table in Anne\'s schema:
Later, Anne decides to revoke the select privilege on the CUSTOMERS table from Bill.
Which statement correctly describes both what Anne can do to revoke the priviege, and the effect of the REVOKE command?

A. Anne can run the REVOKE SELECT ON customers FROM bill statement. Both Bill and Claire lose their access to the customers table.
B. Anne can run the REVOKE SELECT ON customers FROM bill statement. Bill loses access to the CUSTOMERS table, but Claire will keep her access.
C. Anne cannot run the REVOKE SELECT ON customers from BILL statement unless ill first revokes Claire\'s access to the CUSTOMERS table.
D. Anne must run the REVOKE SELECT ON customers FROM bill CASCADE statement. Both Bill and Claire lode their access to the CUSTOMERS table

Answer: A

Techronnati | where technology never sleeps

Oracle DBA Question 64
« on: April 21, 2009, 12:51:52 PM »

Mountain View

 

Related Topics

  Subject / Started by Replies Last post
0 Replies
62 Views
Last post April 19, 2009, 06:01:21 AM
by ralph0595
0 Replies
64 Views
Last post April 19, 2009, 06:39:28 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:41:37 AM
by ralph0595
0 Replies
58 Views
Last post April 19, 2009, 06:46:32 AM
by ralph0595
0 Replies
55 Views
Last post April 19, 2009, 06:51:28 AM
by ralph0595

Posting Disclaimer: Any individual may post a message in this forum and may do so anonymously. Therefore, the sole author is exclusively and entirely responsible for all opinions in that message. They do not represent the official opinions of Techronnati, its administrators or moderators or the Techronnati Management. Techronnati is merely acting as an impartial conduit for constitutionally protected free speech and is not responsible and will not be held liable for the content of such messages. All images and service logos are trademarks of their respective owners.