#52. 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?
#54. Oracle9i provides a database package called dbms_redefinition to perform an online rebuild of a table. Which two steps are you recommended to do prior to issuing the dbms_redefinition_start_redef table procedure call? (Choose two).
#55. An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?
#60. You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table, or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible?
gen. 0.082
Forum
Master braindump