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

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

Oracle Database 11g: New Features for 9i OCPs

Question No: 91

The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

  1. Create two custom ADDM tasks

  2. Modify the AWR snapshot time interval to two hours

  3. Create a new scheduler window for a time period to two hours

  4. Modify the Automatic Workload Repository(AWR) snapshot retention period to two hours

Answer: B

Question No: 92

Which two statements are trueregarding the SQL Repair Advisor? (Choose two.)

  1. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements

  2. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash

  3. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement

  4. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR

Answer: B,D

Question No: 93

See the following PL/SQL block:


my_plans pls_integer, BEGIN


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

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’. Which statement regarding the archived redo log files, created in an earlier incarnation of the database is true?

  1. The archived redo log files will be overwritten

  2. The archived redo log files are deleted automatically

  3. The archived redo log files should be moved to some other location

  4. The archived redo log files are still maintained because the file names are unique

Answer: D

Question No: 95

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:


You need statistics to be collected more quickly. What can you do to achieve this?

  1. Set DYNAMIC_SAMPLING to level 4

  2. Set the STATISTICS_LEVEL parameter to BASIC

  3. Set the INCREMENTAL value to TRUE for the partition table

  4. Increase the value of STALE_PERCENT for the partition table

Answer: C

Question No: 96

In which two aspects does hotpatching 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 convetinal 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: 97

Evaluate the following command:

SQLgt;ALTER SYSTEM SET db_securefile=’IGNORE’;

What is the impact of this setting on the usage of SecureFiles?

  1. It forces BasicFiles to be created even if the SECUREFILE option is specified to created the LOB

  2. It forces SecureFiles to be created even if the BASICFILE option is specified to created the LOB

  3. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB

  4. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile

Answer: A

Question No: 98

In you database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured.

A user SCOTT with the SYSDBA privilege tried to connect to the database instance from a

remote machine using the command:

$ SQLPLUS scott/tiger@DB01 AS SYSDBA Where DB01 is the net service name.

Which authentication method would be used first?

  1. Authentication by password file

  2. Authentication by using certificates over SSL

  3. Authentications by using the Oracle Internet Directory

  4. Authentication by using the local OS of the database server

Answer: A

Question No: 99

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

You are working on a CATDB database that contains an Oracle Database Version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10 into the recovery catalog owned by RCO11. You executed the following RMAN commands:

RMANgt; CONNECT CATALOG rco11/password@catdb RMANgt;IMPORT CATALOG rcat10/oracle@inst1;

What happens when you execute the above commands? (Choose all that apply.)

  1. They deregister all databases registered in the RCAT10 catalog

  2. They import metadata for all registered databases in the RCAT10 database

  3. They register all the RCAT10 catalog registered databases in the RCO11 catalog

  4. They overwrite all stored scripts in the RCO11 catalog with the same name as that in the RCAT10 catalog

Answer: A,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 *