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