1Z0-082 Exam Dumps | The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

Next Question >>

Question 1/41

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.)

A. The sales user must have been granted the CREATE TABLE privilege

B. The sales user must have their quota on the users tablespace removed

C. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

D. The sales user must have been granted the CREATE SESSION privilege

E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

F. The sales user must have a quota on the TEMP tablespace

Recent Comments (The most recent comments are at the top.)

Geri G - Jun 21, 2022

A,C,D
The right answers are:
A -> User needs to have the right privilege to create the object.
C-> The user need quota in the tablespace he wants to create the object (sales_q1).
D-> User needs to be able to create a session or a login in to the database to create objects in the first place.

why B? Having quota in another tablespace isn't any issue so we don't need to remove the quota from tablespace users to be able to create objects in tablespace sales_q1!

jose - Nov 01, 2021

A,C,D

Question 1/41

Recent Comments (The most recent comments are at the top.)

LEAVE A REPLY

Download PDF File