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 |
What is a data dictionary and how can it be created?
How does Oracle guarantee data integrity of data changes?
Which database is better for os platform dependency?
Explain the different normalization forms?
How to use group functions in the select clause using oracle?
How to update values in a table in oracle?
How to write date and time interval literals in oracle?
What is meant by a deadlock situation?
How many types of segments in Oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What is the diff between Oracle and SQL Server
Difference between open_form and call_form in oracle.