Q.1)
|
Driver types are used to categorize the technology used to connect to the database.
| ||
Q.2)
|
This is an Application Programming Interface provided by Microsoft for access the database.It uses SQL as its database language.
| |||
Q.3)
|
JDBC is ODBC translated into an object-oriented interface that is natural for java programmiers.
| ||
Q.4)
| ||||
Q.5)
|
The Type 1 driver is also known as JDBC-ODBC bridge plus ODBC driver.
| ||
Q.6)
|
This method is use to execute any SQL statement with a "SELECT" clause, that return the result of the query as a result set.
| |||
Q.7)
|
This method is used to execute INSERT, DELETE, UPDATE ,CREATE, DROP Table and other sql DDL.
| ||
Q.8)
|
This method is used for retrieving a string value (SQL type VARCHAR) and assigning into java String object.
| |||
Q.9)
|
This method is used for retrieving the value from current row as object.
| ||
Q.10)
|
A client application uses stored procedures increases the network traffic, but it reduces the number of times a database is accessed.
| |||
Q.11)
|
This parameter is used to pass values into a store procedure.The value pf this parameter cannot changed or reassigned within the module and hence is constant.
| ||
Q.12)
|
OUT Parameter.
| |||
Q.13)
|
This Parameter behaves like an initialized variable.
| ||
Q.14)
|
This object does not contain the stored procedure itself but contains only a call to the stored procedure.
| |||
Q.15)
|
It reefers to the ability to move backward as well as forward through a result set.
| ||
Q.16)
|
This refers to the ability to check whether the cursor stays open after a COMMIT.
| |||
Q.17)
|
The prepareStatment() method sends SQL query to the database. and this returns:
| ||
Q.18)
|
The CallableStatment object contains the SQL statments.
| |||
Q.19)
|
A cursor that can only be used to process from the beginning of a ResultSet to the end of it.It is default type.
| |
Đáp Án DBSJ (Answer)
Link (Mediafire)
| ||
