Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY tab1e_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin, oe_admin;
Which statement is true?
A. It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN and OE_ADMIN role.
B. It fails because system privileges cannot be granted with roles in the same audit policy.
C. It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.
D. It fails because the command does not specify when the unified audit policy should be enforced.
You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?
A. Memory Advisor for the PGA
B. SQL Access Advisor
C. Memory Advisor for the shared pool
D. SQL Tuning Advisor
Identify three uses of the CROSSCHECK command (Choose three.)
A. to validate the database backup
B. to synchronize logical backup records with physical files in backup storage
C. to check the obsolete backups that can be deleted from the file system
D. to update information about backups that are deleted, corrupted, or inaccessible in a recovery catalog or control file
E. to update the recovery catalog or control file if archived log files are deleted with operating system commands
Which statement is true about the Oracle central inventory directory (oraInventory)?
A. oraInventory must not be shared by all Oracle software installations on a single system.
B. If ORACLE_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.
C. lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.
D. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.
The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis.
What is the most efficient way of diagnosing this problem?
A. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and
3:00 PM.
B. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
C. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM.
D. Create a SQL Tuning Set (STS) for the currently cached SQL statements in the shared pool and run SQL Performance Analyzer (SPA) to generate recommendations.
Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity.
Which action generates recommendations to overcome the performance issues?
A. running the Memory Advisor for the buffer cache
B. running the Memory Advisor for the library cache
C. running the Memory Advisor for the SGA
D. running the Memory Advisor for the PGA
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 used.
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)
A. An SPFILE can be created from a PFILE or from memory.
B. A PFILE can be used to start up a database instance even if an SPFILE exists.
C. An SPFILE must reside in the ORACLE_HOME/dbs directory.
D. An SPFILE can be created only before a database instance is started.
E. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.
Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.
Loss of which three database files can lead to an incomplete recovery? (Choose three.)
A. inactive online redo log file group
B. a data file belonging to the default temporary tablespace
C. a data file belonging to the SYSAUX tablespace
D. server parameter file (SPFILE)
E. active online redo log file group
F. all the control flies
Which two statements are true about resumable space allocation? (Choose two.)
A. A database-level LOGON trigger can be used to automatically configure resumable statement settings for individual sessions.
B. SELECT statements that run out of temporary space for sort areas are candidates for resumable execution.
C. A resumable statement can be suspended and resumed only once during a session.
D. Resumable space allocation does not apply when a database instance uses asynchronous commit.
E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.
F. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-062 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.