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
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:
Answer will A and D
================================================================
Not B as user do not requires quota on TEMP Tablespace
Not C as assigning profile is not mandatory for the user created
Not E as the user created in the question is DB authenticated user
create role sidney;
Role created.
SQL> CREATE USER sidney
IDENTIFIED BY out_standing1
DEFAULT TABLESPACE users
QUOTA 10M ON users
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK; 2 3 4 5 6
CREATE USER sidney
*
ERROR at line 1:
ORA-01920: user name ‘SIDNEY’ conflicts with another user or role name
CREATE USER sidney
IDENTIFIED BY out_standing1
DEFAULT TABLESPACE users
QUOTA 10M ON users
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK; 2 3 4 5 6
User created.
SQL> GRANT CREATE SESSION TO Sidney;
Grant succeeded.
SQL> conn sidney/out_standing1
Connected.
SQL> create table x(y number);
create table x(y number)
*
ERROR at line 1:
ORA-01031: insufficient privileges
SQL> conn / as sysdba
Connected.
SQL> grant resource to sidney;
Grant succeeded.
SQL> conn / as sysdba
Connected.
SQL> create table x(y number);
Table created.
SQL> insert into x values (3);
1 row created.
SQL> insert into x values (1);
1 row created.
SQL> insert into x values (5);
1 row created.
SQL> insert into x values (4);
1 row created.
SQL> insert into x values (2);
1 row created.
SQL> select * from x order by y;
Y
———-
1
2
3
4
5
Correct as winner2001 points out is A and D
Great looking website. Think you did a bunch of your ownyour very own html coding
csgo http://nhlcoinstory.inube.com/blog/4989728/csgo-skins-instead-obtain-a-mobile-console/
AD
that is the finish of this article. Here youll discover some sites that we consider you will value, just click the links over
Always a huge fan of linking to bloggers that I like but dont get a lot of link love from.
below you will uncover the link to some web-sites that we consider you should visit
just beneath, are many absolutely not connected web pages to ours, on the other hand, they’re surely really worth going over
Every when in a while we choose blogs that we study. Listed beneath are the most recent web-sites that we opt for.
check below, are some entirely unrelated sites to ours, even so, they are most trustworthy sources that we use
here are some links to web pages that we link to due to the fact we think they are worth visiting
always a massive fan of linking to bloggers that I love but really don’t get a whole lot of link love from
we came across a cool internet site which you might love. Take a look in case you want
that would be the finish of this article. Here you will discover some sites that we consider youll value, just click the hyperlinks over
Wonderful story, reckoned we could combine several unrelated data, nonetheless actually worth taking a appear, whoa did 1 understand about Mid East has got much more problerms at the same time
the time to read or check out the content material or web pages we have linked to below the
Sites of interest we have a link to
It’s going to be end of mine day, however before finish I am reading this wonderful post to increase my experience.|
A and D
SQL> conn sidney/out_standing1
Connected.
SQL> create table dummy (a varchar2(10));
create table dummy (a varchar2(10))
*
ERROR at line 1:
ORA-01031: insufficient privileges
A and D