[Free] 2019(Nov) EnsurePass Oracle 1z0-062 Dumps with VCE and PDF 101-110

Get Full Version of the Exam

Question No.101

You upgraded from a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.

After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want to collect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.

How do you accomplish this?

  1. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

  2. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

  3. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.

  4. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

Correct Answer: D


Monitoring database operations

Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation.

Question No.102

You performed an incremental level 0 backup of a database: RMAN gt; BACKUP INCREMENTAL LEVEL 0 DATABASE;

To enable block change tracking after the incremental level 0 backup, you issued this command: SQL gt; ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE

` /mydir/rman_change_track.f#39;;

To perform an incremental level 1 cumulative backup, you issued this command: RMANgt; BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which three statements are true? (Choose three.)

  1. Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

  2. The change tracking file must always be backed up when you perform a full database backup.

  3. Block change tracking will always reduce I/O performed during cumulative incremental backups.

  4. More than one database block may be read by an incremental backup for a change made to a single block.

  5. The incremental level 1 backup that immediately follows the enabling of block change tracking will not read the change tracking file to discover changed blocks.

Correct Answer: ADE

Question No.103

Your database instance has started using an SPFILE. Examine the RMAN configuration settings:


You execute the command:


Which three types of files are backed up by using this command? (Choose three.)

  1. online redo log files

  2. control file


  4. archived redo log files

  5. data file(s)

  6. PFILE

Correct Answer: BCE



Question No.104

You set the following parameters in the parameter file and restart the database instance:


Which two statements are true? (Choose two.)

  1. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.

  2. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.

  3. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.

  4. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.

  5. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.

Correct Answer: AD

Question No.105

Identify three benefits of Unified Auditing.

  1. Decreased use of storage to store audit trail rows in the database.

  2. It improves overall auditing performance.

  3. It guarantees zero-loss auditing.

  4. The audit trail cannot be easily modified because it is read-only.

  5. 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#39;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.


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 No.106

Which two statements are true about standard database auditing? (Choose two.)

  1. DDL statements can be audited.

  2. Statements that refer to standalone procedure can be audited.

  3. Operations by the users logged on as SYSDBA cannot be audited.

  4. Only one audit record is ever created for a session per audited statement even though it is executed more than once.

Correct Answer: AB

Question No.107

You created an encrypted tablespace:


You then closed the encryption wallet because you were advised that this is secure.

Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column.

Which is true about the result?

  1. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.

  2. It generates an error when creating the table because the wallet is closed.

  3. It creates the table successfully, and encrypts any inserted data in the EMPNAME column

    because the wallet needs to be open only for tablespace creation.

  4. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.

Correct Answer: B

Question No.108

In which two scenarios do you use SQL* Loader to load data? (Choose two.)

  1. Transform the data while it is being loaded into the database.

  2. Use transparent parallel processing without having to split the external data first.

  3. Load data into multiple tables during the same load statement.

  4. Generate unique sequential key values in specified columns.

Correct Answer: CD

Question No.109

In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container:


Which two statements are true? (Choose two.)

  1. The C # # ROLE1 role is created in the root database and all the PDBs.

  2. The C # # ROLE1 role is created only in the root database because the container clause is not used.

  3. Privileges are granted to the C##A_ADMIN user only in the root database.

  4. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.

  5. The statement for granting a role to a user fails because the CONTAINER clause is not used.

Correct Answer: AC


You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.


Creates a common role. CONTAINER = CURRENT

Creates a local role in the current PDB.

Question No.110

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)

  1. The index remains invisible.

  2. The index is not updated by the DML statements on the indexed table.

  3. The index automatically becomes visible in order to have it updated by DML on the table.

  4. The index becomes unusable but the table is updated by the DML.

  5. The index is updated by the DML on the table.

Correct Answer: AE


Unlike unusable indexes, an invisible index is maintained during DML statements.


Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.

Get Full Version of the Exam
1z0-062 Dumps
1z0-062 VCE and PDF

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.