Question 26

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

    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 28

    Which compression method is recommended for Direct-Path Insert operations?
  • Question 29

    Examine the description of the EMPLOYEES table:

    Which query is valid?
  • Question 30

    Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)