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 with the 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
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup?
A. Configure backup optimization.
B. Configure the channel to increase maxopenfiles.
C. Configure a backup policy by using incremental backups.
D. Configure the channel to increase capacity with the rate parameter.
E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
F. Configure large_pool, if not done already. Alternatively, you can increase the size of
G. LARGE_POOL.
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST; Which task is performed by these commands?
A. Corrupted blocks, if any, are repaired in the backup created.
B. Only those data files that have corrupted blocks are backed up.
C. Corrupted blocks in the data files are checked and repaired before performing the database backup.
D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?
A. The PDB is closed.
B. The PDB is placed in mount state.
C. The command executes only if the common user is granted the set container privilege for the PDB.
D. The command results in an error because the PDB can be shut down only by a local user.
Which three statements are true about the SQL*Loader utility?
A. It can be used to load data from multiple external files into multiple tables.
B. It can be used to extract and reorganize data from external files, and then load it into a table.
C. It can be used to load data from external files using direct path only.
D. It can be used to create tables using data that is stored in external files.
E. It can be used to generate unique sequential values in specified columns while loading data.
Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?
A. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
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. 1, 3, 5, 4, 2, and 7
B. 1, 2, 4, 6, 5, 3, and 7
C. 1, 2,4, and 7
D. 2, 4, 5, 6, and 7
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2. RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?
A. It fails because archive log files cannot be backed up using a connection to a PDB.
B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed up.
C. It succeeds and all data files belonging to PD2_i are backed up along with the archive log files.
D. It fails because the pluggable clause is missing.
View the Exhibit showing steps to create a database resource manager plan.
SQL>executedbms_resource_manager.create_pendingarea();
PL/SQLproceduresuccessfully completed.
3QL>execdbms_resource_manager,create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQLproceduresuccessfullycompleted.
SQL>execdbras_resource_raanager.create_plan(plan=>'PRIU3ER3',comment=>'dssprio');
SQL>exec
Dbms_resource_manager.create_plan_directive
(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comraent=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?
A. The pending area is automatically submitted when creating plan directives.
B. The procedure must be executed before creating any plan directive.
C. The sys_group group is not included in the resource plan.
D. The other_groups group is not included in the resource plan.
E. Pending areas can not be validated until submitted.
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2` How should the D3_flash_cache_size be configured to use both devices?
A. Set DB_FLASH_CACHE_SIZE=64G.
B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
C. Set D3_FLASK_CACKE_SI2E=i28G.
D. db_flash_cache_SI2E is automatically configured by the instance at startup.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-067 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.