Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
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.
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.
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.
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
...
...
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Ray_gk
2 years agoRay_gk
2 years agoRay520
1 year, 8 months agojobao
3 years, 2 months agoDANG257315
3 years, 3 months agotaiyang
4 years agohggz
4 years agoGot
3 years agobadguy001djh
3 years ago