Question 1

Which symbol indicates that all columns should be retrieved?

Accepted Answer

A) (?) 
B) * 
C) + 
D) / 
A) (?) 
B) * 
C) + 
D) / B

Question 2

To retrieve specific columns from a table,use _________ to separate the column names.

Accepted Answer

A) (?) 
B) * 
C)  , 
D) - 
A) (?) 
B) * 
C)  , 
D) - C

Question 3

This keyword is used to add a row to a table.

Accepted Answer

A) INSERT. 
B) ADD. 
C) UPDATE. 
D) CREATE. 
A) INSERT. 
B) ADD. 
C) UPDATE. 
D) CREATE. A

Question 4

Transaction processing enables a program to ________ or ________ a transaction based on whether the transaction was successful?

Accepted Answer

A) save,delete. 
B) commit,rollback. 
C) save,rollback. 
D) commit,delete. 
A) save,delete. 
B) commit,rollback. 
C) save,rollback. 
D) commit,delete.

Question 5

JDBC 4 supports _______,so you do not need to manually load the database driver before accessing a database.

Accepted Answer

A) automatic driver downloading. 
B) automatic driver creation. 
C) automatic driver discovery. 
D) None of the above. 
A) automatic driver downloading. 
B) automatic driver creation. 
C) automatic driver discovery. 
D) None of the above.

Question 6

Transaction processing enables a program to treat a database operation,or set of operations,as single operation.This is known as a(n)________ or a(n)________.

Accepted Answer

A) atomic operation,unique operation. 
B) unique operation,transaction. 
C) atomic operation,transaction. 
D) None of the above. 
A) atomic operation,unique operation. 
B) unique operation,transaction. 
C) atomic operation,transaction. 
D) None of the above.

Question 7

In an UPDATE statement,the SET keyword is followed by _________.

Accepted Answer

A) a comma-separated list of column value-name pairs in the format value = columnName. 
B) a comma-separated list of column name-value pairs in the format columnName = value. 
C) a semicolon-separated list of column value-name pairs in the format value = columnName. 
D) a semicolon-separated list of column name-value pairs in the format columnName = value. 
A) a comma-separated list of column value-name pairs in the format value = columnName. 
B) a comma-separated list of column name-value pairs in the format columnName = value. 
C) a semicolon-separated list of column value-name pairs in the format value = columnName. 
D) a semicolon-separated list of column name-value pairs in the format columnName = value.

Question 8

Which statement is false?

Accepted Answer

A) Interface JdbcRowSet is in the javax.rowset package. 
B) A CachedRowSet object is scrollable and updatable by default. 
C) A JdbcRowSet object is scrollable and updatable by default. 
D) JdbcRowSet is a connected RowSet. 
A) Interface JdbcRowSet is in the javax.rowset package. 
B) A CachedRowSet object is scrollable and updatable by default. 
C) A JdbcRowSet object is scrollable and updatable by default. 
D) JdbcRowSet is a connected RowSet.

Question 9

Which statement is false?

Accepted Answer

A) A DELETE statement removes rows from a table. 
B) A DELETE statement must specify the table from which to delete. 
C) A DELETE statement starts with the keyword DELETE. 
D) A WHERE clause must be present in a DELETE statement. 
A) A DELETE statement removes rows from a table. 
B) A DELETE statement must specify the table from which to delete. 
C) A DELETE statement starts with the keyword DELETE. 
D) A WHERE clause must be present in a DELETE statement.

Question 10

What are individual SQL statements saved in a database called?

Accepted Answer

A) Stored statements. 
B) Stored queries. 
C) Stored commands. 
D) Stored procedures. 
A) Stored statements. 
B) Stored queries. 
C) Stored commands. 
D) Stored procedures.

Question 11

What does a primary key do?

Accepted Answer

A) Identifies each row of a table. 
B) Selects a number of rows from a database. 
C) Stores a bunch of related data. 
D) None of the above. 
A) Identifies each row of a table. 
B) Selects a number of rows from a database. 
C) Stores a bunch of related data. 
D) None of the above.

Question 12

The result of a query can be sorted by using the optional _________ clause.

Accepted Answer

A) ORDER BY. 
B) ORDER. 
C) SORT BY. 
D) SORT. 
A) ORDER BY. 
B) ORDER. 
C) SORT BY. 
D) SORT.

Question 13

Classes and interfaces for the JDBC API can be found in which package?

Accepted Answer

A) java.jdbc. 
B) javax.jdbc. 
C) java.sql. 
D) java.sql.jdbc. 
A) java.jdbc. 
B) javax.jdbc. 
C) java.sql. 
D) java.sql.jdbc.

Question 14

What exception is thrown if the class loader cannot locate the driver class?

Accepted Answer

A) NoSuchClassException. 
B) ClassCastException. 
C) ClassNotFoundException. 
D) IllegalClassException. 
A) NoSuchClassException. 
B) ClassCastException. 
C) ClassNotFoundException. 
D) IllegalClassException.

Question 15

In a PreparedStatement,parameters are counted from position ________.

Accepted Answer

A) 0. 
B) 1. 
C) 2. 
D) 3. 
A) 0. 
B) 1. 
C) 2. 
D) 3.

Question 16

If a query includes columns from multiple tables that have the same name,the statement must precede those column names with _________.

Accepted Answer

A) their database names. 
B) their database names and a dot. 
C) their table names and a dot. 
D) their table names. 
A) their database names. 
B) their database names and a dot. 
C) their table names and a dot. 
D) their table names.

Question 17

A ________ is a column (or set of columns)which have a unique value that cannot be duplicated in other rows?

Accepted Answer

A) Primary key. 
B) Query. 
C) SQL statement. 
D) Lookup value. 
A) Primary key. 
B) Query. 
C) SQL statement. 
D) Lookup value.

Question 18

The _________ interface configures the database connection and prepares query statements automatically.

Accepted Answer

A) ResultSet. 
B) RowSet. 
C) Both of the above. 
D) Neither of the above. 
A) ResultSet. 
B) RowSet. 
C) Both of the above. 
D) Neither of the above.

Question 19

Which of the following is a key benefit of using JDBC?

Accepted Answer

A) It is a simple-to-use database management system. 
B) Allows developers to change the underlying database without modifying the Java code. 
C) It is a multi-platform database management system. 
D) It provides a GUI for database management systems. 
A) It is a simple-to-use database management system. 
B) Allows developers to change the underlying database without modifying the Java code. 
C) It is a multi-platform database management system. 
D) It provides a GUI for database management systems.

Question 20

Which SQL keyword is used to merge rows from multiple tables?

Accepted Answer

A) JOIN. 
B) INNER JOIN. 
C) GROUP. 
D) MERGE. 
A) JOIN. 
B) INNER JOIN. 
C) GROUP. 
D) MERGE.

Exam 28: Accessing Databases With Jdbc

Which symbol indicates that all columns should be retrieved?

To retrieve specific columns from a table,use _________ to separate the column names.

This keyword is used to add a row to a table.

Transaction processing enables a program to ________ or ________ a transaction based on whether the transaction was successful?

JDBC 4 supports _______,so you do not need to manually load the database driver before accessing a database.

Transaction processing enables a program to treat a database operation,or set of operations,as single operation.This is known as a(n)________ or a(n)________.

In an UPDATE statement,the SET keyword is followed by _________.

Which statement is false?

Which statement is false?

What are individual SQL statements saved in a database called?

What does a primary key do?

The result of a query can be sorted by using the optional _________ clause.

Classes and interfaces for the JDBC API can be found in which package?

What exception is thrown if the class loader cannot locate the driver class?

In a PreparedStatement,parameters are counted from position ________.

If a query includes columns from multiple tables that have the same name,the statement must precede those column names with _________.

A ________ is a column (or set of columns)which have a unique value that cannot be duplicated in other rows?

The _________ interface configures the database connection and prepares query statements automatically.

Which of the following is a key benefit of using JDBC?

Which SQL keyword is used to merge rows from multiple tables?

Introduction to Computers and Java

Introduction to Java Applications

Introduction to Classes and Objects

Control Statements: Part 1

Control Statements: Part 2

Methods: a Deeper Look

Arrays and Arraylists

Classes and Objects: a Deeper Look

Object Oriented Programming: Inheritance

Object-Oriented Programming: Polymorphism

Exception Handling

Atm Case Study,part 1: Object-Oriented Design With the Uml

Atm Case Study,part 2: Implementing an Object-Oriented Design

Gui Components: Part 1

Graphics and Java 2d

Strings

Files,streams and Object Serialization

Recursion

Searching, Sorting and Big O

Generic Collections

Generic Classes and Methods

Custom Generic Data Structures

Applets and Java Web Start

Multimedia: Applets and Applications

Gui, Part 2

Multithreading

Networking

Java Server Faces Web Applications

Ajax-Enabled Jsf Web Applications

Web Services

Filters

Transaction processing enables a program to or a transaction based on whether the transaction was successful?

Transaction processing enables a program to treat a database operation,or set of operations,as single operation.This is known as a(n) or a(n).