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

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

Examine the following RMAN command:

BACKUP DATABASE TAG TESTDB

KEEP UNTIL #39;SYSDATE 11 RESTORE POINT TESTDB06;

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.

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

RMANgt; REPAIR FAILURE;

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:

DECLARE

my_plans plsjnteger; BEGIN

My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_Id =gt;

?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;

TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088

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;;

DBMS_ADVISOR .QUICK_TUNE(DBMS_ADVISOR .SQLACCESS_ADVISOR,

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

Latesttests 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% 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