Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

QUESTION NO: 1
Which three RMAN persistent settings can be set for a database?

A. default section size for backups B. multiple backup device types for a single backup C. backup retention policy D. default destinations for backups E. default backup device type

Correct Answer: C,D,E

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 2
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1.Place all user-defined tablespaces in read-only mode on the source database.
2.Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3.Perform a full transportable export on the source database with the parameters VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6. Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7. Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

A. 2, 4, 5, 6, and 7 B. 1, 2,4, and 7 C. 1, 3, 5, 4, 2, and 7 D. 1, 2, 4, 6, 5, 3, and 7

Correct Answer: C

QUESTION NO: 3
You install Oracle Grid Infrastructure for a standalone server and issue this command:
crsctl start has
Which two components get automatically added to the Oracle Restart configuration the first time this command is issued?
Choose two.

A. Oracle Healthcheck services B. Oracle CSSD services C. An Oracle Net Listener that already exists prior to the Grid Infrastructure installation D. Oracle Notification services E. A database that already exists prior to the Grid Infrastructure installation

Correct Answer: A,B

QUESTION NO: 4
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

A. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs B. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system C. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

Correct Answer: A

QUESTION NO: 5
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance?

A. Always use synchronous I/O for the database. B. Always use RMAN compression for tape backups rather than the compression provided by media manager. C. Remove the rate parameter, if specified, in the allocate channel command. D. Set the backup_tape_io_slaves parameter to true. E. Configure large pool if not already done. F. Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

Correct Answer: C,E,F

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 6
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

A. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB. B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB. C. Use the DBMS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB. D. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB. E. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

Correct Answer: A,E

QUESTION NO: 7
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?

A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter. B. It creates a binary backup of the control file. C. It updates the alert log file with the location and contents of the control file. D. It creates a file that contains the SQL statement, which is required to re-create the control file.

Correct Answer: D

Explanation: Only visible for Pass4Test members. You can sign-up / login (it's free).

QUESTION NO: 8
Which two statements are true about service creation for pluggable databases (PDBs)?

A. The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created. B. Only a common user can create additional services for a PDB. C. When a PDB is created, a service with the same name as the PDB is created in the PDB. D. A database managed by Oracle Restart can have additional services created or existing services modified by using the srvctl utility for each PDB. E. When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

Correct Answer: D,E

QUESTION NO: 9
Examine the RMAN commands:
RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";
RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE
PASSWORD FILE
SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?

A. It succeeds and creates multisection backup sets that are used for active database duplication B. It succeeds only if the target database is in MOUNT state C. It fails because there is no connection to a recovery catalog D. It fails because no parallel channels are allocated for the auxiliary database

Correct Answer: A

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z1-067 Exam Questions