Com the power of knowing 1z0 030 you can drop a non

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: a list-partitioned table Answer: B, C, E Explanation: Actualtests.com - The Power of Knowing 1Z0-030 You can drop a non-primary key column, change a heap table to an index-organized table and vice versa or change a partitioning method for the table online. Incorrect Answers A: Rows deleting is a DML operation. It's not a table transformation. D: It's not possible to redefine the table online with a LONG column. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 74-83 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes QUESTION 41: Online index rebuild functionality has been extended to include which four index structures? (Choose four.) A. Bitmap indexes B. Reverse key indexes C. Function-based indexes D. Key-compressed indexes on regular tables E. Key-compressed indexes on IOT (including secondary indexes) Answer: B, C, D, E Explanation: It's possible to rebuild reverse key, function-based, key-compressed indexes on regular tables and on IOT (including secondary indexes). Incorrect Answers A: Oracle9i does not currently support online index rebuilding for bitmap or partitioned local and global indexes. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 74-83 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 46-53 Chapter 2: Oracle9i Architecture Changes QUESTION 42: There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice if you want to reduce the impact of long running operations on other users without aborting the long running operations? A. Define user profiles and set the CPU_PER_CALL limit. B. Define a SWITCH_TIME for a plan in the Resource Manager. C. Create a batch job that checks V$SESSION_LONGOPS; the batch job alters the session priority of the long running operations. D. Create a user defined event in the Oracle Enterprise Manager, which monitors Actualtests.com - The Power of Knowing 1Z0-030 V$SESSION_LONGOPS. Answer: B Explanation: You can define a SWITCH_TIME for a plan in the Resource Manager to reduce the impact of long running operations on other users without aborting the long running operations. Incorrect Answers A: You cannot do this with CPU_PER_CALL limit. C: You don't need to use a batch job to check V$SESSION_LONGOPS for this purpose. D: It can be done with a SWITCH_TIME for a plan in the Resource Manager, you don't need to monitor V$SESSION_LONGOPS. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129 Chapter 3: Manageability Enhancements QUESTION 43: Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three.) A. SYNC or ASYNC to identify the network transmission mode B. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby C. AFFIRM or NOAFFIRM to control whether log archiving disk write o...
View Full Document

Ask a homework question - tutors are online