[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-050 Dumps with VCE and PDF Download 111-120

Latesttests 2018 Jan Oracle Official New Released 1z0-050
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-050.html

Oracle Database 11g: New Features for Administrators

Question No: 111

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAMEJDX index on the ENAME column.

You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.

What action is required for the dependent objects when you perform online redefinition on the table?

  1. The materialized view should have a fast refresh performed after the online table redefinition is completed.

  2. The materialized view should have a complete refresh performed after the online table redefinition is completed.

  3. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.

  4. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

Answer: B

Question No: 112

An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:

SQLgt;CREATE INDEX ord_custname_ix ON orders(custname);

The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause.

You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.

Which is the most efficient method of performing this task?

  1. disabling the index

  2. making the index invisible

  3. making the index unusable

  4. using the MONITORING USAGE clause for the index

Answer: B

Question No: 113

Your organization decided to upgrade the existing Oracle 10g database to Oracle 11 g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:

SQLgt;@utlrp.sql

What is the significance of executing this script?

  1. It performs parallel recompilation of only the stored PL/SQL code.

  2. It performs sequential recompilation of only the stored PL/SQL code.

  3. It performs parallel recompilation of any stored PL/SQL as well as Java code.

  4. It performs sequential recompilation of any stored PL/SQL as well as Java code.

Answer: C

Question No: 114

Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)

  1. ADR diagnostic files

  2. all the optimizer statistics

  3. initialization parameter settings

  4. PL/SQL functions, procedures, and packages

  5. the table and index definitions and actual data

Answer: B,C,D

Question No: 115

Which two statements about the SQL Management Base (SMB) are true? (Choose two.)

  1. It contains only SQL profiles generated by SQL Tuning Advisor.

  2. It stores plans generated by the optimizer using a stored outline.

  3. It is part of the data dictionary and stored in the SYSAUXtablespace.

  4. It is part of the data dictionary and stored in the SYSTEM tablespace.

  5. It contains the statement log, the plan history, plan baselines, and SQL profiles.

Answer: C,E

Question No: 116

You are managing an Oracle Database 11 g database with ASM storage. The ASM disk group has the COMPATIBLE .ASM attribute set to 11.1. Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

  1. Extent management is completely automated.

  2. The allocation unit size may vary but the extent size is fixed.

  3. The au_size disk group attribute determines the size of allocation units in the disk group.

  4. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

Answer: A,C

Question No: 117

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

  1. Cursor cache

  2. Stored outline

  3. SQL Tuning Set

  4. Automatic Workload Repository (AWR) snapshots

Answer: A,C

Question No: 118

Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

  1. It detects changes in SQL execution plans.

  2. It produces results that can be used to create the SQL plan baseline.

  3. The importance of SQL statements is based on the size of the objects accessed.

  4. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

  5. It shows only the overall impact on workload and not the net SQL impact on workload.

Answer: A,B,D

Question No: 119

View the Exhibit that sets the threshold for the Current Open Cursors Count metric.

Latesttests 2018 PDF and VCE

Why is the Significance Level threshold type not available in the threshold setting?

  1. because AWR baseline is not enabled

  2. because Current Open Cursors Count is not a basic metric

  3. because the STATISTICS_LEVEL parameter is set to BASIC

  4. because the AWR baseline is a system-defined moving window baseline

Answer: B

Question No: 120

Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

  1. It can be used to backup all data on ASM disks.

  2. It can be used to re-create the ASM disk group with its attributes.

  3. It can be used to recover the damaged ASM disk group along with the data.

  4. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

Answer: B,D

100% Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-050 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE