Oracle SQL Question:

Download Job Interview Questions and Answers PDF

Explain What is the purpose of a cluster?

SQL Oracle Interview Question
SQL Oracle Interview Question

Answer:

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.

it's a temporary and logical memory allocation where we can put several tables.

Download SQL Oracle Interview Questions And Answers PDF

Previous QuestionNext Question
Select the Nth lowest value from a table?Explain Difference between procedure and function.?