File Info
| Exam | Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP |
| Number | 1z0-067 |
| File Name | Oracle.1z0-067.PracticeTest.2018-07-04.117q.tqb |
| Size | 1 MB |
| Posted | Jul 04, 2018 |
| Download | Oracle.1z0-067.PracticeTest.2018-07-04.117q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
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:
- Create a PDB named emp_pdb1.
- Export the hr_pdb1 PDB by using the full clause.
- Open the emp_pdb1 PDB.
- Mount the emp_pdb1 PDB.
- Synchronize the emp_pdb1 PDB in restricted mode.
- Copy the dump file to the Data Pump directory.
- Create a Data Pump directory in the emp_pdb1 PDB.
- Import data into emp_pdb1 with the full and remap clauses.
- 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
Correct answer: C
Explanation:
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 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
Question 2
You wish to create jobs to satisfy these requirements:
- Automatically bulk load data from a flat file.
- 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.
Correct answer: C
Explanation:
The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA Your application can raise an event to notify the Scheduler to start a job. A job started in this way is referred to as an event-based job. The job can optionally retrieve the message content of the event. https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse008.htm#CHDIAJEB The bulk loader would be started in response to a file watcher scheduler event and the indexes would be rebuilt in response to an application event raised by the bulk loader. https://docs.oracle.com/cd/E18283_01/server.112/e17120/scheduse005.htm#CIABIEJA Your application can raise an event to notify the Scheduler to start a job. A job started in this way is referred to as an event-based job. The job can optionally retrieve the message content of the event. https://docs.oracle.com/cd/B28359_01/server.111/b28310/scheduse008.htm#CHDIAJEB
Question 3
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.
Correct answer: CD
