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

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

Question No.151

A redaction policy was added to the SAL column of the SCOTT.EMP table:

image

All users have their default set of system privileges.

For which three situations will data not be redacted? (Choose three.)

  1. SYS sessions, regardless of the roles that are set in the session

  2. SYSTEM sessions, regardless of the roles that are set in the session

  3. SCOTT sessions, only if the MGR role is set in the session

  4. SCOTT sessions, only if the MGR role is granted to SCOTT

  5. SCOTT sessions, because he is the owner of the table

  6. SYSTEM session, only if the MGR role is set in the session

Correct Answer: ABD

Question No.152

Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:

image

What are three possible causes for the latch-related wait events?

  1. The size of the shared pool is too small.

  2. Cursors are not being shared.

  3. A large number COMMITS are being performed.

  4. There are frequent logons and logoffs.

  5. The buffers are being read into the buffer cache, but some other session is changing the buffers.

Correct Answer: ABD

Question No.153

Which three statements are true about automated maintenance tasks? (Choose three.)

  1. They run at predefined time intervals that are intended to occur during a period of low system load.

  2. An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.

  3. A maintenance window is automatically extended until all the maintenance tasks defined are completed.

  4. D.A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.

  5. Predefined maintenance tasks consist of automatic optimizer statistics collection, running Automatic Segment Advisor, and running Automatic SQL Tuning Advisor.

Correct Answer: ABE

Explanation:

https://docs.oracle.com/cd/E11882_01/server.112/e25494/tasks.htm#ADMIN12331

Question No.154

Examine the parameters for your database instance:

image

Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)

  1. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

  2. The optimizer can re optimize a query only once using cardinality feedback.

  3. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

  4. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

  5. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Correct Answer: ACD

Explanation:

C: During the first execution of a SQL statement, an execution plan is generated as usual.

D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.

(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.

optimizer_dynamic_sampling optimizer_features_enable

dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.

Note:

OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.

Range of values. 0 to 10

Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.

Question No.155

A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions

The table has a local prefixed, range partitioned index.

Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.

This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.

You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.

Which three methods could transparently help to achieve this result? (Choose three.)

  1. Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.

  2. Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

  3. Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.

  4. Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.

  5. Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.

  6. Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.

Correct Answer: ACE

Explanation:

Oracle 12c now provides the ability to index a subset of partitions and to exclude the others. Local and global indexes can now be created on a subset of the partitions of a table. Partial Global indexes provide more flexibility in index creation for partitioned tables. For example, index segments can be omitted for the most recent partitions to ensure maximum data ingest rates without impacting the overall data model and access for the partitioned object. Partial Global Indexes save space and improve performance during loads and queries. This feature supports global indexes that include or index a certain subset of table partitions or subpartitions, and exclude the others. This operation is supported using a default table indexing property. When a table is created or altered, a default indexing property can be specified for the table or its partitions.

Question No.156

Which three operations can be performed as multipartition operations in Oracle? (Choose three.)

  1. Merge partitions of a list partitioned table

  2. Drop partitions of a list partitioned table

  3. Coalesce partitions of a hash-partitioned global index.

  4. Move partitions of a range-partitioned table

  5. Rename partitions of a range partitioned table

  6. Merge partitions of a reference partitioned index

Correct Answer: ABF

Explanation:

Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.

A: Merge Multiple Partitions:

The new quot;ALTER TABLE … MERGE PARTITIONS quot; help merge multiple partitions or

subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.

B: Drop Multiple Partitions:

The new quot;ALTER TABLE … DROP PARTITIONS quot; help drop multiple partitions or subpartitions with a single statement.

Example:

view plaincopy to clipboardprint?

SQLgt; ALTER TABLE Tab_tst1 DROP PARTITIONS

Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7; Table altered

SQLgt;

Restrictions:

You can#39;t drop all partitions of the table.

If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.

Question No.157

Which three statements are true about Oracle Restart? (Choose three.)

  1. It can be configured to automatically attempt to restart various components after a hardware or software failure.

  2. While starting any components, it automatically attempts to start all dependencies first and in proper order.

  3. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

  4. It can be used to only start Oracle components.

  5. It runs periodic check operations to monitor the health of Oracle components.

Correct Answer: BDE

Question No.158

What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

  1. statistics recommendations

  2. SQL profile recommendations

  3. SQL statement restructure recommendations

  4. creation of materialized views to improve query performance

Correct Answer: B

Question No.159

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).

The characteristics of the non-CDB are as follows:

image

image

Version: Oracle Database 12c Releases 1 64-bit Character set: WE8ISO8859P15

image

image

National character set: AL16UTF16 O/S: Oracle Linux6 64-bit

The characteristics of the CDB are as follows:

image

image

Version: Oracle Database 12c Release 1 64-bit Character set: AL32UTF8

image

O/S: Oracle Linux 6 64-bit

Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

  1. Transportable database

  2. Transportable tablespace

  3. Data Pump full export / import

  4. The DBMS_PDB package

  5. RMAN

Correct Answer: C

Question No.160

What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

  1. Create an event-based job.

  2. Create a lightweight job.

  3. Specify the job as a member of a job class.

  4. Use a job array.

Correct Answer: B

Explanation:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBH

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.