NEW
Font size
WorksheetsAJP Vidyalankar Polytechnic CHP 5 Part 3
Total questions: 48
Worksheet time: 24mins
For execution of INSERT SQL query in JDBC, ............. method must be used.
executeUpdate()
executeStatement()
executeQuery()
Execute()
For execution of SELECT SQL query in JDBC, _________________ method must be used.
executeQuery()
Execute()
executeUpdate()
executeAll()
forName is a _______________________ type method
Static
Dynamic
getConnection() method is of which class
DriverManager
Statement
Connection
None of above
How many JDBC driver types are available by sun Microsystem?
6
4
5
3
If a PreparedStatement is a SQL SELECT statement, you execute the statement using ________.
PreparedStatement.execute();
Statement.executeQuery();
PreparedStatement.executeQuery();
PreparedStatement.executeUpdate();
If you need to use a stored procedure with output parameters, which of the following statement type should be used to call the procedure?
CallableStatement
PreparedStatement
Statement
ProcedureStatement
In 2-tier architecture, the first tier is generally ___________________
GUI
Server
Client
database
In the following JDBC drivers which is known as partly java driver?
Pure-Java Driver
JDBC-net Pure Java
JDBC driver
Native-API driver
In the three-tier model the middle tier of the services acts as a mediator between ________________________ and _________________.
Java application and databases
Client and Server
Java application and client
Java application and server
JDBC is a --------------------- interface, which means that it is used to invoke SQL commands directly.
high level
low level
middle level
top level
JDBC Stands for
Java Database Connection
Java Database Connectivity
JDBC-ODBC bridge product provide _________ access via ___________.
JDBC driver, JDBC drivers
ODBC drivers, JDBC driver
JDBC driver, ODBC drivers
Methods of ResultSet() throws ____________
IOException
Exception
DatabaseException
SQLException
Name the type number of driver belongs to JDBC ODBC Bridge driver?
Type 1
Type 2
Type 3
Type 4
Native API converts ___________into the __________ used by DBMS.
Native API calls, JDBC API
JDBC API, Native API calls
Native – protocol pure Java converts ……….. in to the ………… used by DBMSs directly.
JDBC calls, network protocol
Native API calls,JDBC API
ODBC Drivers are platform _______________
Dependent
Independent
Both a and b
None
JDBC Driver are platform ________________
Dependent
Independent
Both
None
ODBC requires configuring _______ which represents the target database.
Data String Name
Data Source Name
Domain Name
Database name
The PreparedStatement__________symbol is placeholder that is replaced by the input parameter at seen time.
?
*
&
#
The ResultSet __________________provides methods for retrieving and manipulating the results of executed queries.
Statement
Package
Class
Interface
The Type 3 architecture is _______________________
JDBC-Net pure Java
JDBC-ODBC Bridge Driver
Native API partly Java driver
Native Protocol Pure-Java Driver
The_____________________ is the language for interacting with Database.
Structured Query Language
Data Manipulation Language
Data Definition Language
Stored Query Language
Type 1 driver is also known as
Native API partly Java driver
Native Protocol Pure-Java Driver
JDBC-ODBC Bridge Driver
JDBC-Net pure Java
Type 3 driver is also known as_________________
JDBC-net Pure Java / Network Protocol
JDBC-Net pure Java
Native API partly Java driver
Native Protocol Pure-Java Driver
Type II JDBC driver is also known as __________________.
JDBC-net Pure Java
JDBC-Net pure Java
Native API partly Java driver
Native Protocol Pure-Java Driver
Type IV JDBC driver is also known as __________________
JDBC-net Pure Java
JDBC-Net pure Java
Native API partly Java driver
Native Protocol Pure-Java Driver
Type4 driver is also known as:
100% Pure Java
DBC-net Pure Java
JDBC-Net pure Java
Native API partly Java driver
Where the object of ResultSet maintains a cursor?
Second Row
First Row
Last Row
Middle Row
Which class is used to connect java application to JDBC driver
DriverManager
Connection
Statement
ResultSet
Which driver is called as a thin driver in JDBC?
Type-2 Driver
Type-3 Driver
Type-1 Driver
Type-4 Driver
Which interface provides methods to execute queries with the database?
Statement interface
Connection
Resultset
DriverManager
Which Interface is used to execute dynamic SQL statements?
PreparedStatement
Statement
CallableStatement
Procedurestatement
Which is default ResultSet type?
TYPE_SCROLL_SENSITIVE
TYPE_SCROLL_INSENSITIVE
TYPE_FORWARD_ONLY
TYPE_SCROLL_FIRST
Which JDBC driver Type (s) can be used in either applet or servelt code?
Type 2
Type 3
Type 4
Both Type 3 and Type 4
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
Type 3
Type 2
Type 4
Both Type 3 and 4
Which JDBC driver Types are used for over communications networks?
Type 2
Type 3
Type 4
Both Type 3 and Type 4
Which method is used to obtain count of total rows of ResultSet
getRow()
getrow()
GetRow()
Row()
Which method is used to perform DML statements in JDBC?
executeQuery()
execute()
executeUpdate()
executeAll()
Which method of class is used to register & dynamically load the driver class?
forName()
DeviceManager
Statement
Resultset
which of the following function is used to find the column count of the particular ResultSet ?
getColumnCount()
getRow
getcolumnCount()
getcolumncount()
Which of the following invokes functions in sql?
Callable statements
Prepared Statement
Procedure Statement
Statement
Which type of driver converts JDBC calls into the network protocol used by the database management system directely
Type 4
Type 3
Type 2
Type 1
Which type of driver is unqiue in JDBC?
Native Protocol Pure-Java Driver
JDBC-Native API
Native API partly Java driver
JDBC-ODBC Bridge Driver
_______ calls get converted into native C or C++ API calls.
Native Protocol Pure-Java Driver
JDBC-Native API
Native API partly Java driver
JDBC-ODBC Bridge Driver
___________ interface allows storing results of query?
ResultSet
Connection
Statement
DriverManager
All raw data types including binary documents or images should be read and uploaded to the database as an array of ….
Byte
Int
String
Array
