JDBC Programming with Java Post Test

Default Section

Question Title

1. JDBC syntax is very specific to the version of the Database being accessed? (Required.)

True

False

Do Not Know

Question Title

2. Which of the following Interfaces requires a Userid and Password to use? (Required.)

DatabaseDriver

Connection

Statement

ResultSet

Do not know

Question Title

3. Which Design Pattern separates the Business Logic from the SQL code? (Required.)

Data Access Object (DAO)

Object-Relational Mapping (ORM)

Java Persistence API (JPA)

Active Record (AR)

Do not know

Question Title

4. Which Exception occurs when the Database is closed prior to use? (Required.)

SQLClosedException

SQLException

ClientException

ConnectionException

Do not know

Question Title

5. A JDBC PreparedStatement helps prevent SQL Injection Attacks. (Required.)

True

False

Do not know

Question Title

6. Which of the following is used to invoke a Stored Procedure? (Required.)

Statement

PreparedStatement

CallableStatement

ProcedureStatment

Do not know

Question Title

7. JDBC Connections are Auto Commit by default (Required.)

True

False

Do not know

Question Title

8. Which of the following methods commits a Transaction? (Required.)

transaction.commit()

connection.commit()

statement.commit()

connection.getCurrentTransaction().commit()

Do not know

Question Title

9. What is the first step in connecting to a Database via JDBC? (Required.)

Create a Connection Object

Load the Database Driver

Create an XML configuration file to hold Userid and Password

Execute a command to load the Database Metadata

Do not know

Question Title

10. Which of the following returns a ResultSet? (Required.)

statement.execute()

statement.executeQuery()

statement.executeUpdate()

statement.executeResultSet()

Do not know

Question Title

* 1. JDBC syntax is very specific to the version of the Database being accessed? (Required.)

Question Title

* 2. Which of the following Interfaces requires a Userid and Password to use? (Required.)

Question Title

* 3. Which Design Pattern separates the Business Logic from the SQL code? (Required.)

Question Title

* 4. Which Exception occurs when the Database is closed prior to use? (Required.)

Question Title

* 5. A JDBC PreparedStatement helps prevent SQL Injection Attacks. (Required.)

Question Title

* 6. Which of the following is used to invoke a Stored Procedure? (Required.)

Question Title

* 7. JDBC Connections are Auto Commit by default (Required.)

Question Title

* 8. Which of the following methods commits a Transaction? (Required.)

Question Title

* 9. What is the first step in connecting to a Database via JDBC? (Required.)

Question Title

* 10. Which of the following returns a ResultSet? (Required.)

1. JDBC syntax is very specific to the version of the Database being accessed? (Required.)

2. Which of the following Interfaces requires a Userid and Password to use? (Required.)

3. Which Design Pattern separates the Business Logic from the SQL code? (Required.)

4. Which Exception occurs when the Database is closed prior to use? (Required.)

5. A JDBC PreparedStatement helps prevent SQL Injection Attacks. (Required.)

6. Which of the following is used to invoke a Stored Procedure? (Required.)

7. JDBC Connections are Auto Commit by default (Required.)

8. Which of the following methods commits a Transaction? (Required.)

9. What is the first step in connecting to a Database via JDBC? (Required.)

10. Which of the following returns a ResultSet? (Required.)