When writing a database application, explain the pros and cons of: 

a. Opening a new connection to the database every time you need to access the database 

b. Opening one connection to the database, and leaving it open

 When a database application accesses the database, and executes a stored procedure or query from JDBC, a ResultSet is returned. Explain why a ResultSet should be parsed into another data structure

 What is a partial dependency, and why are candidate keys useful for identifying them?

 Third Normal Form ensures that there are no transient dependencies. What does this mean?

Answer rating: 100% (QA)

a Opening a New Connection to the Database Every Time You Need to Access the Database Pros Resource Isolation Each operation gets its dedicated connection ensuring that one operations performance or i... View the full answer