[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-050 Dumps with VCE and PDF 61-70

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-050
100% Free Download! 100% Pass Guaranteed!

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.

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


ECLARE report clob; BEGIN



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.)


  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% Ensurepass Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-050 Dumps

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.