Java Beans And Jdbc — Part 1 MCQs with Explanations

executeUpdate() : This method is used to execute SQL statements that update the database, such as INSERT , UPDATE , or DELETE statements. It returns an integer representing the number of rows affected by the query. execute() : This method can be used to execute any SQL statement, and it returns a boolean. The returned value is true if the result is a ResultSet object; otherwise, it returns false . executeBatch() : This method is used to execute a batch of SQL statements. It sends multiple SQL statements to the database for execution as a batch and returns an array of update counts. It is not used to execute a single SQL query. executeQuery() : This method is used to execute SQL queries that retrieve data from the database, such as SELECT statements. It returns a ResultSet object containing the data produced by the query. Therefore, executeBatch() is not a valid method to execute a single SQL query in JDBC.

A reusable software component that follows specific conventions is the correct answer to “What is a JavaBean in Java”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`.java` is the correct answer to “Which file extension is commonly used for JavaBean files”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To retrieve the value of a property is the correct answer to “In JavaBeans, what is the purpose of the getter method”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

It allows you to examine the properties, events, and methods of a bean is the correct answer to “What is the role of the `javabeans.Introspector` class in JavaBeans”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`user_name` is the correct answer to “Which of the following is a valid property name for a JavaBean”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

Java Database Connectivity, a Java API for database access is the correct answer to “What is JDBC in Java”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`java.sql` is the correct answer to “Which Java package contains the JDBC classes and interfaces”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To manage a list of database drivers is the correct answer to “What is the purpose of the JDBC `DriverManager` class”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

A connection to a database is the correct answer to “What does the JDBC `Connection` interface represent”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`Type 1` is the correct answer to “Which of the following is NOT a valid JDBC driver type”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To execute parameterized SQL queries is the correct answer to “What is the purpose of the JDBC `PreparedStatement` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To represent the result set of a database query is the correct answer to “In JDBC, what is the purpose of the `ResultSet` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To provide a pooled connection to the database is the correct answer to “What is the primary role of a JDBC `DataSource`”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

JDBC transactions are used to ensure data consistency in a database is the correct answer to “Which of the following statements is true about JDBC transactions”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To manage database drivers and establish database connections is the correct answer to “What is the role of the `java.sql.DriverManager` class in JDBC”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To execute SQL queries against a database is the correct answer to “What is the role of the JDBC `Statement` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

It provides information about the columns in a `ResultSet` is the correct answer to “Which of the following statements is true about JDBC `ResultSetMetaData`”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To execute stored procedures in a database is the correct answer to “What is the purpose of the JDBC `CallableStatement` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

A pool of pre-established database connections is the correct answer to “In JDBC, what is a database connection pool”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`close()` is the correct answer to “Which of the following is NOT a valid method to close a JDBC `Connection`”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To execute multiple SQL statements as a batch is the correct answer to “What is the purpose of the JDBC `Batch` processing feature”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`INSERT INTO` is the correct answer to “Which SQL statement is used to insert data into a database table in JDBC”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To define the contract for database drivers is the correct answer to “In JDBC, what is the primary purpose of the `Driver` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To handle database-related exceptions is the correct answer to “In JDBC, what is the purpose of the `java.sql.SQLException` class”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To provide a connection pool for JDBC is the correct answer to “What is the primary role of the JDBC `ConnectionPoolDataSource` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

Using try-catch blocks to catch `SQLException` is the correct answer to “Which of the following is a valid way to handle exceptions in JDBC”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To represent a set of rows from a database is the correct answer to “What is the primary purpose of the JDBC `RowSet` interface”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

To provide warnings about database operations is the correct answer to “In JDBC, what is the purpose of the `java.sql.SQLWarning` class”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

`getString(int columnIndex)` is the correct answer to “Which of the following is a valid method to retrieve data from a JDBC `ResultSet`”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

False is the correct answer to “Java Beans are extremely secured”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

Command pattern is the correct answer to “Which design pattern works on data and action taken based on data provided”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

setMaxRows(int i) is the correct answer to “Which of the following is used to limit the number of rows returned”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

@Qualifier is the correct answer to “How to specify autowiring by name”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

Facade pattern is the correct answer to “Which design pattern provides a single class which provides simplified methods required by client and delegates call to those methods”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

java.util.dateTime is the correct answer to “Which of the following contains both date and time”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

TRANSACTION_NONREPEATABLE_READ is the correct answer to “Which of the following is not a JDBC connection isolation levels”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

singleton is the correct answer to “What is the attribute of java bean to specify scope of bean to have single instance per Spring IOC”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

destroy-method is the correct answer to “Which attribute is used to specify destroy method”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.

Gang Pattern is the correct answer to “Which of the below author is not a part of GOF (Gang of Four)”. This question is standard in competitive examination syllabi for Java Beans And Jdbc.