1z0-067 Free Practice Test

You execute the commands on a multitenant container database CDB1 that has multiple pluggable databases:
$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The oracle base for ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 is /u01/app/oracle
$ rman target /
Recovery Manager : Release 12.1.0.0.2 - production on Fri Ju1 19 05:18:33: 2013 Coppyright (c) 1982, 2013, oracle and/or its affiliates. All rights reserved. Connected to target database:CDB1 (DBID=782249327)
RMAN>SELECT name FROMv$tablespace;
Which statement is true about the execution of the last command?

1. A. It succeeds and displays all the tablespaces that belong to the root database.
2. B. It fails and returns an error because a connection is not made by using the sysdba privilege.
3. C. It succeeds and displays all the tablespaces that belong to the root and pluggable databases.
4. D. It fails and returns an error because SQL commands cannot be executed at the RMAN promp

Correct Answer: C

Examine the command used to perform an incremental level-0 backup: RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command: SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command: RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;
Which two statements are true in the preceding situation?

1. A. The block change tracking data is used only from the next incremental backup.
2. B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
3. C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
4. D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
5. E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Correct Answer: CE

Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

1. A. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
2. B. In a PDB plan, subplans may be used with up to eight consumer groups.
3. C. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groupsacross all PDBs in the CDB.
4. D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
5. E. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.

Correct Answer: AE
A: Setting a PDB resource plan is optional. If not specified, all sessions within the PDB are treated equally.
In a non-CDB database, workloads within a database are managed with resource plans.
In a PDB, workloads are also managed with resource plans, also called PDB resource plans. The functionality is similar except for the following differences:
Non-CDB Database Multi-level resource plans
Up to 32 consumer groups Subplans
PDB Database
Single-level resource plans only Up to 8 consumer groups
(Not B) No subplans

Which two statements are true about unified auditing?

1. A. A unified audit trail captures audit information from unified audit policies and audit settings.
2. B. Unified auditing is enabled by executing make-fins_rdbms.mk uniaud_onioracle ORACLE_HOME=SORACLE_HOME.
3. C. Audit records are created for all users except sys.
4. D. Audit records are created only for the DML and DDL operations performed on database objects.
5. E. Unified auditing is enabled by setting the audit_trail parameter to db, extended.
6. F. A unified audit trail resides in a read-only table in the audsys schema in the system tablespac

Correct Answer: AB
https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG343 In unified auditing, the unified audit trail captures audit information from a variety of sources. Audit records (including SYS audit records) from unified audit policies and AUDIT settings Fine-grained audit records from the
DBMS_FGA PL/SQL package Oracle Database Real Application Security audit records Oracle Recovery Manager audit records Oracle Database Vault audit records Oracle Label Security audit records Oracle Data Mining records Oracle Data Pump Oracle SQL*Loader Direct Load https://docs.oracle.com/database/121/TDPSG/GUID-BF747771-01D1-4BFB-8489- 08988E1181F6.htm#TDPSG55281 Enable theunified auditing executable. UNIX: Run the following command: make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME https://docs.oracle.com/database/121/DBSEG/auditing.htm#DBSEG1024 The unified audit trail,
which resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace

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?

1. A. The database instance hangs and the redo log files are not overwritten.
2. B. The archived redo log files are written to the fast recovery area until the mandatory destination is made available.
3. C. The database instance is shutdown immediately.
4. D. 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.

Correct Answer: A
Made more logfile switch until all redos groups are full. first log switch succeds, second also succeds then next will hang database.