Explain What is the purpose of a cluster?
Submitted by: AdministratorOracle 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.
Submitted by: Administrator
it's a temporary and logical memory allocation where we can put several tables.
Submitted by: Administrator
Read Online Oracle SQL Job Interview Questions And Answers
Top Oracle SQL Questions
| ☺ | Explain Difference between an implicit and an explicit cursor? |
| ☺ | Explain What is difference between SUBSTR and INSTR? |
| ☺ | Explain What are various joins used while writing SUBQUERIES? |
| ☺ | Explain Difference between procedure and function.? |
| ☺ | Explain What is an UTL_FILE.What are different procedures and functions associated with it? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Oracle RMAN Interview Questions. |
