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

2018 Jan Oracle Official New Released 1z0-055
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: New Features for 9i OCPs

Question No: 81

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

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

->Checksums are calculated before and after the block change

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

  3. Set the DB_LOCK_CHECKSUM parameter to TYPICAL

  4. Set the DB_LOST _WRITE_PROTECT parameter to TYPICAL

Answer: B

Question No: 82

The following databases are registered in the base recovery catalog: PROD1, PROD2 and PROD3. The database use CATOWNER 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:

Ensurepass 2018 PDF and VCE

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

You are managing an Oracle Database 11ginstance with ASM storage. You lost an ASM disk group DATA. You have RMAN backup of data as well as ASM metadata backup.

You want to re-create the missing disk group by using the ASMCMD md_restore

command. Which of these methods would you use to achieve this? (Choose all that apply.)

  1. Restore metadata in an existing disk group by passing the existing disk name as an input parameter

  2. Restore the disk group with changed disk group specification, failure group specification, disk group name and other disk attributes

  3. Restore the disk group with the exact configuration as the backed-up disk group, using the same group name, same set of disks and failure group configurations

  4. Restore the disk group with the exact configuration as the backed-up disk group, using the same disk group name, same set of disks, failure group configurations and data on the disk group

Answer: A,C

Question No: 84

The application tables ownedby the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

  1. owner

  2. touser

  3. attach

  4. remap_schema

Answer: D

Question No: 85

Evaluate the following block of code:

Ensurepass 2018 PDF and VCE

What is the outcome of the above code?

  1. It produces an error because a fully qualified host name needs to be specified

  2. It produces an error because the range of ports associated with the hosts has not bee specified

  3. It creates an access control lists (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges

  4. It creates an access control list (ACL) with the user ACCT_MGR who get the CONNECT privilege but not the RESOLVE privilege

Answer: C

Question No: 86

What two statements are trueregarding the recommendations received from the SQL Access Advisor? (Choose two.)

  1. It can recommend partitioning only on tables that have at least 10,000 rows

  2. It cannot generate recommendations that support multiple workload queries

  3. It can recommend only B-tree indexes and not bitmap or function-based indexes

  4. It can recommend partitioning on table provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type

Answer: A,D

Question No: 87

You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

  1. ASM compatibility controls which features for the ASM will be enabled

  2. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group

  3. The RDBMS compatibility settings for a disk group control the format of data structures of ASM metadata on the disk

  4. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances

Answer: A,B,D

Question No: 88

You are using Recovery Manager(RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)

  1. You are backing up to tape and your tape device performs its own compression

  2. You are making image copies and you have not enabled tablespace compression

  3. You are using disk-based backups and disk space in you Flash Recovery Area or other disk-based backup destinations are limited

  4. You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage

  5. You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage

Answer: C,D,E

Question No: 89

Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

  1. Cursor cache

  2. Stored outline

  3. SQL Tuning Set

  4. Automatic Workload Repository (AWR) snapshots

Answer: A,C

Question No: 90

Which statements are true regarding thesystem-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

  1. It does not allow you to change the moving window size

  2. Adaptive threshold functionalities use it by default to compute statistics

  3. It is created by default with the window size being equal to the AWR retention time

  4. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR)

Answer: B,C

100% Free Download!
Download Free Demo:1z0-055 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-055 Full Exam PDF and VCE

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

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


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