[Free] 2018(Jan) Dumps4cert Braindumps Oracle 1z0-050 Dumps with VCE and PDF 41-50

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-050
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: New Features for Administrators

Question No: 41

Examine the following RMAN command:



Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

  1. Only data files and the control file are backed up.

  2. Archived redo logs are backed up only if the database is open during the backup

  3. The backup is deleted after one day, regardless of the default retention policy settings.

  4. The backup becomes obsolete after one day, regardless of the default retention policy settings.

Answer: B,D

Question No: 42

In which situations will the ASM metadata backup help you recover the ASM disk in a disk group? (Choose all that apply.)

  1. when one or more disks in an ASM disk group are lost

  2. when the data file on an ASM disk group gets corrupted

  3. when one of the disks in a disk group is accidentaly unplugged

  4. wnen one or more file directory paths are accidentally deleted from an ASM disk group

Answer: A,D

Question No: 43

View the Exhibit to examine the error during the database startup.

Dumps4Cert 2018 PDF and VCE

You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:


Which statement describes the consequence of the command?

  1. The command performs the recovery and closes the failures.

  2. The command only displays the advice and the RMAN script required for repair.

  3. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command

  4. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C

Question No: 44

Examine the following PL/SQL block:


my_plans plsjnteger; BEGIN


?9twu5t2dn5xd?; END;

Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

  1. It is loaded with the FIXED status.

  2. It is loaded with the ACCEPTED status.

  3. It is not loaded with the ENABLED status.

  4. It is not loaded with the ACCEPTED status.

Answer: B

Question No: 45

While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

  1. It updates the existing SQL profiles with current statistics.

  2. It makes the statistics information available to GATHER_STATS_JOB.

  3. It initiates the statistics collection process by running GATHER_STATS_JOB.

  4. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.

Answer: B

Question No: 46

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

  1. The plan baselines can be evolved over time to produce better performance

  2. The newly generated plans are directly placed into the SQL plan baseline without being verified.

  3. The new SQL statements initially run with the plans that are known to produce good performance under standard

    test configuration.

  4. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: A,C

Question No: 47

Evaluate the following command and Its output: SQLgt;SELECT * FROM dba_temp_free_space;


Which two statements correctly interpret the output? (Choose two.)

  1. FREE_SPACE indicates only the space that is currently unallocated.

  2. ALLO CAT ED_S PACE indicates only the space currently allocated and in use.

  3. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

  4. ALLO CAT ED_S PACE indicates both the space currently allocated and used, and the space that is available for reuse.

  5. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.

Answer: D,E

Question No: 48

Evaluate the following code:

SQLgt;VARIABLE task_name VARCHAR2(255); SQLgt;VARIABLE sql_stmt VARCHAR2(4000); SQLgt;BEGIN

:sql_stmt := #39;SELECT COUNTO FROM customers

WHERE cust_state_province =”CA”; :task_name := #39;MY_QUICKTUNE_TASK#39;;


:task_name, :sql_stmt); END;

What is the outcome of this block of code?

  1. It creates a task and workload, and executes the task.

  2. It creates a task and workload but does not execute the task.

  3. It produces an error because a template has not been created.

  4. It produces an error because the SQL Tuning Set has not been created.

Answer: A

Question No: 49

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the test machine. Note the following steps that you may require to replay the database workload:

  1. Preprocess the captured workload.

  2. Restart the database in RESTRICTED mode.

  3. Set up the Replay Clients.

  4. Restore the test database to the point when the capture started.

  5. Remap connections.

Arrange the steps required in the correct sequence to accomplish this task on the test machine.

A. 2, 1,5,3,4

B. 1,2,4,5,3

  1. 1,4, 5, 3 (2 is not required.)

  2. 1, 2,4, 5 (3 is not required.)

  3. 1,4, 3, 5 (2 is not required.)

Answer: C

Question No: 50

View the Exhibit to examine the parameter values.

Dumps4Cert 2018 PDF and VCE

You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?

  1. 90 MB

  2. 272 MB

  3. 362 MB

  4. 1440 MB

Answer: C

100% Dumps4cert Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Dumps4cert Free Guaranteed!
1z0-050 Dumps

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