Question 1: State whether the given are true or false:
a) Application layer consists of DriverManager and Driver Class.
b) Statements are anything associated to SQL updates, deletes, queries and so on.
c) Establishing a session is done via connection object.
d) ResultSet class is employed for storing the results.
e) Through JDBC we can cancel various databases.
Question 2: What do you mean by the term database? How it is dissimilar in client server and single tier?
Question 3: Explain the terms DataSource, DriverManager, Driver and Application classes in the JDBC.
Question 4: What does ODBC signifies for? Illustrate the difference between the ODBC and JDBC processing?
Question 5: Create a database with the customer table and item table, and then via JDBC create a JDBC program where we are storing the details of customer and trying out the SQL manipulations such as inserting, deleting and simply extracting.
Question 6: Table the item in the above part requires to be updated by one more item. Do it via Java.