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
- 11870 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
What is sql keyword?
What is a constraint?
What is the purpose of cursors in pl/sql?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can we rollback after truncate?
How do you update sql?
Differentiate between % rowtype and type record.
What is a temporal data type?
Why do we use set serveroutput on?
What is the difference between nvl function, ifnull function, and isnull function?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is full join in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
What is input buffer in sql*plus?
what does myisamchk do? : Sql dba
