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.)
  • 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?
  • 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?
  • Question 199

    Examine the memory-related parameters set in the SPFILE of an Oracle database:

    Which statement is true?
  • Question 200

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