Question 177 You need to create the ORDERS table that will contain the order information. The table will have millions of rows and there will be a large number of inserts, deletes, and updates in the table. You must ensure that there is: - No fragmentation in the table - Minimal contention in the table What would you do while creating the table?
set PCTFREE to 0 for the table
set PCTINCREASE to zero for the table
place the table in a dictionary-managed tablespace with a large number of free lists for the table
place the table in a locally managed tablespace that has automatic segment space management
Want to practice for 1Z0-031 - Oracle9i Database: Fundamentals I ?