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

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-062.html

Question No.71

You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window.

Which two actions would reduce the job#39;s elapsed time? (Choose two.)

  1. Increasing the priority of the job class to which the job belongs

  2. Increasing the job#39;s relative priority within the Job class to which it belongs

  3. Increasing the resource allocation for the consumer group mapped to the scheduler job#39;s job class within the plan mapped to the scheduler window

  4. Moving the job to an existing higher priority scheduler window with the same schedule and duration

  5. Increasing the value of the JOB_QUEUE_PROCESSES parameter

  6. Increasing the priority of the scheduler window to which the job belongs

Correct Answer: BC

Explanation:

B: Job priorities are used only to prioritize among jobs in the same class. Note: Group jobs for prioritization

Within the same job class, you can assign priority values of 1-5 to individual jobs so that if two jobs in the class are scheduled to start at the same time, the one with the higher priority takes precedence. This ensures that you do not have a less important job preventing the timely completion of a more important one.

C: Set resource allocation for member jobs

Job classes provide the link between the Database Resource Manager and the Scheduler, because each job class can specify a resource consumer group as an attribute. Member jobs then belong to the specified consumer group and are assigned resources according to settings in the current resource plan.

Question No.72

Which two tasks can be performed on an external table? (Choose two.)

  1. partitioning the table

  2. creating an invisible index

  3. updating the table by using an UPDATE statement

  4. creating a public synonym

  5. creating a view

Correct Answer: DE

Explanation:

http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN01507

You can, for example select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.

Question No.73

Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

  1. shutting down the database instance that is being upgraded

  2. executing the catctl.pl script to run the upgrade processes in parallel

  3. running the Pre-Upgrade Information Tool

  4. copying the listener.ora file to the new ORACLE_HOME

Correct Answer: C

Explanation:

http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395

Question No.74

You execute the following PL/SQL:

image

Which two statements are true? (Choose two.)

  1. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE gt; 10000 is accessed.

  2. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE gt; 10000 is accessed.

  3. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

  4. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Correct Answer: AB Explanation: DBMS_FGA.add_policy

The DBMS_FGA package provides fine-grained security functions. ADD_POLICY Procedure

This procedure creates an audit policy using the supplied predicate as the audit condition.

Incorrect:

Not C: object_schema

The schema of the object to be audited. (If NULL, the current log-on user schema is assumed.)

Question No.75

Examine the structure of the SALES table, which is stored in a locally managed tablespace with Automatic Segment Space Management (ASSM) enabled.

image

You want to perform online segment shrink to reclaim fragmented free space below the high water mark.

What should you ensure before the start of the operation?

  1. Row movement is enabled.

  2. Referential integrity constraints for the table are disabled.

  3. No queries are running on this table.

  4. Extra disk space equivalent to the size of the segment is available in the tablespace.

  5. No pending transaction exists on the table.

Correct Answer: A

Question No.76

Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)

  1. It utilizes the OS file system cache.

  2. A traditional NFS mount is not required when using Direct NFS.

  3. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.

  4. Direct NFS is available only in UNIX platforms.

  5. Direct NFS can load-balance I/O traffic across multiple network adapters.

Correct Answer: CE

Explanation:

E: Performance is improved by load balancing across multiple network interfaces (if available).

Note:

To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.

Incorrect:

Not A: Direct NFS Client is capable of performing concurrent direct I/O, which bypasses any operating system level caches and eliminates any operating system write-ordering locks Not B:

To use Direct NFS Client, the NFS file systems must first be mounted and available over regular NFS mounts.

Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP).

Not D: Direct NFS is provided as part of the database kernel, and is thus available on all

supported database platforms – even those that don#39;t support NFS natively, like Windows.

Note:

Oracle Direct NFS (dNFS) is an optimized NFS (Network File System) client that provides faster and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP). Direct NFS is built directly into the database kernel – just like ASM which is mainly used when using DAS or SAN storage.

Oracle Direct NFS (dNFS) is an internal I/O layer that provides faster access to large NFS files than traditional NFS clients.

Question No.77

What happens if a maintenance window closes before a job that collects optimizer statistics completes?

  1. The job is terminated and the gathered statistics are not saved.

  2. The job is terminated but the gathered statistics are not published.

  3. The job continues to run until all statistics are gathered.

  4. The job is terminated and statistics for the remaining objects are collected the next time the maintenance window opens.

Correct Answer: D

Explanation:

The stop_on_window_close attribute controls whether the GATHER_STATS_JOB continues when the maintenance window closes. The default setting for the stop_on_window_close attribute is TRUE, causing Scheduler to terminate GATHER_STATS_JOB when the maintenance window closes. The remaining objects are then processed in the next maintenance window.

References: https://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#g49431

Question No.78

You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB? (Choose three.)

  1. SYSTEM

  2. SYSAUX

  3. EXAMPLE

  4. UNDO

  5. TEMP

  6. USERS

Correct Answer: ABE

Explanation:

A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it.

Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database. tablespace_datafile_clauses

Use these clauses to specify attributes for all data files comprising the SYSTEM and SYSAUX tablespaces in the seed PDB.

Incorrect:

Not D: a PDB can not have an undo tablespace. Instead, it uses the undo tablespace belonging to the CDB.

Note: Example:

CONN pdb_admin@pdb1

SELECT tablespace_name FROM dba_tablespaces; TABLESPACE_NAME

– SYSTEM

SYSAUX TEMP USERS SQLgt;

Question No.79

To enable the Database Smart Flash Cache, you configure the following parameters: DB_FLASH_CACHE_FILE = `/dev/flash_device_1#39; , `/dev/flash_device_2#39; DB_FLASH_CACHE_SIZE=64G

What is the result when you start up the database instance?

  1. It results in an error because these parameter settings are invalid.

  2. One 64G flash cache file will be used.

  3. Two 64G flash cache files will be used.

  4. Two 32G flash cache files will be used.

Correct Answer: A

Question No.80

Which statement is true about the Log Writer process?

  1. It writes when it receives a signal from the checkpoint process (CKPT).

  2. It writes concurrently to all members of multiplexed redo log groups.

  3. It writes after the Database Writer process writes dirty buffers to disk.

  4. It writes when a user commits a transaction.

Correct Answer: D

Explanation:

http://docs.oracle.com/cd/B19306_01/server.102/b14220/process.htm (see log writer process (LGWR))

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