Question 101

Which two functions are performed by a listener?
  • Question 102

    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 103

    Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
  • Question 104

    You execute this command:

    During the export operation, you detach from the job by using CTRL+C and then execute this command:
    Export> STOP_JOB=immediate
    Are you sure you wish to stop the job ([yes]/no): yes
    Which two statements are true about the job? (Choose two.)
  • Question 105

    Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)