Question 1

What is the effect of the following statement?
String productCode = result.getString(1);

Accepted Answer

A) it will return the data in the second column. 
B) it will return the data in the first column. 
C) it will store the integer 1 as a string in productCode. 
D) it will return the name of the column. 
A) it will return the data in the second column. 
B) it will return the data in the first column. 
C) it will store the integer 1 as a string in productCode. 
D) it will return the name of the column. B

Question 2

An example of a lightweight database is:

Accepted Answer

A) Oracle 
B) MS Access 
C) Apache Derby 
D) MySQL 
A) Oracle 
B) MS Access 
C) Apache Derby 
D) MySQL C

Question 3

Microsoft Access is an example of a:

Accepted Answer

A) Heavyweight Java database. 
B) Lightweight Java database. 
C) Desktop database. 
D) Production-quality database. 
A) Heavyweight Java database. 
B) Lightweight Java database. 
C) Desktop database. 
D) Production-quality database. C

Question 4

Database tables store rows that contain the following except

Accepted Answer

A) strings 
B) fundamental data types 
C) arbitrary objects 
D) numbers 
A) strings 
B) fundamental data types 
C) arbitrary objects 
D) numbers

Question 5

What does the following statement do?
String prodCode = nextLine(in, "Product Code (D=Done, L=List)");

Accepted Answer

A) It will store the string "Product Code (D=Done, L=List)" in the variable in. 
B) It will display "in, Product Code (D=Done, L=List)" on the screen. 
C) It will display the contents of the variable in on the screen. 
D) It will read the user's input and store it in the object prodCode. 
A) It will store the string "Product Code (D=Done, L=List)" in the variable in. 
B) It will display "in, Product Code (D=Done, L=List)" on the screen. 
C) It will display the contents of the variable in on the screen. 
D) It will read the user's input and store it in the object prodCode.

Question 6

In what format does the SQL query return a result?

Accepted Answer

A) XPath syntax 
B) ResultSet object 
C) A String separated by colons 
D) An array of results 
A) XPath syntax 
B) ResultSet object 
C) A String separated by colons 
D) An array of results

Question 7

If your statement has variable parts, you should use a _________ object.

Accepted Answer

A) ResultSet 
B) ResultSetMetaData 
C) PreparedStatement 
D) Statement 
A) ResultSet 
B) ResultSetMetaData 
C) PreparedStatement 
D) Statement

Question 8

Apache Derby is an example of a:

Accepted Answer

A) Heavyweight Java database. 
B) Lightweight Java database. 
C) Desktop database. 
D) Production-quality database. 
A) Heavyweight Java database. 
B) Lightweight Java database. 
C) Desktop database. 
D) Production-quality database.

Question 9

Metadata are ______

Accepted Answer

A) data about an object. 
B) the properties of a result set. 
C) the objects that are used to execute the SQL commands. 
D) data about a connection. 
A) data about an object. 
B) the properties of a result set. 
C) the objects that are used to execute the SQL commands. 
D) data about a connection.

Question 10

Complete the following statement, which inserts rows into the following Course table.
____________________ VALUES ('CS221', 'Data Structures', '4', 'J.Jones')
Course table

Accepted Answer

A) INSERT INTO Course table 
B) INSERT FROM Course 
C) INSERT INTO Course 
D) INSERT INTO Table Course 
A) INSERT INTO Course table 
B) INSERT FROM Course 
C) INSERT INTO Course 
D) INSERT INTO Table Course

Question 11

Oracle is an example of a:

Accepted Answer

A) Heavyweight Java database. 
B) Lightweight Java database. 
C) Desktop database. 
D) Production-quality database. 
A) Heavyweight Java database. 
B) Lightweight Java database. 
C) Desktop database. 
D) Production-quality database.

Question 12

Which import statement will allow you to use a SQLException object?

Accepted Answer

A) import javax.swing.SQLException; 
B) import java.sql.SQLException; 
C) import java.util.SQLException; 
D) import java.io.SQLException; 
A) import javax.swing.SQLException; 
B) import java.sql.SQLException; 
C) import java.util.SQLException; 
D) import java.io.SQLException;

Question 13

If you encounter an error during updating a transaction, then call the ______ method:

Accepted Answer

A) undo 
B) takeback 
C) rollaround 
D) rollback 
A) undo 
B) takeback 
C) rollaround 
D) rollback

Question 14

If you want to find out about properties of a result set from an unknown table, you need to use:

Accepted Answer

A) the ResultSet class. 
B) the Statement class. 
C) the ResultSetData class. 
D) the ResultSetMetaData class. 
A) the ResultSet class. 
B) the Statement class. 
C) the ResultSetData class. 
D) the ResultSetMetaData class.

Question 15

In a Java program, the result of a SQL query is returned in a _____________ object.

Accepted Answer

A) ResultSet 
B) connection 
C) view 
D) driver 
A) ResultSet 
B) connection 
C) view 
D) driver

Question 16

The ___ symbol in the query string denotes variables that you fill in when you make an actual query

Accepted Answer

A) (?) 
B) * 
C) ! 
D) :: 
A) (?) 
B) * 
C) ! 
D) ::

Question 17

In SQL, the _____________ command is used to issue queries that do not modify the database.

Accepted Answer

A) APPEND 
B) UPDATE 
C) MODIFY 
D) SELECT 
A) APPEND 
B) UPDATE 
C) MODIFY 
D) SELECT

Question 18

Insert the statement that would remove the following table from the database.
CREATE TABLE Course
(
Course_ID VARCHAR(11),
Credits VARCHAR(4),
Room_No INT(4)
)
____________________

Accepted Answer

A) DELETE TABLE Course 
B) TRUNCATE TABLE Course 
C) DROP Course 
D) DROP TABLE Course 
A) DELETE TABLE Course 
B) TRUNCATE TABLE Course 
C) DROP Course 
D) DROP TABLE Course

Question 19

Which SQL command(s) modify the data in a database?
i.SELECT
II.INSERT
III.DELETE
IV.UPDATE

Accepted Answer

A) I, II, III 
B) Only II, III 
C) II, III, IV 
D) Only III, IV 
A) I, II, III 
B) Only II, III 
C) II, III, IV 
D) Only III, IV

Question 20

A ______________ object can create statement objects that are used to execute SQL commands.

Accepted Answer

A) ResultSet 
B) Connection 
C) JDBC 
D) Driver 
A) ResultSet 
B) Connection 
C) JDBC 
D) Driver

Exam 24: Relational Databases

What is the effect of the following statement? String productCode = result.getString(1);

An example of a lightweight database is:

Microsoft Access is an example of a:

Database tables store rows that contain the following except

What does the following statement do? String prodCode = nextLine(in, "Product Code (D=Done, L=List)");

In what format does the SQL query return a result?

If your statement has variable parts, you should use a _________ object.

Apache Derby is an example of a:

Metadata are ______

Complete the following statement, which inserts rows into the following Course table. ____________________ VALUES ('CS221', 'Data Structures', '4', 'J.Jones') Course table

Oracle is an example of a:

Which import statement will allow you to use a SQLException object?

If you encounter an error during updating a transaction, then call the ______ method:

If you want to find out about properties of a result set from an unknown table, you need to use:

In a Java program, the result of a SQL query is returned in a _____________ object.

The ___ symbol in the query string denotes variables that you fill in when you make an actual query

In SQL, the _____________ command is used to issue queries that do not modify the database.

Insert the statement that would remove the following table from the database. CREATE TABLE Course ( Course_ID VARCHAR(11), Credits VARCHAR(4), Room_No INT(4) ) ____________________

Which SQL command(s) modify the data in a database? i.SELECT II.INSERT III.DELETE IV.UPDATE

A ______________ object can create statement objects that are used to execute SQL commands.

Introduction

Using Objects

Implementing Classes

Fundamental Data Types

Decisions

Loops

Arrays and Array Lists

Designing Classes

Inheritance

Interfaces

Input/Output and Exception Handling

Object-Oriented Design

Recursion

Sorting and Searching

The Java Collections Framework

Basic Data Structures

Tree Structures

Generic Classes

Stream Processing

Graphical User Interfaces

Advanced Input/Output

Multithreading

Internet Networking

XML

Filters