solidariti
01-17-2007, 05:12 PM
I had an exam last week which had the following questions in it, and I was wondering if anyone can expand on my answers?
I have tried searching and reading books but I can't seem to find an answer that completly and succinctly answers them, any help will be greatly appreciated. I include some of my answers, if there isn't an answer for a question it means that I didn't answer it. DOH!
Q1. Briefly outline the typical roles of a database, a database management system and an application program in an integrated solution to a problem involving persistent data.
Answer: A DBMS is a software system to manage a collection of shared data, providing each user with a tailored view of the data, together with tools for a controlled approach to data entry, modification, removal, query, report generation and application development.
Q2: Describe and contrast the Embedding and API (Application Programming Interface) approaches to developing applications using a Database Management System. An API may also be known as a Call Level Interface (CLI).
not sure about this one
Q3: Outline the role of a driver in the JDBC architecture.
Answer: JDBC accomplishes its goals through a set of Java interfaces, each implemented differently by individual vendors. The set of classes that implement the JDBC interfaces for a particular database engine is called a JDBC driver. In building a database application, you do not have to think about the implementation of these underlying classes at all; the whole point of JDBC is to hide the specifics of each database and let you worry about just your application.
Q4: Outline the role of a ResultSet instance in the JDBC architecture.
Answer: A table of data representing a database result set, which is usually generated by executing a statement that queries a database. It is what is returned in response to a query. It contains the set of results (rows) which can be iterated through.
Q5: Describe the role that a server plays in a simple 3-tiered architecture for the provision of web-based services.
Not to sure
Thank you in advance
I have tried searching and reading books but I can't seem to find an answer that completly and succinctly answers them, any help will be greatly appreciated. I include some of my answers, if there isn't an answer for a question it means that I didn't answer it. DOH!
Q1. Briefly outline the typical roles of a database, a database management system and an application program in an integrated solution to a problem involving persistent data.
Answer: A DBMS is a software system to manage a collection of shared data, providing each user with a tailored view of the data, together with tools for a controlled approach to data entry, modification, removal, query, report generation and application development.
Q2: Describe and contrast the Embedding and API (Application Programming Interface) approaches to developing applications using a Database Management System. An API may also be known as a Call Level Interface (CLI).
not sure about this one
Q3: Outline the role of a driver in the JDBC architecture.
Answer: JDBC accomplishes its goals through a set of Java interfaces, each implemented differently by individual vendors. The set of classes that implement the JDBC interfaces for a particular database engine is called a JDBC driver. In building a database application, you do not have to think about the implementation of these underlying classes at all; the whole point of JDBC is to hide the specifics of each database and let you worry about just your application.
Q4: Outline the role of a ResultSet instance in the JDBC architecture.
Answer: A table of data representing a database result set, which is usually generated by executing a statement that queries a database. It is what is returned in response to a query. It contains the set of results (rows) which can be iterated through.
Q5: Describe the role that a server plays in a simple 3-tiered architecture for the provision of web-based services.
Not to sure
Thank you in advance