1) Collections method sort that accepts a List as an argument sorts the elements of a List, which must implement the __________ interface.

Comparable.

Comparator.

Compare.

Ordering.

2) Comparator method compare should return ________ if the first argument is greater than the second argument.

a positive int value.

zero.

a negative int value.

a String.

3) Which statement is false?

-Java does not guarantee which item will be found first when a binarySearch is performed on a List containing multiple elements equivalent to the search key.

-	If the search key is found, method binarySearch returns the List index (position relative to 1) of the element containing the search key.

-The binary search algorithm is fast.

-	Method binarySearch takes a List as the first argument.

4) Collections method __________ returns true if two Collections have no elements in common.

shuffle.

contains.

hasCommon.

disjoint.

5) Which statement is false?

Queue is a new collection interface introduced in J2SE 5.0.

Queue and PriorityQueue are included in the java.util package.

PriorityQueue orders elements in increasing order, so that smallest value will be the first element removed from PriorityQueue.

Queue extends interface Collection.

6) Which statement about hashing is false?

Hashing facilitates high-speed storing and retrieval of data.

Two different data items can hash to the same cell; this is called a collision.

A load factor of 0.5 usually results in good hashing performance, but less efficient utilization of memory.

A load factor of 1.0 usually results in good hashing performance, but less efficient utilization of memory.

7) Map method ________ is used to determine whether a map contains a mapping for the specified key.

containsKey.

hasKey.

containsMapping.

hasMapping.

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

Primary key.

Query.

SQL statement.

Lookup value.

9) To obtain data from a table, you ________ the database?

select.

query.

get.

None of the above.

10) What does a primary key do?

Identifies each row of a table.

Selects a number of rows from a database.

Stores a bunch of related data.

None of the above.

11) What is the relationship between a primary key and its corresponding foreign keys?

One-to-one.

Many-to-one.

Many-to-many.

One-to-many.

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

their database names.

their database names and a dot.

their table names and a dot.

their table names.

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

INSERT.

ADD.

UPDATE.

CREATE.

14) SQL uses the _________ as a delimiter for strings.

double quotes (" and ").

single quotes (' and ').

underscore (_).

percent (%).

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

a comma-separated list of column value-name pairs in the format value = columnName.

a comma-separated list of column name-value pairs in the format columnName = value.

a semicolon-separated list of column value-name pairs in the format value = columnName.

a semicolon-separated list of column name-value pairs in the format columnName = value.

16) In a PreparedStatement, parameters are counted from position ________.

0

1

2

3

17) PreparedStatement method ________ returns a ResultSet.

executeUpdate.

executeQuery.

execute.

None of the above.

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

save, delete.

commit, rollback.

save, rollback.

commit, delete.