Author Topic: Oracle DBA Question 69  (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 69
« on: April 23, 2009, 04:53:21 AM »
Question:
A new user, psmith, has just joined the organization. You need to create psmith as a valid user in the database. You have the following requirements:

1. Create a user who is authenticated externally.
2. Make sure the user has CONNECT and RESOURCE privileges.
3. Make sure the user does NOT have DROP TABLE and CREATE USER privileges.
4. Set a quota of 100 MB on the default tablespace and 500 K on the temporary tablespace.
5. Assign the user to the DATA_TS default tablespace and the TEMP_TS temporary tablespace

Which statement would you use to create the user?

A. CREATE USER psmith
IDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
QUOTA 100M on data_ts
QUOTA 500K on temp_ts
TEMPORARY TABLESPACE temp_ts;
REVOKE DROP_TABLE, CREATE_USER from psmith;
B. CREATE USER psmith
INDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
QUOTA 500K on temp_ts
QUOTA 100M on data_ts
TEMPORARY TABLESPACE temp_ts;
GRANT connect, resource to psmith;
C. CREATE USER psmith
INDENTIFIED EXTERNALLY
DEFAULT TABLESPACE data_ts
QUOTA 100M on data_ts
QUOTA 500K on temp_ts
TEMPORARY TABLESPACE temp_ts;
GRANT connect TO psmith;
D. CREATE USER psmith
IDENTIFIED GLOBALLY AS \'\'
DEFAULT TABLESPACE data_ts
QUOTA 100M on data_ts
QUOTA 500K on temp_ts
TEMPORARY TABLESPACE temp_ts;
GRANT connect, resource to psmith;
REVOKE DROP_TABLE, CREATE_USER from psmith;

Answer: B

Techronnati | where technology never sleeps

Oracle DBA Question 69
« on: April 23, 2009, 04:53:21 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.