C it requires fewer space related options than

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: It improves performance and space utilization in a multi-instance environment. C. It requires fewer space related options than freelist managed structures. D. It improves performance for SYSTEM tablespaces where a high degree of concurrency is required Answer: A, B, D Explanation: Managing space with automatic segment-space managed objects can respond to dynamic changes for concurrent access, improves performance and space utilization in a multiinstance environment and improves performance for SYSTEM tablespaces where a high degree of concurrency is required. Incorrect Answers C: It requires more space related options than freelist managed structures. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 53-54 Chapter 2: Oracle9i Architecture Changes QUESTION 51: The EMPLOYEES table has six indexes and DML operations are slow. Which command begins monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan? A. ALTER TABLE employees monitor index employee_idx_fk; B. ALTER INDEX employee_idx_fk monitoring on; C. ALTER TABLE employees monitor all indexes; D. ALTER INDEX employee_idx_fk monitoring usage; Answer: D Explanation: This statement provide correct syntax to start monitoring the EMPLOYEE_IDX_FK index to determine whether it has been used by an execution plan. Actualtests.com - The Power of Knowing 1Z0-030 Incorrect Answers A: This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR INDEX clause with ALTER TABLE command. B: This command requires MONITORING USAGE clause to be used, not MONITORING ON clause. C: This command requires MONITORING USAGE clause with ALTER INDEX command to be used, not MONITOR ALL INDEXES clause with ALTER TABLE command. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 212-214 Chapter 4: Performance and Scalability Enhancements Oracle 9i New Features, Robert Freeman, p. 56-59 Chapter 2: Oracle9i Architecture Changes QUESTION 52: Which two are true regarding automatic space management segments? (Choose two.) A. You can create an automatic space management segment in a dictionary-managed tablespace. B. You can create an automatic space management segment only in a locally managed tablespace. C. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment. D. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment. Answer: B, D Explanation: You can create an automatic space management segment only in a locally managed tablespace. The FREE_BLOCKS procedure refers to the blocks in a segment below the high water mark whose number of rows falls below the PCTUSED attribute, and therefore are candidate for new inserted rows. An automatic space management segment usage eliminates the need to specify the PCTUSED, FREELISTS, and...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online