JDBC driver types
Describe briefly the four JDBC driver types which Sun defines?
Expert
Type 1 drivers offer a bridge between ODBC and java. Type’s 2-4 drivers are written completely in Java; however differ as to how they connect to the DBMS. Type 2 drivers mainly rely on the DBMS product for inter-machine communication, when any. Type 3 drivers mainly translate JDBC calls into a DBMS-independent network protocol. Type 4 drivers mainly translate JDBC calls into a DBMS-dependent network protocol.
What is the archtetype or instance pattern?
Write brief note on E.F. Codd, and why is he noteworthy in the development of modern database systems?
Specify the data units at the different layers of TCP / IP protocol suite?
Write about stage administrator and manager?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
State the steps for “this message could not delete” from the particular tables?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Specify the different Multidimensional analysis methods which are available in the Business Objects?
What do you understand by the term cascading update in DBMS?
What does web mining mean
18,76,764
1938269 Asked
3,689
Active Tutors
1455776
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!