Question 61

You execute this command:

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

    Which two statements are true about the WHERE and HAVING clauses in a SELECT statement?
    (Choose two.)
  • Question 63

    You execute this query:
    SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?
  • Question 64

    You want to use table compression suitable for OLTP that will:
    * Compress rows for all DML statements on that table
    * Minimize the overheads associated with compression
    Which compression option is best suited for this?
  • Question 65

    In your data center, Oracle Managed Files (OMF) is used for all databases.
    All tablespaces are smallfile tablespaces.
    SALES_Q1 is a permanent user-defined tablespace in the SALES database.
    Examine this command which is about to be issued by a DBA logged in to the SALES database:
    ALTER TABLESPACE sales_q1 ADD DATAFILE;
    Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)