What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
Answer Posted / amit
A clustered index are those which created by user manually
and non clustered are automatically created by oracle server
when we create a primary key or a unique key on a column.
and as many as indexes can be created on table but it will
reduces the performance of the database.
Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
How can you fetch first 5 characters of the string?
how to install mysql? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
where are cookies actually stored on the hard disk? : Sql dba
How do I trace sql profiler?
what are the differences between binary and varbinary? : Sql dba
How would you reference column values before and after you have inserted and deleted triggers?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is the purpose of a sql?
What are the types pl/sql code blocks?
Explain autonomous transaction.
What is cte sql?
What is java sql driver?
What are the different types of a subquery?
What is primary key and unique key?