What is the purpose of a cluster?
Answer / nishi
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
what is the scenario where you take the database to NoArchivelog mode?
How to load data from external tables to regular tables?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Can you have more than one content canvas view attached with a window ?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
What is OCI. What are its uses?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to pass parameters to procedures?
What is flashback in Oracle?