0

Java Databse Connectivity

Description: JAVA Database Connectivity Test covers questions of database and how we can connect database with programming language
Number of Questions: 15
Created by:
Tags: Java database connectivity JAVA questions DB connectivity DB questions Server connectivity Java/Oracle /C/C++ Java
Attempted 0/15 Correct 0 Score 0

In which of the following the primary function is to connect java applications to the correct JDBC driver?

  1. JDBC driver manager

  2. JDBC-ODBC bridge

  3. JDBC URL

  4. JDBC

  5. The java 2 ORB


Correct Option: A
Explanation:

It's primary function is to connect java applications to the correct JDBC driver.

Which of the following web application frameworks saves you time by allowing you to view complex applications as a series of basic components?

  1. Events

  2. Java bean

  3. The java 2 ORB

  4. Java struts

  5. Java applet


Correct Option: D
Explanation:

This web application framework saves you time by allowing you to view complex applications as a series of basic components.

Which of the following drivers is most appropriate on a corporate network where client installations are not a problem?

  1. JDBC-ODBC bridge ODBC driver

  2. JDBC-ODBC bridge

  3. JDBC-Net pure java driver

  4. Transaction

  5. JDBC URL


Correct Option: A
Explanation:

This driver is most appropriate on a corporate network where client installations are not a problem.

Which of the following driver coverts JDBC calls into calls on the client application programming interface for Oracle, Sybase etc?

  1. Alarm

  2. JDBC URL

  3. Native-API partly java driver

  4. JDBC-Net pure java driver

  5. JDBC-ODBC bridge


Correct Option: C
Explanation:

This driver converts JDBC calls into calls on the client application programming interface for Oracle, Sybase etc.

Which one of the following has a group of methods, which sets the value of IN parameters?

  1. Trader

  2. PreparedStatement

  3. Statement

  4. Stock

  5. Next()


Correct Option: B
Explanation:

It has a group of methods, which sets the value of IN parameters.

Which of the following distributed objects in the distributed stock application presents the alarm going off to the user?

  1. StockHelper.java

  2. Events

  3. StockPresentation

  4. AlarmPresentation

  5. Alarm


Correct Option: D
Explanation:

This distributed object in the distributed application presents the alarm going off to the user.

Which of the following methods is used to access data from the ResultSet rows?

  1. getInputStream()

  2. getXXX()

  3. executeQuery()

  4. next()

  5. statement


Correct Option: B
Explanation:

This method is used to access data from the ResultSet rows.

Which of the following EJB architecture roles is a domain expert who composes applications that use enterprise beans?

  1. Application assembler

  2. Enterprise bean provider

  3. Deployment descriptor

  4. EJB specification

  5. TextEvent


Correct Option: A
Explanation:

This EJB architecture role is a domain expert who composes applications that use enterprise beans.

To establish a connection with a database, you need to register the ODBC-JDBC driver by calling____________.

  1. stock

  2. forName()

  3. next()

  4. executeQuery()

  5. getInputStream()


Correct Option: B
Explanation:

To established a connection with a database, you need to register the ODBC-JDBC driver by calling this method.

Which of the following techniques mixes simple and advanced features together and it has complex options even for simple queries?

  1. JDBC URL

  2. JDBC

  3. ODBC

  4. JDBC-ODBC bridge

  5. Event


Correct Option: C
Explanation:

This technique mixes simple and advanced features together and it has complex options even for simple queries.

Which of the following mapping is the work of an industry consortium known as the OMG?

  1. StockPresentation

  2. Java applet

  3. The java 2 ORB

  4. WebSphere

  5. Java IDL


Correct Option: E
Explanation:

Java IDL mapping is the work of an industry consortium known as the OMG.

Which of the followings provides some confidence that JDBC drivers will run your program?

  1. StockHelper.java

  2. JDBC driver test suite

  3. JDBC-ODBC bridge

  4. JDBC

  5. JDBC URL


Correct Option: B
Explanation:

It provides some confidence that JDBC drivers will run your program.

Which of the following drivers allows a direct call from the client machine to the database management server?

  1. Native-protocol pure java driver

  2. The java 2 ORB

  3. JDBC URL

  4. JDBC-ODBC bridge

  5. JDBC-Net pure java driver


Correct Option: A
Explanation:

This driver allows a direct call from the client machine to the database management server.

Which of the following is used to describe a set of technologies, eliminate page refreshes every time there is user input?

  1. Naming

  2. Abstract window toolkit

  3. The java 2 ORB

  4. Java applet

  5. Ajax


Correct Option: E
Explanation:

Ajax is used to describe a set of technologies, eliminate page refreshes every time there is user input.

Which of the following methods executes an SQL statement that may return multiple results?

  1. stock

  2. getInputStream()

  3. execute()

  4. executeQuery()

  5. next()


Correct Option: C
Explanation:

This method executes an SQL statement that may return multiple results.

- Hide questions