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

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

The following databases are registered in the base recovery catalog: PROD1 鈥?PROD2, and PROD3. The database user CAT OWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.

Given below are some of the commands required to achieve this:

1 .SQLgt; GRANT recovery_catalog_owner TO vpc1;

  1. RMANgt; CONNECT CATALOG vpc1/password@catdb;

  2. RMANgt; GRANT CATALOG FOR DATABASE prod1 TO vpc1;

  3. RMANgt; CONNECT CATALOG catowner/password@catdb;

  4. RMANgt; CREATE VIRTUAL CATALOG;

    What is the correct sequence in which the commands have to be executed?

    A. 1,4,5,2,3

    B. 1,4,3,2,5

    C. 4,5,2,3, 1

    D. 2,3,4,5, 1

    E. 1,4,2,3,5

    Answer: B

    Question No: 12

    In which two aspects does hot patching differ from conventional patching? (Choose two.)

    1. It consumes more memory compared with conventional patching.

    2. It can be installed and uninstalled via OPatch unlike conventional patching.

    3. It takes more time to install or uninstall compared with conventional patching.

    4. It does not require down time to apply or remove unlike conventional patching.

    5. It is not persistent across instance startup and shutdown unlike conventional patching.

Answer: A,D

Question No: 13

You want to perform the following operations for the DATA ASM disk group:

-Verify the consistency of the disk.

-Cross-check all the file extent maps and allocation tables for consistency. -Check whether the alias metadata directory and file directory are linked correctly. -Check that ASM metadata directories do not have unreachable allocated blocks.

Which command accomplishes these tasks?

  1. ALTER DISKGROUP data CHECK;

  2. ALTER DISKGROUP data CHECK DISK;

  3. ALTER DISKGROUP data CHECK FILE;

  4. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Answer: A

Question No: 14

View the Exhibit to examine the details for an incident.

Latesttests 2018 PDF and VCE

Which statement is true regarding the status of the incident?

  1. The DBA is working on the incident and prefers that the incident be kept in the ADR.

  2. The incident is now in the Done state and the ADR can select the incident to be purged.

  3. The incident has been newly created and is in the process of collecting diagnostic

    information.

  4. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support.

Answer: D

Question No: 15

Which three are the valid statements in relation to SQL plan baselines? (Choose three.)

  1. The plans can be manually loaded to the SQL plan baseline.

  2. The plans in the SQL plan baseline are verified and accepted plans.

  3. The plans generated for every SQL statement are stored in the SQL plan baseline by default.

  4. The plan baselines are stored temporarily in the memory as long as the database instance is running.

  5. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.

Answer: A,B,E

Question No: 16

You executed the following commands:

SQLgt; ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false;

SQLgt; EXECUTE DBMS_STATS.SET_TABLE_PREFS(#39;SHI, #39;CUSTOMERS#39;, #39;PUBLISH#39;.#39;false#39;);

SQLgt; EXECUTE DBMS_STATS.GATHER_TABLE_STATS(#39;SH#39;, #39;CUSTOMERS#39;);

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  1. The statistics are stored in the pending statistics table in the data dictionary.

  2. The statistics are treated as the current statistics by the optimizer for all sessions.

  3. The statistics are treated as the current statistics by the optimizer for the current sessions only.

  4. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

Answer: A

Question No: 17

Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  1. Only a single partitioning key column can be specified.

  2. All DML statements must use partition-extended syntax.

  3. The same physical attributes must be specified for each partition.

  4. Unique local indexes cannot be created on a system-partitioned table.

  5. Traditional partition pruning and partitionwise joins are not supported on these tables.

Answer: D,E

Question No: 18

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

  1. AWR baselines are always created as repeating baselines.

  2. AWR baselines can be created on the basis of two time values.

  3. AWR baselines are always created with infinite expiration duration.

  4. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

Answer: B

Question No: 19

Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)

  1. The problem key is the same as the incident number,

  2. Every problem has a problem key, which is a text string that describes the problem.

  3. The database makes an entry into the alert log file when problems and incidents occur.

  4. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.

  5. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository (ADR).

Answer: B,C,D

Question No: 20

While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?

  1. The backup succeeds but it would be without the missing archived log.

  2. The backup fails because one of the archived redo log files is missing.

  3. The backup succeeds because it fails over to one of the alternative archived redo log destinations.

  4. During backup, you are prompted for the alternative destination for the missing archived redo log file.

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