Exam 1z0-062 topic 1 question 194 discussion

Actual exam question from Oracle's 1z0-062

Question #: 194
Topic #: 1

In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
E. The MYTAB table is owned by the SYS user.

Show Suggested Answer

Suggested Answer: BE 🗳️

by taiyang at March 23, 2020, 5:48 a.m.

Comments

Submit Cancel

Ray_gk

3 years, 1 month ago

A&E are correct. As mentioned in previous comments, since user02 is connecting with sysdba admin privilege the current user connected will be SYS and not user02. SYS user owns the system tablespace so the MYTAB table will be created in the SYSTEM tablespace. Now, to test whether user02 can insert into the table, you have to connect without SYSDBA admin privilege (i.e conn user02/us123) Since user02 was not granted the insert object privilege on the MYTAB table owned by sys, the user user02 cannot insert rows into the table. Some people are most likely confirming B because they are attempting the insert without switching from the SYS user to USER02.

upvoted 3 times

Ray_gk

3 years, 1 month ago

I would also add that it is not advisable to grant users privileges on objects in the system tablespace. Also, it is not advisable to create objects in the system tablespace as well.

upvoted 2 times

...

Ray520

2 years, 10 months ago

SYSDBA role once granted comes with its own set of privileges which include creating table. Hence A is wrong. Answer is B and E

upvoted 1 times

...

jobao

4 years, 4 months ago

A.E is correct

upvoted 3 times

...

DANG257315

4 years, 5 months ago

right answer B,E

upvoted 3 times

...

taiyang

5 years, 2 months ago

I think A when as sysdba show user = sys

upvoted 2 times

hggz

5 years, 2 months ago

B&E – Confirmed: SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users; User created. SQL> GRANT create session, sysdba TO user02; Grant succeeded. SQL> CONN user02/us123 AS SYSDBA Connected. SQL> CREATE TABLE mytab (id number, lname varchar2(20)); Table created. SQL> insert into mytab values (1,’xxx’); 1 row created. SQL> select owner,tablespace_name,table_name from all_tables where table_name=’MYTAB’; OWNER TABLESPACE_NAME TABLE_NAME —– ————— ———- SYS SYSTEM MYTAB

upvoted 17 times

Got

4 years, 1 month ago

A&E It can insert because user is SYS , if use CONN user02/us123 AS SYSDBA , I try use show user values USER is "SYS" , if use CONN user02/us123 , show user values USER is "USER02" I can't insert.

upvoted 2 times

badguy001djh

4 years, 1 month ago

When you connect with an administrative privilege, you connect with a current schema that is not generally associated with your username. For SYSDBA, the current schema is SYS.Also, when you connect with an administrative privilege, you connect with a specific session user. When you connect as SYSDBA, the session user is SYS. ref: https://docs.oracle.com/database/121/ADMIN/dba.htm#ADMIN11048

upvoted 2 times

...