Question 66

You execute this command:

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

    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-03-06T12: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 to resume the session? (Choose three.)
  • Question 68

    Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
    Only the EMPLOYEE_ID column is indexed.
    Rows exist for employees 100 and 200.
    Examine this statement:

    Which two statements are true? (Choose two.)
  • Question 69

    Which three statements are true about a self join? (Choose three.)
  • Question 70

    The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER.
    Which two queries execute successfully? (Choose two.)