DEVFYI - Developer Resource - FYI

What is the purpose of a cluster?

ORACLE Interview Questions and Answers (Part 3)


(Continued from previous question...)

531. What is the purpose of a cluster?

Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However, for the purpose of increasing performance, oracle allows a developer to create a CLUSTER. A CLUSTER provides a means for storing data from different tables together for faster retrieval than if the table placement were left to the RDBMS.

(Continued on next question...)

Other Interview Questions