Question 211

What is the effect of setting the STATISTICS_LEVEL initialization parameter to BASIC?
  • Question 212

    On your Oracle Database, you issue the following commands to create indexes:
    SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true? (Choose two.)
  • Question 213

    Which three statements are true about Oracle Restart? (Choose three.)
  • Question 214

    Which three statements are true about Oracle Data Pump?
  • Question 215

    Which statement is true about the Log Writer process?