Question 1

In SQL, ____ is used to test for equality.

Accepted Answer

A) EQUAL 
B) == 
C) = 
D) EQUALS 
A) EQUAL 
B) == 
C) = 
D) EQUALS

Question 2

What is the purpose of a primary key?

Accepted Answer

A) To establish a link from one table to another 
B) To be the first identifier, which does not need to be unique 
C) To use a row that uniquely identifies a column 
D) To link a column to another column 
A) To establish a link from one table to another 
B) To be the first identifier, which does not need to be unique 
C) To use a row that uniquely identifies a column 
D) To link a column to another column

Question 3

One of the steps for testing the JDBC driver is:

Accepted Answer

A) to setup your user account. 
B) to find the name of the database URL that your driver expects. 
C) to install the JDBC driver program. 
D) to change the directory to the JDBC driver directory. 
A) to setup your user account. 
B) to find the name of the database URL that your driver expects. 
C) to install the JDBC driver program. 
D) to change the directory to the JDBC driver directory.

Question 4

A ____________ is a set of rows and columns that provides a "window" through which you can see some of the database data.

Accepted Answer

A) table 
B) view 
C) window 
D) subquery 
A) table 
B) view 
C) window 
D) subquery

Question 5

Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________.
Customer table

Accepted Answer

A) SELECT * FROM Customer WHERE City NOT 'Pleasantville' 
B) SELECT * FROM Customer WHERE NOT (City = 'Pleasantville') 
C) SELECT * FROM Customer WHERE City  'Pleasantville' 
D) SELECT * FROM Customer WHERE City != 'Pleasantville' 
A) SELECT * FROM Customer WHERE City NOT 'Pleasantville' 
B) SELECT * FROM Customer WHERE NOT (City = 'Pleasantville') 
C) SELECT * FROM Customer WHERE City  'Pleasantville' 
D) SELECT * FROM Customer WHERE City != 'Pleasantville'

Question 6

When you are done with a Statement object, _______.

Accepted Answer

A) you should close it and you must close the associated result set as well. 
B) you should not close it and should not close the associated result set. 
C) you should close it and that automatically closes the associated result set. 
D) you should only close the associated result set. 
A) you should close it and you must close the associated result set as well. 
B) you should not close it and should not close the associated result set. 
C) you should close it and that automatically closes the associated result set. 
D) you should only close the associated result set.

Question 7

Used with the LIKE operator, the ______ symbol matches exactly one character.

Accepted Answer

A) _ 
B) % 
C) (?) 
D) $ 
A) _ 
B) % 
C) (?) 
D) $

Question 8

If your program needs to look at several result sets at the same time, _____.

Accepted Answer

A) you need to create multiple Statement objects. 
B) you can reuse the Statement or PreparedStatement objects 
C) you should close the ResultSet before creating a new one. 
D) you are not able to see several sets at the same time. 
A) you need to create multiple Statement objects. 
B) you can reuse the Statement or PreparedStatement objects 
C) you should close the ResultSet before creating a new one. 
D) you are not able to see several sets at the same time.

Question 9

When you close a connection:

Accepted Answer

A) it closes the connection only. 
B) it closes the connection and the associated result set. 
C) it closes the connection and the associated statement. 
D) it closes the connection and closes all statements and result sets. 
A) it closes the connection only. 
B) it closes the connection and the associated result set. 
C) it closes the connection and the associated statement. 
D) it closes the connection and closes all statements and result sets.

Question 10

What is wrong with the following statement?
ResultSet result = statement.execute("SELECT * FROM emp WHERE empNum = '5'");

Accepted Answer

A) ResultSet should be String 
B) execute should be executeQuery 
C) execute should be prepareStatement 
D) 5 should not be used as an empNum value 
A) ResultSet should be String 
B) execute should be executeQuery 
C) execute should be prepareStatement 
D) 5 should not be used as an empNum value

Question 11

The ______ clause is used to select data that fulfill a condition.

Accepted Answer

A) SELECT 
B) FROM 
C) WHEN 
D) WHERE 
A) SELECT 
B) FROM 
C) WHEN 
D) WHERE

Question 12

When you first get a result set from the executeQuery method, you need to call ____ to move to the first row

Accepted Answer

A) first() 
B) start() 
C) move() 
D) next() 
A) first() 
B) start() 
C) move() 
D) next()

Question 13

The acronym JDBC stands for ________:

Accepted Answer

A) Joint Data Base Center 
B) Java Database Control 
C) Joint Database Connectivity 
D) Java Database Connectivity 
A) Joint Data Base Center 
B) Java Database Control 
C) Joint Database Connectivity 
D) Java Database Connectivity

Question 14

All database URLs have the format:

Accepted Answer

A) jdbc:subprotocol:driver-specific data 
B) jdbc/subprotocol/driver/data 
C) oracle.jdbc.driver.OracleDriver 
D) c:\jdk1.7.0\db\lib\driver.jar 
A) jdbc:subprotocol:driver-specific data 
B) jdbc/subprotocol/driver/data 
C) oracle.jdbc.driver.OracleDriver 
D) c:\jdk1.7.0\db\lib\driver.jar

Question 15

Which of the following would be a good primary key for a Course table designed to hold course information for a university?

Accepted Answer

A) CourseName 
B) CourseID 
C) CourseCredit 
D) CoursePrerequisites 
A) CourseName 
B) CourseID 
C) CourseCredit 
D) CoursePrerequisites

Question 16

What will the following expression match to?
Name LIKE 'e_%'

Accepted Answer

A) all strings in the Name column that have at least 3 characters. 
B) all strings in the Name column whose first letter is an "e". 
C) all strings in the Name column that start with the letter "e" and end with underscore. 
D) all strings in the Name column whose second letter is any character. 
A) all strings in the Name column that have at least 3 characters. 
B) all strings in the Name column whose first letter is an "e". 
C) all strings in the Name column that start with the letter "e" and end with underscore. 
D) all strings in the Name column whose second letter is any character.

Question 17

To fetch a column in a result set that stores prices, use the ______ method.

Accepted Answer

A) nextInt() 
B) getInt() 
C) nextDouble() 
D) getDouble() 
A) nextInt() 
B) getInt() 
C) nextDouble() 
D) getDouble()

Question 18

What should the database.properties file contain so you can connect to a database?

Accepted Answer

A) a database URL, user name, password 
B) a database URL, the program name, and a JDBC driver 
C) a database URL, the program name, and database name 
D) the JDBC driver path 
A) a database URL, user name, password 
B) a database URL, the program name, and a JDBC driver 
C) a database URL, the program name, and database name 
D) the JDBC driver path

Question 19

Why should we use try-with-resources to open a Connection to a database?

Accepted Answer

A) To commit the changes 
B) To display the ResultSet 
C) To display the metadata 
D) To close the connection 
A) To commit the changes 
B) To display the ResultSet 
C) To display the metadata 
D) To close the connection

Question 20

The outcome of a SELECT query is a _________ that you can view and analyze.

Accepted Answer

A) table 
B) list 
C) result set 
D) subquery 
A) table 
B) list 
C) result set 
D) subquery

Exam 24: Relational Databases

In SQL, ____ is used to test for equality.

What is the purpose of a primary key?

One of the steps for testing the JDBC driver is:

A ____________ is a set of rows and columns that provides a "window" through which you can see some of the database data.

Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________. Customer table

When you are done with a Statement object, _______.

Used with the LIKE operator, the ______ symbol matches exactly one character.

If your program needs to look at several result sets at the same time, _____.

When you close a connection:

What is wrong with the following statement? ResultSet result = statement.execute("SELECT * FROM emp WHERE empNum = '5'");

The ______ clause is used to select data that fulfill a condition.

When you first get a result set from the executeQuery method, you need to call ____ to move to the first row

The acronym JDBC stands for ________:

All database URLs have the format:

Which of the following would be a good primary key for a Course table designed to hold course information for a university?

What will the following expression match to? Name LIKE 'e_%'

To fetch a column in a result set that stores prices, use the ______ method.

What should the database.properties file contain so you can connect to a database?

Why should we use try-with-resources to open a Connection to a database?

The outcome of a SELECT query is a _________ that you can view and analyze.

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