Set - 9

Question 26 :

How can you rebuild an index?

Answer :

ALTER INDEX REBUILD;


Question 27 :

Explain what partitioning is and what its benefit is.

Answer :

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?

Answer :

SHOW ERRORS


Question 29 :

How can you gather statistics on a table?

Answer :

The ANALYZE command.


Question 30 :

How can you enable a trace for a session?

Answer :

Use the DBMS_SESSION.SET_SQL_TRACE or
Use ALTER SESSION SET SQL_TRACE = TRUE;