#823. A table is partitioned on the PROJECTSTART column. You need to create an index with the PROJECTID column as the leftmost portion of the index key followed by the OWNER column. Which index type is required?
#825. The enterprise data warehouse routinely receives data from various production OLTP databases. The database block size on the data warehouse is 8192, and in the OLTP databases it may be 2048,4096 or 8192. The current SGA is 112MB. Oracle9i has the ability to transport tablespaces with different block sizes. Which two parameters are required in order to “plug in” the OLTP tablespaces into the warehouse database? (Choose two.)
#828. The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle9i database greater flexibility in supporting locality preferences. What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?
#830. An index-organized table (lOT) called SPARSE has had many records deleted. Which command reorganizes the lOT so that the empty space is removed, while minimizing the impact for users?
gen. 0.073
Forum
Master braindump