Free 1Z0-062 Exam Dumps

Question 61

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic Workload Repository (AWR) snapshot is taken every 30 minutes.
Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)

A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
B. It always compares the latest snapshot with the baseline snapshot for analysis.
C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
D. It requires at least four AWR snapshots for analysis.
E. It calls other advisors if required, but does not provide recommendations about the advisors to be use

Correct Answer:AC

Question 62

Which statement is true about using the Database Upgrade Assistant (DBUA) to upgrade your database from Oracle Database 11g to Oracle Database 12c?

A. It terminates if the SYSTEM tablespace in the source database is not autoextensible.
B. It automatically makes necessary changes to Oracle environment variables.
C. It automatically enables unified auditing in the upgraded database.
D. It automatically adds new data files if there is not enough disk space to grow.

Correct Answer:D
References: https://docs.oracle.com/cd/E18283_01/server.112/e17222/upgrade.htm#insertedID5

Question 63

You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.
Which statement is true?

A. The ORACLE_BASE base parameter is not set.
B. The installation is being performed by the root user.
C. The operating system group that is specified should have the root user as its member.
D. The operating system group that is specified must have permission to write to the inventory directory.

Correct Answer:D
Note:
Providing a UNIX Group Name
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.
Only users who belong to this group are able to install or deinstall software on this machine.

Question 64

Identify three benefits of Unified Auditing.

A. Decreased use of storage to store audit trail rows in the database.
B. It improves overall auditing performance.
C. It guarantees zero-loss auditing.
D. The audit trail cannot be easily modified because it is read-only.
E. It automatically audits Recovery Manager (RMAN) events.

Correct Answer:ABE
A: Starting with 12c, Oracle has unified all of the auditing types into one single unit called Unified auditing. You don’t have to turn on or off all of the different auidting types individually and as a matter of fact auditing is enabled by default right out of the box. The AUD$ and FGA$ tables have been replaced with one single audit trail table. All of the audit data is now stored in Secure Files table thus improving the overall management aspects of audit data itself.
B: Further the audit data can also be buffered solving most of the common performance related problems seen on busy environments.
E: Unified Auditing is able to collect audit data for Fine Grained Audit, RMAN, Data Pump, Label Security, Database Vault and Real Application Security operations.
Note:
* Benefits of the Unified Audit Trail
The benefits of a unified audit trail are many:
/ (B) Overall auditing performance is greatly improved. The default mode that unified audit works is Queued Write mode. In this mode, the audit records are batched in SGA queue and is persisted in a periodic way. Because the audit records are written to SGA queue, there is a significant performance improvement.
/ The unified auditing functionality is always enabled and does not depend on the initialization parameters that were used in previous releases
/ (A) The audit records, including records from the SYS audit trail, for all the audited components of your Oracle Database installation are placed in one location and in one format, rather than your having to look in different places to find audit trails in varying formats. This consolidated view enables auditors to co-relate audit information from different components. For example, if an error occurred during an INSERT statement, standard auditing can indicate the error number and the SQL that was executed. Oracle Database Vault-specific information can indicate whether this error happened because of a command rule violation or realm violation. Note that there will be two audit records with a distinct AUDIT_TYPE. With this unification in place, SYS audit records appear with AUDIT_TYPE set to Standard Audit.
/ The management and security of the audit trail is also improved by having it in single audit trail.
/ You can create named audit policies that enable you to audit the supported components listed at the beginning of this section, as well as SYS administrative users. Furthermore, you can build conditions and exclusions into your policies.
* Oracle Database 12c Unified Auditing enables selective and effective auditing inside the Oracle database using policies and conditions. The new policy based syntax simplifies management of auditing within the database and provides the ability to accelerate auditing based on conditions.
* The new architecture unifies the existing audit trails into a single audit trail, enabling simplified management and increasing the security of audit data generated by the database.

Question 65

For which three requirements would you use the Database Resource Manager? (Choose three.)

A. specifying an idle time limit that applies to sessions that are idle and blocking other sessions
B. limiting the degree of parallelism of operations performed by user sessions in a consumer group
C. specifying the maximum number of concurrent sessions allowed for a user
D. limiting the CPU used per database call
E. specifying the amount of private space a session can allocate in the shared pool of the SGA.

Correct Answer:ABC
References:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/dbrm.htm