Download Upgrade Oracle9i-10g-11g OCA OR OCP to Oracle Database 12c OCP.1z0-067.CertDumps.2017-09-25.176q.vcex
| Vendor: | Oracle |
| Exam Code: | 1z0-067 |
| Exam Name: | Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP |
| Date: | Sep 25, 2017 |
| File Size: | 657 KB |
How to open VCEX files?
Files with VCEX extension can be opened by ProfExam Simulator.
Discount: 20%
Demo Questions
Question 1
Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL>CREATE USER c##adnin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?
- The command fails and gives an error because object privileges cannot be granted to a common user.
- The command fails because container is not set to current.
- The command succeeds and the common user cmadnxn can create a session and query the D3A_users view in cdbssoo? and all the PDBs.
- The command succeeds and the common user ct (admin can create a session in cdbSroot and all thePDBs, but can only query the dba_users view in ct3S?cdt.
- The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi.
Correct answer: C
Question 2
You create a default Flashback Data Archive FLA1and enable it for the EMPLOYEES table in the HR schema.
After a few days, you want to alter the EMPLOYEES table by executing the command:
SQL> ALTER TABLE EMPLOYEES ADD PHONE NUMBER(12);
Which statement is true about the execution of the command?
- It gives an error because DDL statements cannot be executed on a table that is enabled for Flashback DataArchive.
- It executes successfully and all metadata related to the EMPLOYEES table before altering the table definition is purged from Flashback Data Archive.
- It executes successfully and continues to store metadata related to the EMPLOYEES table.
- It executes successfully but Flashback Data Archive is disabled for the EMPLOYEES table.
Correct answer: C
Question 3
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?
- It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
- It creates a file that contains the SQL statement, which is required to re-create the control file.
- It updates the alert log file with the location and contents of the control file.
- It creates a binary backup of the control file.
Correct answer: B
Question 4
The CATDBI2c database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RCII user.
A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
Srman
RMAN> CONNECT CATALOG rc12c/pass12c8catdbI2c
RMAN> IMPOST CATALOG rc1l/pwdcatl19catdbl1 DBID=I423241;
What is the outcome of the import?
- It fails because the target database and recovery catalog database are of different versions.
- It succeeds and all global scripts in the sc:: catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.
- It succeeds but the database is not automatically registered in the Rc12c catalog.
- It fails because RMAN is not connected to the target database with DBID=1423241.
Correct answer: B
Question 5
The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user.
The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user.
A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open.
In the CATD3i2c database, you execute the commands:
: r-ar.
RKAN> CONNECT CATALOG rci2c/ [email protected]
RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i;
What is the outcome of the import?
- It fails because the target database and recovery catalog database are of different versions.
- It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.
- It succeeds but the database is not automatically registered in the rc:2c catalog.
- It fails because RMAN is not connected to the target database with r3:T=:42324:.
Correct answer: B
HOW TO OPEN VCE FILES
Use VCE Exam Simulator to open VCE files
HOW TO OPEN VCEX AND EXAM FILES
Use ProfExam Simulator to open VCEX and EXAM files
ProfExam at a 20% markdown
You have the opportunity to purchase ProfExam at a 20% reduced price
Get Now!