1z0-067 Free Practice Test

Your database supports an OLTP workload. Examine the output of the query:
SQL> SELECT target_mttr, estimated_mttr FROM v$instance_recovery
Target_mttr estimated_mttr
---------------------- --------------------------- 0 76
To ensure faster instance recovery, you set the fast_start_mttr_target initialization parameter to 30. What is the effect of this setting on the database?

1. A. Automatic checkpoint tuning is disabled.
2. B. The frequency of log switches is increased.
3. C. The overhead on database performance is increased because of frequent writes to disk.
4. D. The MTTR advisor is disable

Correct Answer: C
Reference: http://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

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.

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

Correct Answer: B
1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges’ lists.
4. Revoke the unused privileges.

Examine the RMAN commands executed in your database: RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN>CONFIGURE DEVICE TYPE 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?

1. A. It performs a log switch.
2. B. It creates compressed backup sets by using binary compression by default.
3. C. It backs up only the used blocks in data files.
4. D. It backs up data files, the control file, and the server parameter file.
5. E. It creates a backup of only the control file whenever the database undergoes a structural chang

Correct Answer: CD
C: RMAN backup sets automatically use unused block compression. http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta007.htm#i1015382
D: If CONFIGURE CONTROLFILE AUTOBACKUP is ON (by default it is OFF), then RMAN automatically backs up the control file and server parameter file after every backup and after database structural
changes. http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup003.htm#i1009642 Not E: spfile is also backed up.

Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

1. A. A DBA can check specific tables with the DMU
2. B. The database to be migrated must be opened read-only.
3. C. The release of the database to be converted can be any release since 9.2.0.8.
4. D. The DMU can report columns that are too long in the converted characterset
5. E. The DMU can report columns that are not represented in the converted characterset

Correct Answer: ADE
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion. E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.

You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?

1. A. RMAN recovery catalog
2. B. RMAN Media Management Library
3. C. Enterprise Manager Cloud Control
4. D. Enterprise Manager Database Express
5. E. Oracle Secure Backup

Correct Answer: AC
2018-04-01T22:00:00.56<!--[if gte mso 9]><xml>




</xml><![endif]-->
2018-04-01T22:00:00.57<!--[if gte mso 9]><xml>

Normal
0




false
false
false

RU
JA
X-NONE
























</xml><![endif]-->
2018-04-01T22:00:00.60<!--[if gte mso 9]><xml>
LatentStyleCount="276">

































UnhideWhenUsed="false" Name="Medium List 1"/>
























UnhideWhenUsed="false" Name="Colorful List Accent 1"/>























UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/>























UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/>























UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/>







</xml><![endif]-->
2018-04-01T22:00:00.60<!--[if gte mso 10]>
<style>
/* Style Definitions */ table.MsoNormalTable
{mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin-top:0cm;
mso-para-margin-right:0cm; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0cm;
line-height:115%;
mso-pagination:widow-orphan; font-size:11.0pt;
font-family:Calibri;
mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-ansi-language:RU;}
</style>
<![endif]-->
2018-04-01T22:00:00.60<!--StartFragment-->
Enterprise Manager allows a centralized control of database backups. It is possible to set up and schedule RMAN backups for all the databases in a large company, use a consistent backup strategy, and refer to all past RMAN output logs at any time, since they are stored in the Enterprise Manager Cloud Control repository. There is no need to use a central RMAN catalog, because information about the backups is centrally available from Enterprise Manager. And with the group backup feature new to Enterprise Manager Cloud Control 12c, it can be even faster to set up RMAN backups for all the databases-even if there are thousands-that are part of an Enterprise Manager group.
http://www.oracle.com/technetwork/articles/oem/havewala-rman-em12c-2104270.html 2018-04-01T22:00:00.60<!--EndFragment-->