Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered, non-clustured and unique index. How many
indexes can be created on a table ?
- 3 Answers
- 11740 Views
- TCS, I also Faced
- E-Mail Answers
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 many types of normalization are there?
What are the two types of exceptions in pl/sql?
Are pl sql variables case sensitive?
Why do we use sql constraints?
What do we need to check in database testing?
how to select unique records from a table? : Sql dba
Explain what is sql*plus?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is percent sign in sql?
What does select * from mean in sql?
What is the purpose of the partition table?
What can you do with pl sql?
What is sql key?
What is rownum in sql?
What type of join is sql join?
