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

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

You have the following requirements in relation to the detection of block corruption for your database instance:

  1. Check for logical self-consistency of data blocks when modified in memory.

  2. Checksums are calculated before and after the block change.

  3. Checks are performed for the lost writes to the physical standby database. Which method would help you perform the above checks automatically?

    1. Set the DB_SECUREFILE parameter to PERMITTED.

    2. Set the DB_ULTRA_SAFE parameter to DATAJDNLY.

    3. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.

    4. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

Answer: B

Question No: 82

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.

Ensurepass 2018 PDF and VCE

What is the reason for this error?

  1. Another repair session is running concurrently.

  2. The failure ID has not been mentioned in the command for data file 5.

  3. There are new failures recorded in the Automatic Diagnostic Repository (ADR).

  4. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.

Answer: A

Question No: 83

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

  1. Create a repeating baseline template.

  2. Insert a finding directive for future ADDM tasks.

  3. Create and populate a SQL Tuning Set from the AWR on every Monday.

  4. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

Answer: A

Question No: 84

View the Exhibit to examine the Automatic SQL Tuning result details.

Ensurepass 2018 PDF and VCE

Which action would you suggest for the selected SQL statement in the Exhibit?

  1. Accept the recommended SQL profile.

  2. Collect statistics for the related objects.

  3. Run the Access Advisor for the SQL statement.

  4. Run the Segment Advisor for recommendations.

Answer: C

Question No: 85

Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

  1. Generate reports on data failure such as data file failures,

  2. You can package and upload diagnostic data to Oracle Support.

  3. You can track the Service Request (SR) and implement repairs.

  4. You can manually run health checks to gather diagnostic data for a problem.

Answer: B,C,D

Question No: 86

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:

LOG_ARCHIVE_DEST_1 = #39;LOCATION = /disk1 /archive1 LOG_ARCHIVE_DEST_2 = #39;SERVICE = Stdb1

DB_RECOVERY_FILE_DEST = 7u01/oradata#39;

Examine the following RMAN command issued to set the deletion policy for archived log files:



Which statement is true regarding what this command accomplishes?

  1. All archived redo log files backed up at least twice to tape are deleted.

  2. All archived redo log files backed up at least once to tape are eligible for deletion.

  3. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.

  4. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

Answer: D

Question No: 87

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)

  1. The disk automatically goes offline.

  2. The disk is immediately dropped from the disk group.

  3. The ASM tracks the extents that are modified during the outage.

  4. The ASM migrates the extents from the unavailable disk to the remaining disks.

Answer: A,C

Question No: 88

Which setting enables the baselines by default in Oracle Database 11g?

  1. setting the STATISTICS_LEVEL parameter to TYPICAL

  2. adding filters to the Automatic Database Diagnostic Monitor (ADDM)

  3. enabling Automated Maintenance Task using Oracle Enterprise Manager

  4. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

Answer: A

Question No: 89

You opened the encryption wallet and then Issued the following command:

SQLgt;CREATE TABLESPACE securespace DATAFILE #39;/home/user/oradata/secureOI .dbf SIZE 150M


Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.

What is the outcome?

  1. It creates the table and encrypts the data in it.

  2. It generates an error because the wallet is closed

  3. It creates the table but does not encrypt the data in it.

  4. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

Answer: B

Question No: 90

ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  1. The data is decrypted during SORT and JOIN operations.

  2. The data remains encrypted when it is read into memory.

  3. The data remains encrypted when it is stored in the redo logs.

  4. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Answer: C

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.