Semester-5 Advance Java Programming (4351603)
ASSIGNMENT
UNIT – 2 JAVA DATABASE CONNECTIVITY
Unit-2 Distribution of Theory Marks
R Level U Level A Level Total Marks
Java Database Connectivity
4 3 3 10
Legends: R = Remember, U = Understanding, A = Apply and above, BTL = Bloom's Taxonomy Level
UOs = Unit Outcomes, COs = Course Outcomes
No. Question UOs BTL
Explain one-tier, two-tier and three-tier database design
1. 2.1 U
architecture.(with figure and advantages- disadvantages)
2. Five difference between two-tier and three-tier architecture. 2.1 U
3. Which package is used to perform almost all JDBC operations? 2.2 R
4. What is JDBC API? List JDBC API components. Describe in brief. 2.2 U
5. List and explain components of JDBC. 2.2 U
6. Give advantages and disadvantages of JDBC. 2.3 U
7. Define following. 2.4 R
Driver Interface
Connection Interface
Statement Interface
ResultSet Interface
DriverManager Class
8. List JDBC Drivers. Explain JDBC to ODBC bridge driver(Type-1). 2.4 U
9. Explain Native API, part Java Driver(Type-2). 2.4 U
10. Explain JDBC – net pure java drivers (Type-3). 2.4 U
11. Explain Pure Java Driver (Type-4). 2.4 U
12. Explain transaction processing. 2.4 U
13. Write the steps to develop a JDBC application with proper example. 2.6 A
Explain in brief. JDBC Prepared statement. Explain how to use
14. 2.4 A
Prepared Statement to execute parameterized queries with example.
15. What are common JDBC Exceptions? 2.4 U
16. Explain ORM working model with advantages. 2.7 U
17. What is hibernate? Explain architecture of hibernate. 2.8 U
Prepared by Khyati Vaghela 1
Semester-5 Advance Java Programming (4351603)
18. Describe hibernate installation steps for IDE. 2.8 U
19. Differentiate between Hibernate and JDBC. 2.8 U
Explain the significance of the hibernate.cfg.xml file in defining
20. 2.9 A
Hibernate properties.
Khyati Vaghela
Subject Coordinator & Head
Prepared by Khyati Vaghela 2
