When can Hash Cluster used ?
Answer / orawhiz
Hash clusters are better choice when a table is often
queried with equality queries. For such queries the
specified cluster key value is hashed. The resulting hash
key value points directly to the area on disk that stores
the specified rows
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the different oracle database objects?
Why do you create or replace procedures rather that drop and recreate.
What is the parameter mode that can be passed to a procedure?
Explain about your project and its relation to the current job position you are applying to?
How do we get field detail of a table?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is forall Statement ?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is query image?
What is Trace File ?
What are the numeric comparison operations?
What is flashback Query ? And Use ?