Q131 The ORCL database has RESUMABLE_TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA. U1 executes this command:
SQL> CREATE TABLE t1 AS (SELECT object_name, sharing, created FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17 statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended due to ORA01536: space quota exceeded for tablespace ‘DATA’ Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
- (A). Add a data file to DATA
- (B). Drop other U1 objects in DATA
- (C). Increase U1’s quota sufficiently in DATA
- (D). Set DEFERRED_SEGMENT_CREATION to TRUE
- (E). Grant UNLIMITED TABLESPACE to U1
- (F). Set AUTOEXTEND ON for data files in DATA
Answer: B,C,E