Oracle
1Z0-052 · Question #260
1Z0-052 Question #260: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #260. The question stem and answer options stay visible for context.
Question
You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USER user01 IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1 TEMPORARY TABLESPACE temp PROFILE default / SQL> GRANT create session, create table TO user01; While executing the command to create a table, the user gets the following error message and the CREATE TABLE.. command fails. ERROR at line 1: ORA-01950: no privileges on tablespace What could be the possible reason for this error message?
Options
- AThe tablespace TBS1 is full.
- BThe user is not the owner of the SYSTEM tablespace.
- CThe user does not have quota on the TBS1 tablespace.
- DThe user does not have sufficient system privileges to create table in the TBS1 tablespace.
- EThe user does not have sufficient privileges to create table on the default permanent tablespace.
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.