The ORCL database has RESUMABTE TIMEOUT =7200 and DEFERRED SEGMENT
CREATION -FALSE
User U1 has a 1 MB quota in tablespace DATA.
Ul executes this command
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created FROM dba_objects);
Ul complains that the command is taking too long to execute In the alert log, the database administrator (DBA ) finds this
2017-03-06912:15:17.183438+05:30
Statement in resumable session 'User U1(136), session 1, Instance 1 ' was suspended due
To ORA-01536: space quota exceeded for tablespace 'DATA'
Which are three actions any one of which the DBA could take take to resume the session?
A.Set AUTOEXTEND ON for data files in DAMA B.Set DEFERRED SEGMENT CREATION to TRUE C.Increase Ul's quota sufficiently in DATA D.Grant UNLIMIRED TABLESPACE to U1 E.Drop other U1 objects in DAT2 F.Add a data file to DATA正确答案CDE
