E stored outlines will not become invalid when you

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: not in the data dictionary. E: Stored outlines will not become invalid when you analyze the associated objects. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 801-804 Chapter 17: Tuning Database Applications QUESTION 10: What does this statement do? SQL>ANALYZE INDEX index_name VALIDITY STRUCTURE; A. It places information into the INDEX_STATS view and allows for the monitoring of space used by an index. B. It provides information in the INDEX_HISTOGRAM view to indicate whether an index is invalid or valid. C. It provides information in the DBA_INDEXES view for the COST BASED Optimizer when choosing an execution plan. Answer: A Explanation: This statement places information into the INDEX_STATS view to allow you to monitor of space usage by an index. Incorrect Answers: B: This ANALYZE statement does not provide information in the INDEX_HISTOGRAM view. C: This ANALYZE statement does not provide information in the DBA_INDEXES view. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 917-918 Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 11: Which three types of statistics are reported in report.txt after running UTLESTAT SQL? (Choose three) Actualtests.com - The Power of Knowing 1Z0-024 A. Locking statistics. B. Memory usage statistics. C. Explain plan statistics. D. Library cache statistics. E. Buffer busy wait statistics. F. Rollback contention statistics. Answer: D, E, F Explanation: Report.txt file contains library cache, buffer busy waits and rollback contention statistics. Incorrect Answers: A: This report does not shows locking statistics. B: It will not provide memory usage statistics. C: Report.txt file does not contain any information about explain plan statistics. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 769-776 Chapter 16: Introducing Database Tuning QUESTION 12: What are two main OLTP requirements? (Choose two) A. Use bind variables rather than literals in your SQL code. B. Analyze your tables regularly to r...
View Full Document

Ask a homework question - tutors are online