Exit 1Z0-082 Oracle DBA Administration I
Question 1 of 5
0% complete
Q1 Multiple choice

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

Select all that apply.

  • 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

Previous Next