can we define indexes on a foreign key? Explain pros and
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|
How java can be connected to a database?
What is the role of class.forname while loading drivers?
Write an sql to find all records having all numeric characters in a field ?
What is jdbc architecture in java?
What do you mean by two phase commits?
Which type of driver is unique in jdbc?
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?
What is jdbc and explain jdbc architecture?
What is the JDBC?
What is resultset in jdbc with example?
What are JDBC statements?
Why we use while rs next ())?