Oracle Database 11g Certified Master Upgrade Sample Questions:
1. 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 PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
B) The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
C) The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
D) All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
2. While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)
A) The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
B) The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.
C) The newly generated plans are directly placed into the SQL plan baseline without being
verified.
D) The plan baselines can be evolved over time to produce better performance.
3. Note the following statements that use flashback technology:
1.FLASHBACK TABLE <table> TO SCN <scn>;
2.SELECT * FROM <table> AS OF SCN 123456;
3.FLASHBACK TABLE <table> TO BEFORE DROP;
4.FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5.SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
A) 2, 3, 4, and 5
B) 1, 2, 3, 4, and 5
C) 1, 2, and 5
D) 1, 3, and 4
4. You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup? (Choose three.)
A) You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
B) You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
C) You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D) You are backing up to tape and your tape device performs its own compression.
E) You are making image copies, and you have not enabled tablespace compression.
5. How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has not yet completed?
A) Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
B) Retrieve the disk from the Recycle Bin after the operation completes.
C) Issue the ALTER DISKGROUP ... UNDROP DISKS command.
D) Issue the ALTER DISKGROUP ... ADD DISK command.
Solutions:
| Question # 1 Answer: A | Question # 2 Answer: A,D | Question # 3 Answer: C | Question # 4 Answer: A,B,C | Question # 5 Answer: C |
We're so confident of our products that we provide no hassle product exchange.


By Herman

