Exam information

Exam 1Z0-055, Oracle Database 11g: New Features for 9i OCPs (Jan 10, 2012)

Other exams

Which statement describes the effect of the execution of the above PL/SQL block?

Examine the following PL/SQL block:SET SERVEROUTPUT ONSET LONG 10000DECLARE report clob;BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE(); DBMS_OUTPUT.PUT_LINE(report);END;Which statement describes the effect of the execution of the above PL/SQL block?

Which statement is true regarding the status of the incident?

View the Exhibit to examine the details for an incident.Which statement is true regarding the status of the incident?


Which method or command would you use to accomplish this task?

You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?

Which two statements describe the implications of this? (Choose two.)

When executing a SQL workload, you choose to generate execution plans only, without collecting execution statistics. Which two statements describe the implications of this? (Choose two.)

Which two statements describe the consequences? (Choose two.)

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.)

Where would the result of this query be stored?

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM salesGROUP BY sale_category;Where would the result of this query be stored?

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

Which statement regarding the archived redo log files, created in an earlier incarnation of the database, is true?

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?

Page 1 of 2012345...1020...Last »