Author Topic: Oracle DBA Question 70  (Read 55 times)

0 Members and 1 Guest are viewing this topic.

Offline ralph0595

  • Full Member
  • *
  • Posts: 107
  • Karma: +0/-0
    • View Profile
Oracle DBA Question 70
« on: April 23, 2009, 05:13:40 AM »
Question:

More stringent user access requirements have been issued. You need to do these tasks for the user pward:



1. Change user authentication to external authentication.
2. Revoke the user\'s ability to create objects in the TEST TS tablespace.
3. Add a new default and temporary tabespace and set a quota of unlimited.
4. Assign the user to the CLERK profile.

Which statement meets the requirements?

A. ALTER USER pward
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test_ts
GRANT clerk TO pward;
B. ALTER USER pward
IDENTIFIED by pward
DEFAULT TABLESPACE data_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test_ts
PROFILE clerk;
C. ALTER USER pward
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test_ts
PROFILE clerk;
D. ALTER USER pward
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
TEMPORARY TABLESPACE temp_ts
QUOTA UNLIMITED ON data_ts
QUOTA 0 ON test ts;
GRANT clerk TO pward;

Answer: C

Techronnati | where technology never sleeps

Oracle DBA Question 70
« on: April 23, 2009, 05:13:40 AM »

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
54 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.