Performance Issues

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Performance Issues

For performance reasons, the LDAP directory server should be in the same LAN as Derby. Derby does not cache the user's credential information locally and thus must connect to the directory server every time a user connects.

Connection requests that provide the full DN are faster than those that must search for the full DN.

(Continued on next question...)

Other Job Interview Questions

• SQL and JDBC ResultSet/Cursor Mechanisms
• What is external Directory Service
• What is Exclusive Locks?
• What is Lock Granularity?
• Dynamic Changes to Jar Files or Database Jar Class Path
• What is Statements?
• How to deploying the Database on the Read-Only Media?
• Derby Security Features
• How to Configure Deadlock Detection and Lock Wait Timeouts
• Multi-User Database Access
• More...