B the parameters are specified in the spfile

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: E parameter file. Incorrect Answers A: This column does not show the value of the parameter itself. B: The parameters are specified in the SPFILE parameter file, not in the PFILE parameter file. D: These changes will be saved in the SPFILE parameter file, so they will be active after instance restart also. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 80-83 Chapter 2: Availability Enhancements Oracle 9i New Features, Robert Freeman, p. 35-36 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 71: The TYPE clause used in the creation of an external table defines which access driver is used to convert the data when needed by SQL statements inside the database. Which type of access driver is supported for external tables? A. Import B. ORACLE_LOADER C. Metadata API D. Direct path export Answer: B Explanation: ORACLE_LOADER is the default access driver for external tables. Incorrect Answers A: Import is not the default access driver for external tables. C: Metadata API is not used to convert the data as an access driver. D: External tables are not processed with direct path export. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 131-134 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 111-116 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features QUESTION 72: You are using automatic space-managed segments, and you wish to change the value of PCTFREE for a given table. What can you do to ensure the change is made in the bitmap structure? A. Use the ALTER command, then execute the dbms_space package. B. Use the ALTER command, then execute the dbms_repair.segment_fix_status procedure. Actualtests.com - The Power of Knowing 1Z0-030 C. Use the ALTER command to change the PCTFREE value of automatic spacemanaged segments. D. It is not possible to change the PCTFREE value of automatic space-managed segments. Answer: B Explanation: You use the ALTER TABLE statement to change the PCTFREE value for both FREELIST segments (manual space-managed) and ASM segments. In the case of automatic space-managed tables, the ALTER TABLE command does not update the BMBs. Hence, these blocks may not track the true current status of the datablocks. Oracle9i has added a new procedure called SEGMENT_FIX_STATUS to the DBMS_REPAIR package to fix this problem. Incorrect Answers A: Oracle9i has enhanced the DBMS_SPACE package by adding the SPACE_USAGE procedure to obtain information about the free blocks in automatic space-managed (ASM) segments. But you cannot change the PCTFREE value for the table with this package. C: You cannot change the PCTFREE value of automatic space-managed segments with ALTER command. It can be done with DBMS_REPAIR package. D: It is possible to change the PCTFREE value of automatic space-managed segments with DBMS_REPAIR package. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-142 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 53-54 Chapter 2: Oracle9i Architecture Changes QUESTION...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online