Question 1

Java programs communicate with databases using what API?

Accepted Answer

A) DBMS. 
B) JDBC. 
C) RDBMS. 
D) Database. 
A) DBMS. 
B) JDBC. 
C) RDBMS. 
D) Database. B

Question 2

When joining tables,the _________ clause specifies the columns from each table that are com?pared to determine which rows are merged.

Accepted Answer

A) ON 
B) WHERE 
C) LIKE 
D) GROUP 
A) ON 
B) WHERE 
C) LIKE 
D) GROUP A

Question 3

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

Accepted Answer

A) One-to-one. 
B) Many-to-one. 
C) Many-to-many. 
D) One-to-many. 
A) One-to-one. 
B) Many-to-one. 
C) Many-to-many. 
D) One-to-many. D

Question 4

PreparedStatement method ________ returns a ResultSet.

Accepted Answer

A) executeUpdate 
B) executeQuery 
C) execute 
D) None of the above. 
A) executeUpdate 
B) executeQuery 
C) execute 
D) None of the above.

Question 5

Which SQL keyword is required in every query?

Accepted Answer

A) FROM. 
B) WHERE. 
C) ORDER BY. 
D) LIKE. 
A) FROM. 
B) WHERE. 
C) ORDER BY. 
D) LIKE.

Question 6

Pattern matching in a SQL query is performed with which clause?

Accepted Answer

A) FROM. 
B) WHERE. 
C) SELECT. 
D) LIKE. 
A) FROM. 
B) WHERE. 
C) SELECT. 
D) LIKE.

Question 7

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 8

Selection criteria can be added to a SQL query using which keyword?

Accepted Answer

A) FROM. 
B) WHERE. 
C) SELECT. 
D) LIKE. 
A) FROM. 
B) WHERE. 
C) SELECT. 
D) LIKE.

Question 9

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 10

What is the name of a key in one table that is required to matche a primary key in another table?

Accepted Answer

A) Foreign key. 
B) Matching key. 
C) Joined key. 
D) Linking key. 
A) Foreign key. 
B) Matching key. 
C) Joined key. 
D) Linking key.

Question 11

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 12

SQL statements that are stored in a database can be invoked using an object that implements interface ________.

Accepted Answer

A) Callable 
B) StoredStatement 
C) CallableStatement 
D) Connection 
A) Callable 
B) StoredStatement 
C) CallableStatement 
D) Connection

Question 13

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.

Question 14

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 15

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 16

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 17

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 18

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 19

Initially,a ResultSet cursor is positioned _________.

Accepted Answer

A) before the first row 
B) at the first row 
C) at the last row 
D) after the last row 
A) before the first row 
B) at the first row 
C) at the last row 
D) after the last row

Question 20

Which of the following states the Rule of Entity Integrity?

Accepted Answer

A) Every row must have a value for the primary key and each value must be unique. 
B) Every foreign key must appear as another table's primary key. 
C) Every row must have a value for the primary key and values may be repeated. 
D) None of the above. 
A) Every row must have a value for the primary key and each value must be unique. 
B) Every foreign key must appear as another table's primary key. 
C) Every row must have a value for the primary key and values may be repeated. 
D) None of the above.

Exam 24: Accessing Databases With Jdbc

Java programs communicate with databases using what API?

When joining tables,the _________ clause specifies the columns from each table that are com?pared to determine which rows are merged.

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

PreparedStatement method ________ returns a ResultSet.

Which SQL keyword is required in every query?

Pattern matching in a SQL query is performed with which clause?

Which statement is false?

Selection criteria can be added to a SQL query using which keyword?

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

What is the name of a key in one table that is required to matche a primary key in another table?

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

SQL statements that are stored in a database can be invoked using an object that implements interface ________.

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

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

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)________.

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?

Initially,a ResultSet cursor is positioned _________.

Which of the following states the Rule of Entity Integrity?

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

Gui Components: Part 1

Graphics and Java 2D

Strings

Files,streams and Object Serialization

Generic Collections

Lambdas

Recursion

Searching, Sorting and Big O

Generic Classes and Methods

Custom Generic Data Structures

Concurrency

JavaFX

Filters

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).