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