E queries that use an index to select migrated rows

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: ts separately. E: Queries that use an index to select migrated rows will not perform additional I/O, because row fits one database block. To select chained rows queries will perform more I/O operations to retrieve all data they need. Actualtests.com - The Power of Knowing 1Z0-024 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 915-916. Chapter 19: Tuning Disk Utilization QUESTION 37: What are three indications of contention for this rollback segment header? (Choose three) A. A nonzero value in the WAITS column of the V$ROLLSTAT view B. A nonzero value in the UNDO HEADER column of the V$WAITSTAT view C. A nonzero value in the ROLL_SEG_WAITS column of the V$RLLSEGS view D. A nonzero value in the UNDO_HEADER_WAITS column of the V$ROLLBACK_SEGS view E. A nonzero value in the Undo Segment To Slot event of the V$SYSTEM_EVENT view Answer: A, B, E Explanation: A nonzero value in the WAITS column of the V$ROLLSTAT view, a nonzero value in the UNDO_HEADER column of the V$WAITSTAT view and a nonzero value in the Undo Segment Tx Slot event of the V$SYSTEM_EVENT view indicate contention for the rollback segment header. Incorrect Answers: C: There is no V$ROLLSEGS view in Oracle. D: There is no V$ROLLBACK_SEGS view in Oracle. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 904-911. Chapter 19: Tuning Disk Utilization QUESTION 38: When tables are stored in locally managed tablespaces, where is extent allocation information stored? A. Memory B. Data dictionary C. Temporary tablespace D. Corresponding tablespace itself Answer: D Explanation: Extent allocation information is stored in corresponding tablespace itself, if tables are stored in locally managed tablespace. Incorrect Answers: A: Extent allocation information is not stored in memory for locally managed tablespaces. B: Extent allocation information is stored in data dictionary if tables use data-dictionary managed tablespaces. Oracle use data-dictionary managed tablespaces by default. Actualtests.com - The Power of Knowing 1Z0-024 C: Extent allocation information is NEVER stored in temporary...
View Full Document

Ask a homework question - tutors are online