Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


can we define indexes on a foreign key? Explain pros and
cons?



can we define indexes on a foreign key? Explain pros and cons?..

Answer / sangeeta

Yes,Ofcourse we can very well define indexes on a foreign
key but only the category - non clustered index. As
clustered index can be defined only on primary key.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More JDBC Interview Questions

How java can be connected to a database?

0 Answers  


What is the role of class.forname while loading drivers?

0 Answers  


Write an sql to find all records having all numeric characters in a field ?

0 Answers  


What is jdbc architecture in java?

0 Answers  


What do you mean by two phase commits?

0 Answers  






Which type of driver is unique in jdbc?

0 Answers  


What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?

1 Answers   AppLabs,


What is jdbc and explain jdbc architecture?

0 Answers  


What is the JDBC?

0 Answers  


What is resultset in jdbc with example?

0 Answers  


What are JDBC statements?

2 Answers  


Why we use while rs next ())?

0 Answers  






Categories