Question 106

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 ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)
  • Question 107

    Which two statements are true about the rules of precedence for operators? (Choose two.)
  • Question 108

    You execute this command:

    Sufficient storage is available in filesystem /u01.
    Which two statements are true about the BIG_TBS tablespace? (Choose two.)
  • Question 109

    Which three statements are true about inner and outer joins? (Choose three.)
  • Question 110

    Which three statements are true about the Oracle Data Dictionary? (Choose three.)