Free 1Z0-062 Exam Dumps

Question 76

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

Correct Answer:D

Question 77

Your database is open in read/write mode and multiple users are connected to the database instance. You execute the following command:
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; What would be the effect on current sessions?

A. They are not terminated but may only issue queries.
B. They are not affected.
C. They are terminated immediately.
D. They are terminated after completing the transactio

Correct Answer:B

Question 78

You created a new database using the "create database" statement without specifying the "ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

A. The database is created as a non-CDB and can never contain a PDB.
B. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
C. The database is created as a non-CDB and can never be plugged into a CDB.
D. The database is created as a non-CDB but can be plugged into an existing CDB.
E. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

Correct Answer:AD
A (not B,not E): The CREATE DATABASE ... ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non- CDB and can never contain PDBs.
D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:
1Z0-062 dumps exhibit
Incorrect:
Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.

Question 79

You plan to upgrade your Oracle Database 9i to Oracle Database 12c. Which two methods can you use? (Choose two.)

A. Perform a rolling upgrade.
B. Perform a direct upgrade by running the Database Upgrade Assistant (DBUA).
C. Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.
D. Install the Oracle Database 12c software, create a new Oracle 12c database, and then use the Oracle Data Pump to import data from the source Oracle 9i database to the target Oracle 12c database.
E. Upgrade your current database to Oracle Database release 10.2.0.5, and then upgrade to Oracle Database 12c.

Correct Answer:AE

Question 80

You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?

A. Memory Advisor for the PGA
B. SQL Access Advisor
C. Memory Advisor for the shared pool
D. SQL Tuning Advisor

Correct Answer:C
References: http://docs.oracle.com/cd/E25178_01/server.1111/e10897/montune.htm#CHDGFCFJ