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

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

Question Posted / guest

1 Answers
4492 Views
I also Faced
E-Mail Answers

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

What is the use of setFetchSize() and setMaxRows() methods in Statement?

0 Answers

How data can be inserted into long row column of database?

0 Answers

How can you make a connection?

0 Answers

What driver should I use for scalable Oracle JDBC applications?

0 Answers

There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

0 Answers

Which jdbc driver type s is are the jdbc odbc bridge?

0 Answers

JDBC Drivers properties?

1 Answers Infosys,

What is execute(), executeUpdate() and executeQuery() methods?

10 Answers

what is JDBC?

3 Answers Wipro,

Can we use the one instance of Statment to execute more than one query ?

2 Answers TCS,

What type of drivers have you used?

1 Answers

Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

0 Answers

For more JDBC Interview Questions Click Here