which is responsible for getting a connection to the database?

get which is responsible for getting a connection to the database? from screen.

Which is responsible for getting a connection to the database?

Which is responsible for getting a connection to the database? :Driver, Connection, Statement, ResultSet

Which is responsible for getting a connection to the database? JDBC

Driver Connection Statement ResultSet

Answer: Driver

553 students attemted this question.

Bookmark Add Comment Share With Friends Report

Explanation

No Explanation Available.

Click To Add

Share this question with friends

Facebook Twitter Instagram Linkedin Youtube

Similar Questions

Which of the following describes the correct sequence of the steps involved in making a connection with a database.1. Loading the driver2. Process the results.3. Making the connection with the database4. Executing the SQL statements

Which of the following describes the correct sequence of the steps involved in making a connection with a database.

What is the correct sequence to create a database connection?

"If we change the Database we have to change the native api as it is specific to a database". The above statement resembles ______ driver.

Which method is used to establish the connection with the specified url in a Driver Manager class?

Which driver Network connection is indirect that a JDBC client makes to a middleware process that acts as a bridge to the DBMS server?

Which of the following is not a JDBC connection isolation levels?

Which of the following allows non repeatable read in JDBC Connection?

Which of these obtains a Connection?

To open a connection, DriverManager._____________________() is to be used.

Which of the following encapsulates an SQL statement which is passed to the database to be parsed, compiled, planned and executed?

In Type 2 Driver, JDBC API calls are converted into native _____________ API calls, which are unique to the database

_____________ driver talks with server-side middleware which then talks to the database

In order to transfer data between a database and an application written in the Java programming language, the JDBC API provides which of these methods?

Which models do the JDBC API support for the database access?

Which result set generally does not show changes to the underlying database that are made while it is open. The membership, order, and column values of rows are typically fixed when the result set is created?

Which type of driver converts JDBC calls into the network protocol used by the database management system directly?

Which of the following methods are needed for loading a database driver in JDBC?

Which of the following driver converts the JDBC calls into database-specific calls?

Which class/interface manages a list of database drivers?

Comments

Add Your Review

Your email address will not be published.

स्रोत : mcqpoint.com

Source Code Examples

Which is responsible for getting a connection to the database?

Which is responsible for getting a connection to the database?

JAVA-QUIZ MCQ

Which is responsible for getting a connection to the database?

A. Driver B. Connection C. Statement D. ResultSet

Answer

A. Driver

Explanation:

The Driver interface is responsible for getting a connection to the database, making Option A the answer.

The Connection interface is responsible for communication with the database but not making the initial connection.

The Statement interface knows how to run the SQL query, and the ResultSet interface knows what was returned by a SELECT query

Free Spring Boot Tutorial - 5 Hours Full Course

Watch this course on YouTube at Spring Boot Tutorial | Fee 5 Hours Full Course

java-quiz mcq

Comments

Best Video on YouTube (Most Liked)

Free Spring Boot Projects [ Download]

Spring Boot E-Commerce Project - Shopizer

Spring Boot Angular Project - Reddit Clone Application

Spring Boot ReactJS CRUD Project - Employee Management App

Spring Boot Microservices, Spring Cloud and React Project - BookStoreApp

Spring Boot Angular Project - BookStore App

Spring Boot Angular Petclinic Project

Microservices with Spring Cloud Project

Spring Boot, Spring Cloud Microservice Project - Spring Petclinic App

Spring Boot Microservice Project - Shopping Cart App

Spring Boot Project - User Registration Module

Spring Boot MVC Web Application - Todo App

Spring Boot WebSocket Project - Chat Application

Spring Boot, Spring Security, JWT, React, and Ant Design - Polling App

Spring Boot, Spring Cloud Microservice Project - PiggyMetrics

Spring Petclinic

Spring Boot MVC Project - Blogs Aggregator

Spring Boot Thymeleaf Project - Employee Management System

Spring Boot + Angular Project - Employee Management System

Spring Initializr

ReactJS Spring Boot CRUD Full Stack Application

Spring Boot Project - Sagan

JavaScript Projects

JavaScript Tic Tac Toe Game

JavaScript Project - Modal Box

JavaScript Calculator Project

JavaScript Project - Password Generator

JavaScript Project - Weather App

JavaScript Project - Todo App

JavaScript Project - Notes App

JavaScript Project - Movie App

JavaScript Project - Drawing App

JavaScript Project - Countdown Timer

Submit Source Code Example

Submit Source Code Example

स्रोत : www.sourcecodeexamples.net

JDBC Quiz

Take this JDBC Quiz to test your self JDBC knowledge.

JDBC Quiz - Multiple Choice Questions

author: Ramesh Fadatare

java quiz jdbc

Take this JDBC Quiz to test your self JDBC knowledge.

JDBC stands for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

Learn complete JDBC at https://www.javaguides.net/p/jdbc-tutorial.html.

1. What must be the first characters of a database URL?

A. db, B. db: C. jdbc, D. jdbc:

Answer

D. jdbc:

Explanation: All JDBC URLs begin with the protocol jdbc followed by a colon as a delimiter. Option D is the only one that does both of these, making it the answer.

2. Which of these obtains a Connection?

A. Connection.getConnection(url)

B. Driver.getConnection(url)

C. DriverManager.getConnection(url)

D. new Connection(url)

Answer

C. DriverManager.getConnection(url)

Explanation: is an interface. Since interfaces do not have constructors, Option D is incorrect. The Connection class doesn’t have a static method to get a Connection either, making Option A incorrect. The class is also an interface without static methods, making Option B incorrect. Option C is the answer because is the class used in JDBC to get a Connection.

3. Which is responsible for getting a connection to the database?

A. Driver B. Connection C. Statement D. ResultSet

Answer

A. Driver

Explanation: The interface is responsible for getting a connection to the database, making Option A the answer. The interface is responsible for communication with the database but not making the initial connection. The interface knows how to run the SQL query, and the ResultSet interface knows what was returned by a SELECT query

4. What is the output when run with a JDBC 4.0 driver if the "demo" database exists and contains an empty "users" table?

String url = "jdbc:derby:demo";

try (Connection conn = DriverManager.getConnection(url); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery("select count(*) from users")) {

System.out.println(rs.getInt(1));

} A. 0 B. 1

C. The code does not compile.

D. The code compiles but throws an exception at runtime.

Answer

D. The code compiles but throws an exception at runtime.

Explanation: This code is missing a call to rs.next(). As a result, rs.getInt(1) throws an SQLException with the message Invalid cursor state – no current row. Therefore, Option D is the answer.

5. Which resources have their close() method called when this code runs?

public static void runQuery(Connection conn) throws SQLException {

try (Statement stmt = conn.createStatement()) {

ResultSet rs = stmt.executeQuery("select * from clowns");

rs.next(); } }

A. No close() methods are called.

B. Only Statement

C. Only Statement and Connection

D. Only Statement and ResultSet

Answer

D. Only Statement and ResultSet

Explanation: Since this code opens Statement using a try-with-resources, Statement gets closed automatically at the end of the block. Further, closing a Statement automatically closes a ResultSet created by it, making Option D the answer. Remember that you should close any resources you open in code you write

6. How many rows are added to the colors table from running the following?

try (Connection conn = DriverManager.getConnection(url); Statement stmt = conn.createStatement()) {

conn.setAutoCommit(false);

stmt.executeUpdate("insert into colors values ('red')");

stmt.executeUpdate("insert into colors values ('blue')");

conn.commit();

conn.setAutoCommit(true);

stmt.executeUpdate("insert into colors values ('green')");

} A. None B. One C. Two D. Three

Answer

B. One

Explanation: The code turns off automatic committing, so the inserts for red and blue are not immediately made. The statement actually prevents them from being committed. Then automatic commit is turned back on and one insert is made, making Option B the answer.

7. What is the correct order to close database resources?

A. Connection then Statement then ResultSet

B. ResultSet then Statement then Connection

C. Statement then Connection then ResultSet

D. Statement then ResultSet then Connection

Answer

B. ResultSet then Statement then Connection

Explanation: When manually closing database resources, they should be closed in the reverse order from which they were opened. This means that the ResultSet object is closed before the Statement object and the Statement object is closed before the Connection object. This makes Option B the answer.

8. Which of the following is not a valid type of ResultSet?

A - ResultSet.TYPE_FORWARD_ONLY

B - ResultSet.TYPE_SCROLL_INSENSITIVE

C - ResultSet.TYPE_SCROLL_SENSITIVE

D - ResultSet.TYPE_BACKWARD_ONLY

Answer

D

Explanation: ResultSet.TYPE_BACKWARD_ONLY is not a valid type of ResultSet.

9. Which JDBC driver type is the JDBC-ODBC type?

Type 1 Type 2 Type 3 Type 4

10. Which of the following is efficient than a statement due to the pre-compilation of SQL?

स्रोत : www.javaguides.net