1z0-067 by Oracle Valid Free Exam Practice Test

Question 1

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.
NAME TYPE VALUE
-------------------------------------------- ------------------- ------------------------------------------------ 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?

A. It is set to /u01/app/oracle. B. It is set to /u01/app/oracle/admin/en12.1.0/adump. C. It is set to /u01/app/oracle/flash_recovery_area. D. It is set to/u01/app/oracle/product:/12.1.0/db_1/log.

Correct Answer: A

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 2

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:
RMAN> DUPLICATE TARGET DATABASE TO cdbdup
PLUGGABLE DATABASE sales
FROM ACTIVE DATABASE
PASSWORD FILE
SPFILE
NOFILENAMECHECK;
Which two statements are true? (Choose two.)

A. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. B. Only the SALES PDB is duplicated as the non-CDB CDBDUP. C. The root and seed databases are included in the duplication. D. A backup of the SALES PDB must exist before the execution of the command. E. RMAN must be connected to a recovery catalog for the execution of the command.

Correct Answer: A,C

Question 3

Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
SQL> SELECT name, active_sessions, queue_length,
consumed_cpu_time, cpu_waits, cpu_wait_time
FROM v$rsrc_consumer_group;

Which two statements are true?

A. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management. B. An attempt to start a new session by a user belonging to DSS_QUERIES fails with an error. C. A user belonging to the DSS__QUERIES resource consumer group can create a new session but the session will be queued. D. An attempt to start a new session by a user belonging to OTHE_GROUPS fails with an error. E. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to I/O waits and latch or enqueue contention.

Correct Answer: A,C

Question 4

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 and left in the mount state. B. The PDB is closed and left in the unmount state. C. The command results in an error because the PDB can be shut down only by a local user. D. The command executes only if the common user is granted the set container privilege for the PDB.

Correct Answer: A

Question 5

Examine the commands executed in CDB$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##admin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

A. The command fails and gives an error because object privileges cannot be granted to a common user. B. The command succeeds and the common user c##admin can create a session and query the DBA_users view in CDB$ROOT and all the PDBs. C. The command succeeds and the common user c##admin can create a session and query the DBA users view only in CDB$ROOT D. The command fails because container is not set to current. E. The command succeeds and the common user c##admin can create a session in CDB$ROOT and all the PDBs, but can only query the dba_users view in CDB$ROOT

Correct Answer: B

Question 6

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

A. All PDBs must be shut down before shutting down a CDB instance. B. A PDB opened in restricted mode allows only local users to connect. C. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command. D. When a CDB is in mount state, PDBs are automatically placed in mount state. E. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

Correct Answer: C,D,E

Question 7

Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

A. 1, 3, 5, 6, 2, 4 B. 1, 3, 6, 2, 5, 4 C. 1, 3, 2, 5, 6, 4 D. 1, 3, 5, 2, 6, 4

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

Which three statements are true about compression of backup sets?

A. Unused blocks below the high-water mark are not backed up. B. Binary compression creates performance overhead during a backup operation. C. Compressed backups cannot have section size defined during a backup operation D. Compressed backups can only be written to media. E. It works only for locally managed tablespaces.

Correct Answer: A,B,E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 9

Which statement is true regarding the creation of nested plans using the Oracle Resource Manager?

A. Nested plans only control resources used by recursive SQL B. The plans can be nested up to four levels. C. Each nested plan gets a proportion of the CPU resources assigned to its parent group. D. Nested plans control only the degree of parallelism and I/O requests E. Only one nested subplan is allowed per parent plan

Correct Answer: C

Question 10

Examine the command to duplicate a database:
RMAN> DUPLICATE TARGET DATABASE TO cdb
PLUGGABLE DATABASE pdb1, pdb5;
Which two statements are true about the DUPLICATE command?

A. The duplicate command first creates a backup, and then duplicates the PDBs by using the backup. B. A backup of pdb1 and pd5 must exist before executing the command. C. The root and the seed database in the container database (CDB) are also duplicated. D. An auxiliary instance must be started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE. E. The SPFILE is copied along with the data files of the pluggable databases (PDBs).

Correct Answer: C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 11

Your database is running in archivelog mode. Examine the parameters for your database instance:
LOG_ARCHIVE_DEST_l ='LOCATION=/disk1/arch MANDATORY'
LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch'
LOG_ARCHIVE_DEST_3 ='LOCATIO=/disk3/arch'
LOG_ARCHIVE_DEST _4 ='LOCATIONs/disk4/arch'
LOG_ARCHIVE _MIN_SUCCEED_DEST = 2
While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.
What happens at the next log switch?

A. The database instance is shutdown immediately. B. The destination set by the log_archive_dest parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success. C. The database instance hangs and the redo log files are not overwritten. D. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.

Correct Answer: C

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z0-067 Exam Practice Test