Oracle 1Z0-062 dumps - 100% Pass Guarantee!

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?

A. Only 1

B. Only 2

C. Only 3

D. 3 and 1

E. 1 and 2

The HR user executes the following query on the EMPLOYEES table but does not issue COMMIT, ROLLBACK, or any data definition language (DDL) command after that:

HR then opens a second session.

Which two operations wait when executed in HR's second session? (Choose two.)

A. LOCK TABLE employees IN EXCLUSIVE MODE;

B. INSERT INTO employees(empno,ename) VALUES (1289, `Dick');

C. SELECT job FROM employees WHERE job='CLERK' FOR UPDATE OF empno;

D. SELECT empno,ename FROM employees WHERE job='CLERK';

E. INSERT INTO employees(empno,ename,job) VALUES (2001,'Harry','CLERK);

You want to create a test database as a replica of your production database with minimum intervention from a DBA.

Which method would you use?

A. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

C. Create the database by using the CREATE DATABASE. . . command and manually import data by using Data Pump.

D. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough.

What could be a solution to make streaming happen during the backup?

A. Configure backup optimization

B. Configure the channel to increase MAXOPENFILES

C. Configure the channel to increase the capacity with the RATE parameter

D. Configure the channel to adjust the tape buffer size with the BLKSIZE option

Which four are true about the SHUTDOWN TRANSACTIONAL command and its effects in a single instance Oracle database environment with a single active transaction? (Choose four.)

A. The Oracle server waits for all sessions to disconnect before completing the shutdown.

B. An instance shutdown will occur if the transaction issues a COMMIT.

C. Sessions are unable to begin new transactions.

D. All sessions are terminated when the transaction ends.

E. An instance shutdown will occur if the transaction issues a ROLLBACK.

F. All the active transactions are rolled back and all user sessions are terminated.

G. The next startup requires instance recovery, which occurs automatically.