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 2
• B.1 and 2
• C.Only 1
• D.Only 3
• E.3 and 1

Comment: *

Name: *

Email: *

Verification: *

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 Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.
• B.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.
• C.Create the database by using the CREATE DATAEASE. . .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 and then manually copy the data by using Oracle Data Pump.

Comment: *

Name: *

Email: *

Verification: *

What is a requirement for creating a remote database scheduler job?

• A.The target remote database on which the job is scheduled must be Oracle Database 11g Release 2 or later.
• B.The remote database job must run as a user that is valid on the target remote database.
• C.A private database link must be created from the originating database to the target remote database.
• D.The target remote database must be on a different host form the originating scheduler database host.

Comment: *

Name: *

Email: *

Verification: *

Your database instance has the following parameter setting:
OS_AUTHENT_PREFIX = OPS$
You execute the following command:

And then grant OPS$GUEST_USER the CREATE SESSION privilege.
Which two statements are true? (Choose two.)

• A.GUEST_USER is forced to change the password at the first login.
• B.GUEST_USER can query the tables created in the USERS tablespace by default.
• C.The authentication details for GUEST_USER are stored in the database password file.
• D.GUEST_USER can log on to the database without specifying a username and password.
• E.A local GUEST_USER OS account should exist before GUEST_USER can log on to the database.

Comment: *

Name: *

Email: *

Verification: *

Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

• A.The optimizer used a dynamic plan for the query.
• B.The optimizer chose different plans because automatic dynamic sampling was enabled.
• C.The optimizer used re-optimization cardinality feedback for the query.
• D.The optimizer chose different plan because extended statistics were created for the columns used.

Comment: *

Name: *

Email: *

Verification: *