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 |
What is ODBC and JDBC? How do you connect the Database?
How is database middleware used to access legacy databases?
What is the difference between execute, executeQuery, executeUpdate?
How transactions are performed using JDBC ?
Explain the various types of locking system in jdbc?
How can we store and retrieve images from the database?
What are the packages are used in jdbc?
Why can't Tomcat find my Oracle JDBC drivers in classes111.zip?
What is jdbc class forname?
Can you create an index on sex column where there is M or F?
What is database deadlock ?
What is jdbc? Describe the steps needed to execute a sql query using jdbc.