Index

Which of the following is not true for index:

A) is used for fast and random access of records
B) increase the space overhead
C) automatically created on primary key
D) Maximum one index can be created on a table

Thanks a lot in advance

hi again,

this one is easy though.
it is absolutely D because in many heavily queried tables you have more than one index per table for sure.

best regards,

tonci korsano

Quote:

---

Originally Posted by tkorsano

hi again,

this one is easy though.
it is absolutely D because in many heavily queried tables you have more than one index per table for sure.

best regards,

tonci korsano

---

I was confused about C , thanks for the reply, Have a good day