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 |
How do find debugging problems related to JDBC API?
wa is connection pooling? how do u create connection pooling?wat is use connection pooling?
Does jdbc require oracle client?
Does JDBC support stored procedures?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
What are the advantages of collection pools?
Is JDBC a language or Application?
How do I retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
Explain about column name and getter method?
How to find number of records in result set?
What is the difference between jdbc and odbc?
How do I start debugging problems related to the JDBC API?