Oracle
1Z0-082 · Question #28
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred. You execute this command: Which three statements must be true…
The correct answer is B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all D. The sales user must have their quota on the users tablespace removed F. The sales user must have been granted the CREATE TABLE privilege. See the full explanation below for the reasoning.
Administer User Security
Question
The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace. Segment creation is not deferred. You execute this command:
Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)
Exhibit
Options
- AThe sales user must have a quota on the TEMP tablespace
- BThe sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all
- CThe sales user must have been granted the CREATE SESSION privilege
- DThe sales user must have their quota on the users tablespace removed
- EThe sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be
- FThe sales user must have been granted the CREATE TABLE privilege
How the community answered
(26 responses)- A4% (1)
- B81% (21)
- C4% (1)
- E12% (3)
Topics
#user quotas#tablespace quota#CREATE TABLE privilege#CREATE SESSION privilege
Community Discussion
No community discussion yet for this question.