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

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: 61

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database. Which configuration should you use to accomplish this task?

  1. Enable Flashback Data Archive for the tables.

  2. Enable supplemental logging for the database.

  3. Specify undo retention guarantee for the database.

  4. Create Flashback Data Archive on the tablespace on which the tables are stored.

  5. Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.

Answer: A

Question No: 62

You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:

SQLgt; SELECT dbms_addm.get_report(lmy_instance_analysis_mode_task#39;) FROM dual;

You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT#39;s segments. What would you do to achieve this?

  1. Add a finding directive for the ADDM task.

  2. Add a segment directive for the ADDM task.

  3. Add a parameter directive for the ADDM task.

  4. Disable the Segment Advisor from the Automatic Maintenance Task.

Answer: B

Question No: 63

View the Exhibit.

Latesttests 2018 PDF and VCE

Examine the following command that is executed for the TRANSPORT table in the SH schema:

SQLgt; SELECT DBMS_STATS.CREATE_EXTENDED_STATS(lsh\ #39;customers^be1, #39;(countryjd, cust_state_province)#39;) FROM dual;

Which statement describes the significance of this command?

  1. It collects statistics into the pending area in the data dictionary.

  2. It creates a virtual hidden column in the CUSTOMERSjDBE table.

  3. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENT.

  4. It creates a histogram to hold skewed information about the data in the columns.

Answer: B

Question No: 64

Examine the following PL/SQL block:

SET SERVEROUTPUT ON SET LONG 10000

ECLARE report clob; BEGIN

report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT .PUT_LINE(report);

END;

Which statement describes the effect of the execution of the above PL/SQL block?

  1. The plan baselines are verified with the SQL profiles.

  2. All fixed plan baselines are converted into nonfixed plan baselines.

  3. All the nonaccepted SQL profiles are accepted into the plan baseline.

  4. The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

Answer: D

Question No: 65

Which statement is true regarding the VALIDATE DATABASE command?

  1. It checks the database for intrablock corruptions only

  2. It checks for block corruption in the valid backups of the database.

  3. It checks the database for both intrablock and interblock corruptions.

  4. It checks for only those corrupted blocks that are associated with data files.

Answer: A

Question No: 66

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing. What information is captured as part of this process? (Choose all that apply.)

  1. the SQL text

  2. the execution plan

  3. the execution context Do- the execution frequency

  4. the system change number (SCN)

Answer: A,C,D

Question No: 67

Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

  1. Only one I/O calibration process can run at a time

  2. It automates the resource allocation for the Automated Maintenance Tasks.

  3. It improves the performance of the performance-critical sessions while running.

  4. It can be used to estimate the maximum number of l/Os and maximum latency time for the system.

  5. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

Answer: A,D,E

Question No: 68

Which two statements are true regarding the starting of the database instance using the following command? (Choose two.)

SQLgt;STARTUP UPGRADE

  1. It enables all system triggers.

  2. It allows only SYSDBA connections.

  3. It ensures that all job queues remain active during the upgrade process.

  4. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

Answer: B,D

Question No: 69

Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

  1. It translates tasks into jobs for execution by the scheduler

  2. It creates jobs without considering the priorities associated with them.

  3. It determines the list of jobs that must be created for each maintenance window.

  4. It is spawned by the MMON background process at the start of the maintenance window.

  5. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

Answer: A,C,D

Question No: 70

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

  1. Compute the baseline statistics.

  2. Take an immediate AWR snapshot.

  3. Decrease the window size for the baseline.

  4. Decrease the expiration time for the baseline.

Answer: A

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