ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

164 / 190

Question 164:

In your database, USERS is the default permanent tablespace. Examine the commands and their outcome: 
image
You plan to execute the commands: 
image
Which two statements are true? (Choose two.) 

Answer options:

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.