What Is The Purpose Of A Cluster?

1.	What Is The Purpose Of A Cluster?
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. 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.

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.

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.

Discussion

No Comment Found

Related InterviewSolutions

How To Create An Oracle Database?
How To Start Oracle Sql Developer?
Is Oracel Sql Developer Written In Java?
What Is The Reports View In Oracle Sql Developer?
What Do You Think About Oracle Sql Developer?
What Is An Anonymous Block?
How To Declare A Local Variable?
How To Initialize Variables With Default Values?
How To Assign Values To Variables?
What Are The Arithmetic Operations?