Question 26 :
How can you rebuild an index?
Question 27 :
Explain what partitioning is and what its benefit is.
Partitioning is a method of taking large tables and indexes and splitting them into smaller, more manageable pieces.
Question 28 :
You have just compiled a PL/SQL package but got errors, how would you view the errors?
Question 29 :
How can you gather statistics on a table?
The ANALYZE command.
Question 30 :
How can you enable a trace for a session?
Use the DBMS_SESSION.SET_SQL_TRACE or
Use ALTER SESSION SET SQL_TRACE = TRUE;