Q58 The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace

Q58 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:

CREATE USER sales
IDENTIFIED BY sales_123
DEFAULT TABLESPACE sales_q1
TEMPORARY TABLESPACE temp
QUOTA 5M ON users;

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 a quota on the TEMP tablespace
(B). 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
(C). The sales user must have been granted the CREATE SESSION privilege
(D). The sales user must have their quota on the users tablespace removed
(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 been granted the CREATE TABLE privilege

Xem thêm: