1Z0-060 Exam Question 56

On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statement are correct?
  • 1Z0-060 Exam Question 57

    A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

    There is enough free space in the disk group for mirroring to be done.
    What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?
  • 1Z0-060 Exam Question 58

    What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?
  • 1Z0-060 Exam Question 59

    Which three functions are performed by the SQL Tuning Advisor?
  • 1Z0-060 Exam Question 60

    Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

    Which three are prerequisites for successful execution of the command? (Choose three.)