Which two statements are true?

You execute the commands:
SQL>CREATE USER sidney
IDENTIFIED BY out_standing1
DEFAULT TABLESPACE users
QUOTA 10M ON users
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
SQL> GRANT CREATE SESSION TO Sidney;
Which two statements are true?

You execute the commands:
SQL>CREATE USER sidney
IDENTIFIED BY out_standing1
DEFAULT TABLESPACE users
QUOTA 10M ON users
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;
SQL> GRANT CREATE SESSION TO Sidney;
Which two statements are true?

A.
The create user command fails if any role with the name Sidney exists in the database.

B.
The user sidney can connect to the database instance but cannot perform sort operations because no
space quota is specified for the temp tablespace.

C.
The user sidney is created but cannot connect to the database instance because no profile is default.

D.
The user sidney can connect to the database instance but requires relevant privileges to create objects
in the users tablespace.

E.
The user sidney is created and authenticated by the operating system.

Explanation:
http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8003.htm



Leave a Reply 0

Your email address will not be published. Required fields are marked *