OCA OCP Oracle Certification Exam Braindumps

8. 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 sales
         GROUP BY sale_category;

Where would the result of this query be stored?
A. PGA
B. large pool
C. shared pool
D. database buffer cache
Answer: C

1z0-055:Oracle Database 11g: New Features for 9i OCPs

9. Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)
A. generating the SQL profile
B. testing and accepting the SQL profile
C. generating a list of candidate SQLs for tuning
D. adding tuned SQL plans into the SQL plan baseline
E. tuning each SQL statement in the order of importance
F. generating baselines that include candidate SQL statement for tuning
Answer: ABCE

10. 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?
A. The archived redo log files will be overwritten.
B. The archived redo log files are deleted automatically.
C. The archived redo log files should be moved to some other location.
D. The archived redo log files are still maintained because the file names are unique.
Answer: D

11. View the Exhibit for the object interdependency diagram.The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure.
GET_DATA is called in the CHECK_DATA function.A new column PROD_QTY is added to the PRODUCTS table.How does this impact the status of the dependent objects?
A. All dependent objects remain valid.
B. Only the procedure and function become invalid and must be recompiled.
C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
Answer: A

12. Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply.)
A. ADR diagnostic files
B. all the optimizer statistics
C. initialization parameter settings
D. PL/SQL functions, procedures, and packages
E. the table and index definitions and actual data
Answer: BCE