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 statements are correct? (Choose two.)

Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3. 

Which two RMAN commands may be; used to back up only the PDB1 pluggable database? (Choose two.)

Identify three benefits of Unified Auditing. (Choose three.)

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. 

Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. 

At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. 

The ETL jobs perform certain database operations using two or more concurrent sessions. 

After the upgrade, you notice that the performance of ETL jobs has degraded. 

To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs. 

How do you accomplish this?

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and ACCOUNTS_PDB, both of which use the CDB tablespace. 

The temp file is called temp01.tmp. 

A user issues a query on a table on one of the PDBs and receives the following error: ERROR at line 1: ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’ ORA-27037: unable to obtain file status 

Identify two ways to rectify the error. (Choose two.)

Examine the following commands for redefining a table with Virtual Private Database (VPD) policies: 

Which two statements are true about redefining the table? (Choose two.)

Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column? (Choose two.)

You are administering a database stored in Automatic Storage Management (ASM). 

You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. 

You lost an ASM disk group DG1 due to hardware failure. 

In which three ways can you re-create the lost disk group and restore the data? (Choose three.)