1z0-067 Free Practice Test

You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task: 1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause. 3.Open the emp_pdb1 PDB.
4. Mount the emp_pdb1 PDB.
5. Synchronize the emp_pdb1 PDB in restricted mode. 6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB. 8.Import data into emp_pdb1 with the full and remap clauses.
9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects. Identify the required steps in the correct order.

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

Correct Answer: C
Because the step 2 says that you perfom an expdp with the full clause and you don’t need to create the tablespaces when you perform the impdp. FULL=yes will export tablespace definitions. So no need step 9. https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm

During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool.
What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)

1. A. Enable AMM and set the SGA_TARGET initialization parameter to a nonzero value.
2. B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE.
3. C. Enable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter to a nonzero value.
4. D. Enable AMM and set the PGA_TARGET initialization parameter to a nonzero valu

Correct Answer: B

Which three statements are true about Scheduler Windows? (Choose three.)

1. A. Only one window can be open at one time.
2. B. Consumer groups are associated with windows.
3. C. Windows work with job classes to control resource allocation.
4. D. A database service name must be provided during window creation.
5. E. The Resource Manager can automatically start windowed jobs or change resource allocation among windowed jobs.

Correct Answer: ACD

You want to create a guaranteed restore point for your database by executing the command: SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.

1. A. The database must be running in archivelog mode.
2. B. Flashback Database must be enabled.
3. C. Fast Recovery Area must be enabled.
4. D. The recyclebin must be enabled for the database.
5. E. Undo retention guarantee must be enabled.
6. F. A database backup must be take

Correct Answer: AC
2018-04-01T22:00:00.63<!--[if gte mso 9]><xml>




</xml><![endif]-->
2018-04-01T22:00:00.63<!--[if gte mso 9]><xml>

Normal
0




false
false
false

RU
JA
X-NONE
























</xml><![endif]-->
2018-04-01T22:00:00.66<!--[if gte mso 9]><xml>





























































UnhideWhenUsed="false" Name="Light Shading Accent 2"/>























UnhideWhenUsed="false" Name="Dark List Accent 3"/>























UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/>























UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/>





</xml><![endif]-->
2018-04-01T22:00:00.67<!--[if gte mso 10]>
<style>
/* Style Definitions */ table.MsoNormalTable
{mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm;
mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan; font-size:11.0pt;
font-family:Calibri;
mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-ansi-language:RU;}
</style>
<![endif]-->
2018-04-01T22:00:00.67<!--StartFragment-->
SQL> select flashback_on from v$database; FLASHBACK_ON
—————— NO
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Restore point created. SQL> archive log list;
Database log mode Archive Mode Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 113
Next log sequence to archive 115
Current log sequence 115 SQL>
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm 2018-04-01T22:00:00.67<!--EndFragment-->

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
$> impdp full=Y network_link=hrdb_test transportable=always transport_datafiles=
‘/u01/app/oracle/oradata/hrdb/sales01.dbf’, ‘/u01/app/oracle/oradata/hrdb/cust01.dbf’, ‘/u01/app/oracle/oradata/hrdb/emp01.dbf’, version=12 logfile=import.log
Which three are prerequisites for successful execution of the command?

1. A. The impdp operation must be performed by the same user that performed the expdp operation.
2. B. The path of data files on the target database must be the same as that on the source database.
3. C. The export dump file must be created before starting the import on the target database.
4. D. All the user defined tablespaces must be in read-only mode on the source database.
5. E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.
6. F. The source and target databases must be running on the same platform with the same endiannes

Correct Answer: ACE