|Hypertext Markup LanguageCascading Style SheetsExtensible Markup LanguageJava ScriptjQueryAngularJSOracle SQLOracle PL/SQLOracle D2K FormsOracle D2K ReportsOracle DatabaseJavaJava Database ConnectivityJava ServletJava Server PagesHibernateApache TomcatCC++PHPMy-SqlUnix/LinuxMS-DOSHR Interviews|
|What is Connection?|
|Connection class represents a connection (session) with a specific database. SQL statements are executed and results are returned within the context of a connection. Connection object's database is able to provide information describing its tables, its supported SQL grammar, its stored procedures, the capabilities of this connection, and so on. This information is obtained with the getMetaData method.|
Thanks for your comment.!
Write a comment(Click here) ...
|What is JDBC?|
|JDBC technology is an API that provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular datasources, such as spreadsheets or flat files. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment.|
|What is JDBC Driver ?|
|The JDBC Driver provides vendor-specific implementations of the abstract classes provided by the JDBC API. This driver is used to connect to the database.|
|What are the steps required to execute a query in JDBC?|
|First we need to create an instance of a JDBC driver or load JDBC drivers, then we need to register this driver with DriverManager class. Then we can open a connection. By using this connection , we can create a statement object and this object will help us to execute the query.|
|What is DriverManager ?|
|DriverManager is a class in java.sql package. It is the basic service for managing a set of JDBC drivers.|
|What is a ResultSet ?|
|A table of data representing a database result set, which is usually generated by executing a statement that queries the database. ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set.|
|What does Class.forName return?|
|class as loaded by the classloader.|
|What is Connection pooling?|
|A Connection pooling is a technique used for sharing server resources among requesting clients. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains a pool of open database connections.|
|What are the different JDBC drivers available?|
There are mainly four type of JDBC drivers available.
Type 2: Native API Partly Java Driver- A native-API partly Java technology-enabled driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or otherDBMS. Note that, like the bridge driver, this style of driver requires that some binary code be loaded on each client machine.
Type 3: Network protocol Driver- A net-protocol fully Java technology-enabled driver translates JDBC API calls into a DBMS-independent net protocol which is then translated to a DBMS protocol by a server. This net server middleware is able to connect all of its Java technology-based clients to many different databases. The specific protocol used depends on the vendor. In general, this is the most flexible JDBC API alternative. It is likely that all vendors of this solution will provide products suitable for Intranet use. In order for these products to also support Internet access they must handle the additional requirements for security, access through firewalls, etc., that the Web imposes. Several vendors are adding JDBC technology-based drivers to their existing database middleware products.
Type 4: JDBC Net pure Java Driver - A native-protocol fully Java technology-enabled driver converts JDBC technology calls into the network protocol used by DBMSs directly. This allows a direct call from the client machine to the DBMS server and is a practical solution for Intranet access. Since many of these protocols are proprietary the database vendors themselves will be the primary source for this style of driver. Several database vendors have these in progress.
|Which is the fastest type of JDBC driver?|
Type 4 (JDBC Net pure Java Driver) is the fastest JDBC driver. Type 1 and Type 3 drivers will be slower than Type 2 drivers (the database calls are make at least three translations versus two), and Type 4 drivers are the fastest (only one translation).
|Is the JDBC-ODBC Bridge multi-threaded?|
|No. The JDBC-ODBC Bridge does not support multi threading. The JDBC-ODBC Bridge uses synchronized methods to serialize all of the calls that it makes to ODBC. Multi-threaded Java programs may use the Bridge, but they won't get the advantages of multi-threading.|
|How do you handle your own transaction ?|
|Connection Object has a method called setAutocommit ( boolean flag) . For handling our own transaction we can set the parameter to false and begin your transaction . Finally commit the transaction by calling the commit method.|
Swapnil start from his home and walked 35 km towards east, after that he turned to his right and walked 20 km. He again turned to his right and walks 35 km. Finally, he turned to his left and walked 20 km and reached his office. How far is his office from his home?
How many 2 digit numbers are divisible by 6?
|HCF and LCM|
Find the smallest square number which is exactly divisible by 3, 5, 15, 18, 20 and 24?
HCF and LCM of two numbers are 82 and 574 respectively. if one of the numbers is 287, find the second number?
How many numbers between 1200 to 1500 are multiple of 13?
Find the total number of terms in the series : -3, 1, 5, 9,............., 101 ?
Find the sum of the first 20 terms of the series : 8, -3, 11, -6, 14, -12, 17, -24,....... ?
Find the missing term in the given series - 101, 120, 145, 168, (?), 224
Find the missing term in the given series - 11A13, 17E19, (?), 31O37, 41U43
Find the missing term in the given series - 2,4,8,3,9,27,4,16,(?),5,25,125
Which gas is fixed by Rhizobium bacteria present in the root nodules of a pea plant ?
The formation of sulphurous acid involves ?
The acid present in soft drinks is ?
The cathode of a dry cell is made of ?
The number of atoms present in the molecule of an element is known as its?
If the angle of incidence formed by a ray of light on a plane mirror is 37°, then the angle of refraction is?
A dynamo converts ?
If the time taken for hearing the echo of a girl's voice after reflection from a cliff is 6 seconds, calculate the distance of the girl from cliff ?
Institute of Banking Personnel Selection (IBPS) - CRP SPL-IX - 1163 Posts - 26/11/2019 Last date
Reserve Bank of India (RBI) - 199 Posts - 11/10/2019 Last date
Life Insurance Corporation of India (LIC) - 7942 Posts - 01/10/2019 Last date
State Bank of India (SBI) - CRPD/APPR - 700 Posts - 06/10/2019 Last date
|Jobs in Jharkhand|
Jharkhand Staff Selection Commission (JSSC) -JANMCE - 1985 Posts - 04/10/2019 Last date
|Jobs in Madhya Pradesh|
National Health Mission (NHM) - 1392 Posts - 05/10/2019 Last date
|Jobs in Bihar|
Bihar Vidhan Parishad - 136 Posts - 11/10/2019 Last date
NABARD - 91 Posts - 02/10/2019 Last date
Institute of Banking Personnel Selection (IBPS) - CRP Clerks-IX - 12075 Posts - 09/10/2019 Last date
Haryana State Cooperative Apex Bank Ltd - 978 Posts - 31/08/2019 Last date