C the regionsoutheast partition will contain only

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: . C. The REGION_SOUTH_EAST partition will contain only rows with a NULL value in the current REGION_EAST partition. D. The REGION_SOUTH_EAST partition will be created with storage characteristics inherited from the LOCATIONS table. E. Rows with partitioning keys in the current REGION_EAST partition not included in the VALUES clause will be stored in the REGION_SOUTH_EAST partition. Answer: E Explanation: If you are splitting a partition, the list of values in the VALUES clause applies to the first partition defined. All the remaining states not included in the VALUES clause will be included in a new partition called REGION_SOUTH_EAST. Incorrect Answers A: The REGION_SOUTH_EAST partition will stay in the same tablespace where REGION_EAST partition is located. Only the REGION_NORTH_EAST partition will be created in the TBS2 tablespace. B: The statement will not fail. The REGION_SOUTH_EAST partition will keep all values of REGION_EAST partition not included into the REGION_NORTH_EAST partition. C: The REGION_SOUTH_EAST partition will keep all values of REGION_EAST Actualtests.com - The Power of Knowing 1Z0-030 partition not included into the REGION_NORTH_EAST partition, but it will not store rows with a NULL value in the current REGION_EAST partition.. D: The REGION_SOUTH_EAST partition will not use the storage characteristics inherited from the LOCATIONS table. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 134-136 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 102-108 Chapter 4: New Oracle9i Database DDS and Data-Warehouse Features QUESTION 3: What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File? A. The filename format B. Information stored inside a data dictionary table C. Information stored in the ALERT.LOG file for the corresponding instance D. Information stored inside the corresponding initialization parameter file for the instance Answer: A Explanation: Oracle will use naming conventions when it creates the OMF files. In this naming convention, %t represents the tablespace name, %u is a unique 8-character string, and %g stands for the redo log group number. Incorrect Answers B: Oracle will create a locally managed tablespaces, so information about a datafile will not be stored inside a data dictionary table. C: Oracle does not use ALERT.LOG file to store information about datafiles. It just keep log of database events and database structure changes. D: Initialization parameter file will not be used to store this information. Oracle reads this file to set initialization parameters to start the instance. The structure of the database is stored inside control files. Oracle uses them to mount and open the database. OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 153-160 Chapter 3: Manageability Enhancements Oracle 9i New Features, Robert Freeman, p. 2-12 Chapter 1: Oracle9i Database Administration and Management Features QUESTION 4: Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter....
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online