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?
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?

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.)

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