Exam Code: 1z0-067 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-067 Exam.
2021 Nov 1z0-067 practice exam
Q61. Examine the RMAN commands executed in your database: RMAN>CONFIGUREDEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICETYPE DISK BACKUP TYPE TO BACKUPSET;
RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
You issue the command:
RMAN> BACKUP DATABASE;
Which two statements are true about the command?
A. It performs a log switch.
B. It creates compressed backup sets by using binary compression by default.
C. It backs up only the used blocks in data files.
D. It backs up data files, the control file, and the server parameter file.
E. It creates a backup of only the control file whenever the database undergoes a structural change.
Q62. Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
A. Oracle Data Pump
B. Oracle Recovery Manager (RMAN)
C. Oracle Label Security
D. Oracle Database Vault
E. Oracle Real Application Security
Q63. You issue the command:
SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
Which statement is true about the command?
A. It creates a copy of the control file and stores it in the location specifiedin the diagnostic_dest initialization parameter.
B. It creates a file that contains the SQL statement, which is required to re-create the control file.
C. It updates the alert log file with the location and contents of the control file.
D. It creates a binary backup of the control file.
Q64. Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?
A. The compatible initialization parameter is set to 10.2 or higher.
B. There are no guaranteed restore points defined for the database.
C. The default device for the backup must be set to disk.
D. The tablespaces are locally managed.
E. The fast recovery area is less than 50 percent free.
Reference:http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRAD V89481(See unused block compression)
Q65. 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.
Down to date 1z0-067 test engine:
Q66. Examine the initialization parameter that is set in the PFILE:
You execute the following command to create theCDB1. container database (CDB):
DEFAULTTABLESPACE users DEFAULTTEMPORARY TABLESPACEtemp UNDO TABLESPACEundotbsl
SYSTEMDATAFILESSIZE125M AUTOEXTEND ON NEXT10M MAXSIZEUNLIMITED
Which three statements are true?
A. It creates a multitenant container database with a root and a seed pluggable database (PDB) that are opened in read-write and read-only modes, respectively.
B. The files created for both the root and seed databases use Oracle Managed Files (OMF).
C. It creates a multitenant container database with the root and seed databases opened and one PDB mounted.
D. It sets the users tablespace as the default for both the root and seed databases.
E. undotbs1is used as the undo tablespace for both the root and seed databases.
F. It creates a multitenant container database with the root database opened and the seed database mounted.
Q67. You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1and 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_pdb1PDB by using the full clause.
3.Open the emp_pdb1PDB.
4.Mount the emp_pdb1PDB.
5.Synchronize the emp_pdb1PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1PDB.
8.Import data into emp_pdb1with the full and remap clauses.
9.Create the same tablespaces in emp_pdb1as in hr_pdb1for new local user objects.
Identify the required steps in the correct order.
A. 2, 1, 3, 7, 6, and 8
B. 2, 1, 4, 5, 3, 7, 6, 9, and 8
C. 2, 1, 3, 7, 6, 9, and 8
D. 2, 1, 3, 5, 7, 6, and 8
Q68. In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
A. All the read-only tablespaces should be taken offline.
B. All the read-only tablespaces should be restored separately.
C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
D. All the read-only tablespaces should be made online with logging disabled.
Q69. Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):
SQL> CREATE USER c##a_admin IDENTIFIED BYorcl123;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;
SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;
SQL> REVOKE c##role1 FROM c##a_admin;
What is the result of the revoke command?
A. It executes successfully and the c##role1 role is revoked from the c##a_admin user only in the root container.
B. It fails and reports an error because the container=all clause is not used.
C. It executes successfully and the c##rocl1role is revoked from the c##a_adminuser in the root database and all the PDBs.
D. It fails and reports an error because the comtainer=currentclause is not used.
Q70. user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?
A. Use Data Pump.
B. Use ALTERTABLE. . .MOVE
C. Use CREATE TABLE AS SELECT
D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its
E. Use altertablespace to encrypt the tablespace.