Q1. Your database is running in archivelog mode. You are taking a backup of your database by using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the control files are lost. 

Examine the steps to recover the database: 

1.Restore the control filesby using the RMAN restore controlfile command. 

2.Mount the database. 

3.Restore the data files by using the RMAN restore database command. 

4.Open the database with the resetlogs option. 

5.Recover the data files by using the RMAN recover using backup controlfile command. 

6. 

Start the database instance in nomount state. 

7. 

Connect to the target database by using a recovery catalog. 

8.Open the database. 

9.Restore the data file. 

10.Recover the data file. 

Identify the required steps in the correct order. 

A. 7,6, 1, 2, 3, 5, 4 

B. 7, 2, 1, 3, 5, 8 

C. 7, 6, 1, 2, 9, 10, 8 

D. 7, 6, 1, 2, 9, 10, 4 

View Answer

Q2. What can be automatically implemented after the SQL Tuning Advisoris run as part of the Automated Maintenance Task? 

A. statistics recommendations 

B. SQL profile recommendations 

C. SQL statement restructure recommendations 

D. creation of materialized views to improve query performance 

View Answer

Q3. Which two statements are true about service creation for pluggable databases (PDBs)? 

A. When a PDB is created, a service is automatically started in the instance with the same name as the PDB. 

B. The defaultservice that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created. 

C. A database managed by Oracle Restart can have additional services created or existing services modified by usingthe srvctl utility for each PDB. 

D. Only a common user can create additional services for a PDB. 

E. When a PDB is created, a service with the same name as the PDB is created in the PDB. 

View Answer

Q4. You must unload data from the orders, order_items, and products database tables to four filesusing the External Tables. 

CREATE TABLE orders_ext 

(order_id, order_date, product_id, product_name,quantity) 

ORGANIZATION EXTERNAL ( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY ext.dir LOCATION (‘ordersl.dmp','orders2.dmp’,’orders3.dmp’,’lorders4.dmp') ) PARALLEL AS SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity FROM orders o,productsp,order_itemsi WHERE o.orderjd = i.order_id and i.product_id = p.product_id; 

You execute the command shown in the Exhibit, but only two files are created. Which parameter must be changed so that four files are created? 

A. TYPE 

B. LOCATION 

C. PARALLEL 

D. DEFAULT DIRECTORY 

E. ORGANIZATION EXTERNAL 

View Answer

Q5. Examine the command to duplicate a database: 

RMAN> DUPLICATE TARGET DATABASE TO cdb 

PLUGGABLE DATABASE pdb1, pdb5; 

Which two statements are true about the DUPLICATE command? 

A. The SPFILE is copied along with the datafiles of the pluggable databases (PDBs). The root and the seed database in the container database (CDB) are also duplicated. 

B. A backup of pdbi and pd35 must exist before executing the command. 

C. The duplicate command first creates a backup, and then duplicates the PDBs by using the 

D. backup. 

E. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. 

View Answer

Q6. When is the UNDO_RETENTION parameter value ignored by a transaction? 

A. when the data file of the undo tablespace is autoextensible 

B. when there are multiple undotablespaces available in a database 

C. when the undo tablespace is of a fixed size and retention guarantee is not enabled 

D. when Flashback Database is enabled 

View Answer

Q7. Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): 

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; 

SQL> CREATE ROLE c##role1 CONTAINER=ALL; 

SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL; 

SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; 

SQL> REVOKE c##role1 FROM c##a_admin; 

What is the result of the revoke command? 

A. It executes successfully and the c##role1role is revoked from the c##a_admin user only in the root container. 

B. It fails and reports an error because the container=all clause is not used. 

C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database andall the PDBs. 

D. It fails and reports an error because the comtainer=current clause is not used. 

View Answer

Q8. You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases: 

$ . oraenv ORACLE-_SID = [oracle] ? cdb1 The oraclebasefor ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is 

/u01/app/oracle $ rman target / Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 

Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. 

Connected to target database:CDB1 (DBID=782249327) 

RMAN>SELECT name FROMv$tablespace; 

Which statement is true about the execution of the last command? 

A. It succeeds and displays all the tablespaces that belong to the root database. 

B. It fails and returns an error because a connection is not made by using the sysdba privilege. 

C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases. 

D. It fails and returns an error because SQL commands cannot be executed at the RMAN prompt. 

View Answer

Q9. You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB). 

The following are the possible steps to accomplish this task: 

1. 

Place all the user-defined tablespace in read-only mode on the source database. 

2. 

Upgrade the source database to a 12c version. 

3. 

Create a new PDB in the target container database. 

4. 

Perform a full transportable export on the source database withthe VERSION parameter set to 12 using the expdp utility. 

5. 

Copy the associated data files and export the dump file to the desired location in the target database. 

6. 

Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options. 

7. 

Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function. 

Identify the correct order of the required steps. 

A. 2, 1, 3, 4, 5, 6 

B. 1, 3, 4, 5, 6, 7 

C. 1, 4, 3, 5, 6, 7 

D. 2, 1, 3, 4, 5, 6, 7 

E. 1, 5, 6, 4, 3, 2 

View Answer

Q10. Examine the RMAN command: 

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; 

RMAN> BACKUP DATABASE PLUS ARCHIVELOG; 

Which prerequisitemust be met before accomplishing the backup? 

A. The password for the encryption must be set up. 

B. Oracle wallet for the encryption must be set up. 

C. All the tablespaces in the database must be encrypted. 

D. Oracle Database Vault must be enabled. 

View Answer