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:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
-
SYS sessions, regardless of the roles that are set in the session
-
SYSTEM sessions, regardless of the roles that are set in the session
-
SCOTT sessions, only if the MGR role is set in the session
-
SCOTT sessions, only if the MGR role is granted to SCOTT
-
SCOTT sessions, because he is the owner of the table
-
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:
What are three possible causes for the latch-related wait events?
-
The size of the shared pool is too small.
-
Cursors are not being shared.
-
A large number COMMITS are being performed.
-
There are frequent logons and logoffs.
-
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.)
-
They run at predefined time intervals that are intended to occur during a period of low system load.
-
An Oracle Scheduler job is created for each maintenance task that is scheduled to run in a maintenance window.
-
A maintenance window is automatically extended until all the maintenance tasks defined are completed.
-
D.A repository is maintained in the SYSTEM tablespace to store the history of execution of all tasks.
-
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:
Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)
-
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.
-
The optimizer can re optimize a query only once using cardinality feedback.
-
The optimizer enables monitoring for cardinality feedback after the first execution of a query.
-
The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
-
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.)
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.)
-
Merge partitions of a list partitioned table
-
Drop partitions of a list partitioned table
-
Coalesce partitions of a hash-partitioned global index.
-
Move partitions of a range-partitioned table
-
Rename partitions of a range partitioned table
-
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.)
-
It can be configured to automatically attempt to restart various components after a hardware or software failure.
-
While starting any components, it automatically attempts to start all dependencies first and in proper order.
-
It can be configured to automatically restart a database in case of normal shutdown of the database instance.
-
It can be used to only start Oracle components.
-
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?
-
statistics recommendations
-
SQL profile recommendations
-
SQL statement restructure recommendations
-
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:
Version: Oracle Database 12c Releases 1 64-bit Character set: WE8ISO8859P15
National character set: AL16UTF16 O/S: Oracle Linux6 64-bit
The characteristics of the CDB are as follows:
Version: Oracle Database 12c Release 1 64-bit Character set: AL32UTF8
O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
-
Transportable database
-
Transportable tablespace
-
Data Pump full export / import
-
The DBMS_PDB package
-
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?
-
Create an event-based job.
-
Create a lightweight job.
-
Specify the job as a member of a job class.
-
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