What is Index Cluster ?
Answers were Sorted based on User's Feedback
Answer / swapna
we can create Index on clusters.
syntax: create index<i_name> on cluster(cluster_name);
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / nishi
A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an oracle database table?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the attributes of the cursor?
What to do if the startbd.bat failed to start the xe instance?
How to view existing locks on the database?
where do i find oracle interview questions.
can a view be updated?
What are privileges and grants?
What is raw datatype?
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?
What are joins, explain all types of joins?
What is meant by recursive hints in oracle?