(TCOs 1, 5, and 6) Java programs communicate with databases using what API?

DBMS

JDBC

RDBMS

Database

Flag this Question

Question 23 pts

(TCOs 1, 5, and 6) A _____ is a column (or set of columns) which has a unique value that cannot be duplicated in other rows.

foreign key

SQL statement

query

primary key

Flag this Question

Question 33 pts

(TCOs 1, 5, and 6) To catch an exception, the code that might cause the exception must be enclosed in a

throws block.

try block.

catch block.

finally block.

Flag this Question

Question 43 pts

(TCOs 1, 5, and 6) Which statement below is FALSE?

The executeQuery method of statement returns a ResultSet object.

ResultSet has methods to retrieve data from a specific column indicated by a number.

ResultSet row and column numbers start at 0.

ResultSet has methods to retrieve data from a specific column indicated by the name.

Flag this Question

Question 53 pts

(TCOs 1, 5, 6) Which of the following statements about try blocks is TRUE?

The try block must be followed by exactly one catch block.

The try block must be followed by a finally block.

The try block should contain statements that may process an exception.

The try block should contain statements that may throw an exception.

Flag this Question

Question 63 pts

(TCOs 1, 5, and 6) Which of the following statements is FALSE?

PreparedStatement can only be used for SQL SELECT statements.

The parameters in a prepared statement are specified using the ? character.

PreparedStatement is efficient for repeated executions.

PreparedStatement is a subinterface of Statement.

Flag this Question

Question 73 pts

(TCOs 1, 5, and 6) The methods of what type of object can be used to move the cursor through the data that is returned from a query?

Statement

PreparedStatement

Result

ResultSet

Flag this Question

Question 83 pts

(TCOs 1, 5, and 6) If the InvoiceID column of a MySQL database is an INT type and the InvoiceDate column is a VARCHAR type, which of the following statements returns those columns of the current row? Statement statement = connection.createStatement(); String query = "SELECT InvoiceID, InvoiceDate FROM Invoices "; ResultSet dueInvoices = statement.executeQuery(query); dueInvoices.next();

int id = dueInvoices.getInt(1); String date = dueInvoices.getVarChar(2);

int id = dueInvoices.getInt("InvoiceID"); String date = dueInvoices.getVarChar("InvoiceDate");

int id = dueInvoices.getInt("InvoiceID"); String date = dueInvoices.getString("InvoiceDate");

int id = dueInvoices.getInt(0); String date = dueInvoices.getString(1);

Flag this Question

Question 93 pts

(TCOs 1, 5, and 6) What must you make available to your application before you can use JDBC to connect to a database?

A database driver

A web server

A firewall

An ODBC data source

Flag this Question

Question 103 pts

(TCOs 1, 5, and 6) A _____ is a swing GUI component that can be bound to a database to display the results of a query.

TableModel

JTextField

JTable

JQuery