Today, I had quiz like below!!

But, I don\'t know answers exactly!!

anybody helps me ?!! Please.

I want to know right answers~



Pleaseanswer the following questions in your own words. All questions are worth 5points each. Each question can/should be answered in less than 100 words.Best of luck.

 

1)     You are working as a database architect for yourorganization. An application programmer that uses your database has aperformance problem. The application she is writing has a looping structurethat fires off a SQL statement for each looping iteration. In each SQL statement,only the WHERE statement is altered. What would be your recommendation to her?

 

2)     In class we discussed Logical Units of Work (LUW) andtransaction management. How many logical units of work can you have in a storedprocedure? Also, discuss transaction management and how LUW(s) relate totriggers.

 

3)     Your organization is developing a Java application thatwill connect to the database you\'ve written. This Java application is non-webbased and will run on individual workstations. Each of these workstations willNOT have database client software, and cannot be configured to use ODBC. Whichlevel Java database driver to you recommend? Explain.

 

4)     In class we discussed object and system levelpermissions. Discuss what the \'default\' access is for tables, and an acceptedencapsulation technique for table access as far as SQL DELETE, UPDATE, andINSERTs are concerned.

 

5)     In class we used ADO to connect to the databases wecreated. Name and discuss three ADO classes we used. In addition, which ADOclass did we use to pass values in and out of stored procedures?