Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). 

A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. 

You connect to the CDB and execute the following commands: 

SQL > SHUTDOWN IMMEDIATE SQL > STARTUP MOUNT 

SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 

2. ALTER DATABASE OPEN; 

3. ALTER DATABASE OPEN RESETLOGS; 

Which command or commands should you execute next to allow updates to the flashback back schema?

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). 

The characteristics of the non-CDB are as follows: – Version: Oracle Database 12c Releases 1 64-bit 

– Character set: WE8ISO8859P15 

– National character set: AL16UTF16 

– O/S: Oracle Linux6 64-bit The characteristics of the CDB are as follows: 

– Version: Oracle Database 12c Release 1 64-bit

 – Character set: AL32UTF8 

– O/S: Oracle Linux 6 64-bit 

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. 

You execute the following command: 

SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; 

What is the result?

Which three statements are true about SQL plan directives? (Choose three.)

You want to flash back a test database by five hours. You issue this command: 

SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24); 

Which two statements are true about this flashback scenario? (Choose two.)

Examine these two statements: 

Which three are true about the MRKT tablespace? (Choose three.)

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. 

How would you accomplish this?

You Execute the Following command to create a password file in the database server: 

$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ 

Which two statements are true about the password file? (Choose two.)