Online Access Free 1Z0-055 Practice Test

Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

• A.Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
• B.Health Monitor checks are always initiated manually when there is some critical error.
• C.Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt, or inconsistent.
• D.Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.
You executed the following commands:
SQL> VAR tname VARCHAR2(60);
SQL> BEGIN
:tname := 'my_instance_analysis_mode_task';
DBMS_ADDM.INSERT_SEGMENT_DIRECTIVE(:tname,'Sg_directive','SCOTT');
END;
Which statement describes the consequence?

• A.The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
• B.The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
• C.All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
• D.The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump
USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?

• A./u01/app/oracle/product/11.1.0/db_1
• B./u01/app/oracle
• C.$ORACLE_HOME/bdump
• D.$ORACLE_HOME/log

During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?

• A.The installation proceeds with the default value without warnings and errors.
• B.The installation proceeds with the default value but a message would be generated in the alert log file.
• C.The installation terminates with an error.
• D.The installation proceeds with the default value but it would not be an OFA-compliant database.

Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

• A.It repairs blocks by always reading them from the mirror copy and writing them to the original location.
• B.It checks whether the alias metadata directory and the file directory are linked correctly.
• C.It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
• D.It repairs blocks that have read disk I/O errors.