can we define indexes on a foreign key? Explain pros and
cons?
Answer Posted / 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 View All Answers
If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
What is the reason why we need a jdbcrowset like the wrapper around resultset?
What is a jdbc driver and how many jdbc drivers are available?
Discuss the procedure of retrieving warnings?
Explain about the drive manager class working?
What is database connection pooling? Advantages of using a connection pool?
Which type of driver provides jdbc access via one or more odbc drivers?
How do I connect to jdbc?
Discuss the significances of jdbc.
What is JDBC RowSet? What are different types of RowSet?
How can you make a connection?
What does the jdbc connection interface?
How to set the attribute concurrency in resultset?
How many categories of jdbc drivers are there?