Question 196
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 197
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job' , FORCED_TRACKING => 'Y');
Which two statements are true?
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job' , FORCED_TRACKING => 'Y');
Which two statements are true?
Question 198
Which three statements are true when the listener handles connection requests to an
Oracle 12c database instance with multithreaded architecture enabled In UNIX?
Oracle 12c database instance with multithreaded architecture enabled In UNIX?
Question 199
Examine the memory-related parameters set in the SPFILE of an Oracle database:

Which statement is true?

Which statement is true?
Question 200
Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)