QUESTION: 9

The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.
NAMETYPEVALUE
-------------------------------------------- ------------------- ------------------------------------------------
audit_file_deststring/u01/app/oracle/admin/eml2rep/adump
background_dump_deststring
core_dump_deststring
db_create_file_deststring
db_recovery_file_deststring/u01/app/oracle/fast_recovery_area
diagnostic_deststring
What is the location of the ADR base?

It is set to/u01/app/oracle/product:/12.1.0/db_1/log.
It is set to /u01/app/oracle/admin/enl2r&p/adump.
It is set to /u01/app/oracle.
It is setto /u01/app/oracle/flash_recovery_area.

Answer(s): B

Show Answer Next Question

QUESTION: 10

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.

2, 1, 3, 7, 6, and 8
2, 1, 4, 5, 3, 7, 6, 9, and 8
2, 1, 3, 7, 6, 9, and 8
2, 1, 3, 5, 7, 6, and 8

Answer(s): C

Explanation:

The correct order for the steps to export the PDB hr_pdb1 from the CDB CDB1 and import it into the CDB2 as emp_pdb1 PDB would be:

Create a PDB named emp_pdb1 in CDB2.
Export the hr_pdb1 PDB from CDB1 by using the "expdp" command with the "full=y" option.
Copy the dump file to the Data Pump directory in CDB2.
Create a Data Pump directory in the emp_pdb1 PDB in CDB2.
Import data into emp_pdb1 with the "impdp" command using the "full=y" and "remap_tablespace" options.
Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Open the emp_pdb1 PDB in CDB2.
Mount the emp_pdb1 PDB in CDB2.
Synchronize the emp_pdb1 PDB in restricted mode in CDB2.
Note: Steps 4,7,8 and 9 can be done in any order.

Show Answer Next Question

QUESTION: 11

You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2.Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?

Create both jobs by using Scheduler raised events.
Create both jobs using application raised events.
Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

Answer(s): D

Show Answer Next Question

QUESTION: 12

Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges.
You then execute the commands:
SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQL>CONNsys/oracle@HR_PDB assysdba
SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?

C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
B_admin can create and select any table in both the root container and kr_pdb.
c##admin can create and select any table in the root container and all the PDBs.
B_admin can create and select any table only in hr_pdb.
The grant c=»role1 to b_admin command returns an error because container should be set to ALL.

Answer(s): C

Show Answer Next Question

Free Oracle 1Z0-067 Exam Questions (page: 4)

QUESTION: 9

QUESTION: 10

Explanation:

QUESTION: 11

QUESTION: 12

1Z0-067 Exam Discussions & Posts