Exam information

Exam 1Z0-055: Oracle Database 11g: New Features for 9i OCPs (updated May 6th, 2016)

Other exams

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

Examine the following PL/SQL block: SET SERVEROUTPUT ON SET LONG 10000DECLARE report clob; BEGIN report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();DBMS_OUTPUT.PUT_LINE(report); END; Which statement describes the effect of theexecution 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 regardingthe 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?

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 withoutaffecting the changes made by other transactions?

Which two statements describe the implications of this?

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

Which two statements describe the consequences?

While deploying a new application module, the software vendor ships the applicationsoftware 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 theinitialization parameter file. You issued the following command: SQL>SELECT /*+RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BYsale_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?

Identify the activities performed as part of the Automatic SQL Tuning process in themaintenance 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 RESETLOGSoption. The LOG_ARCHIVE_FORMAT parameter is set to ‘ora_%t_%s_%r.log’. Whichstatement regarding the archived redo log files, created in an earlier incarnation of thedatabase, is true?

Page 1 of 2812345...1020...Last »