Question 1

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

Accepted Answer

A) select. 
B) query. 
C) get. 
D) None of the above. 
A) select. 
B) query. 
C) get. 
D) None of the above.

Question 2

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.

Question 3

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.

Question 4

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

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 7

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 8

SQL uses the _________ as a delimiter for strings.

Accepted Answer

A) double quotes (" and "). 
B) single quotes (' and '). 
C) underscore (-). 
D) percent (%). 
A) double quotes (" and "). 
B) single quotes (' and '). 
C) underscore (-). 
D) percent (%).

Question 9

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 10

Which constants are used to indicate that a ResultSet is scrollable,insensitive to changes and read only?

Accepted Answer

A) TYPE_SCROLLABLE_INSENSITIVE,CONCUR_READ_ONLY. 
B) TYPE_SCROLLABLEINSENSITIVE,CONCUR_READONLY. 
C) TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY. 
D) TYPE_SCROLL_INSENSITIVE,CONCUR_READONLY. 
A) TYPE_SCROLLABLE_INSENSITIVE,CONCUR_READ_ONLY. 
B) TYPE_SCROLLABLEINSENSITIVE,CONCUR_READONLY. 
C) TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY. 
D) TYPE_SCROLL_INSENSITIVE,CONCUR_READONLY.

Question 11

The default sort order in a sorted query is _________.

Accepted Answer

A) ascending. 
B) descending. 
C) natural. 
D) None of the above. 
A) ascending. 
B) descending. 
C) natural. 
D) None of the above.

Question 12

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.

Question 13

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 14

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.

Question 15

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.

Exam 28: Accessing Databases With Jdbc

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

Java programs communicate with databases using what API?

Which of the following states the Rule of Entity Integrity?

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

Which SQL keyword is required in every query?

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

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

SQL uses the _________ as a delimiter for strings.

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

Which constants are used to indicate that a ResultSet is scrollable,insensitive to changes and read only?

The default sort order in a sorted query is _________.

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

PreparedStatement method ________ returns a ResultSet.

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

Initially,a ResultSet cursor is positioned _________.

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