Question 1

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

Accepted Answer

A)  all strings in the Name column that end with "e". 
B)  all strings in the Name column whose second to last letter is an "e". 
C)  all strings in the Name column that start with the letter "e". 
D)  all strings in the Name column whose second letter is an "e". 
A)  all strings in the Name column that end with "e". 
B)  all strings in the Name column whose second to last letter is an "e". 
C)  all strings in the Name column that start with the letter "e". 
D)  all strings in the Name column whose second letter is an "e".

Question 2

The outcome of a SQL query is a ____________________.

Accepted Answer

A)  table 
B)  view of the data 
C)  list 
D)  subquery 
A)  table 
B)  view of the data 
C)  list 
D)  subquery

Question 3

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 4

Beginners are afraid of issuing complex SQL queries, so they are ______

Accepted Answer

A)  throwing away a major benefit of a relational database. 
B)  throwing an exception called badQueryException. 
C)  doing the right thing by avoiding those queries for efficiency. 
D)  taking advantage of the SQL benefits. 
A)  throwing away a major benefit of a relational database. 
B)  throwing an exception called badQueryException. 
C)  doing the right thing by avoiding those queries for efficiency. 
D)  taking advantage of the SQL benefits.

Question 5

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

Accepted Answer

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

Question 6

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 7

What statement will return the value of a given key from the configuration file? Assume props is of type Properties.

Accepted Answer

A)  String driver = props.getProperty("database.properties"); 
B)  Connection conn = SimpleDataSource.getProperty("database.properties"); 
C)  String driver = props.getProperty("jdbc.driver"); 
D)  Properties props = SampleDataSource.init("jdbc.driver"); 
A)  String driver = props.getProperty("database.properties"); 
B)  Connection conn = SimpleDataSource.getProperty("database.properties"); 
C)  String driver = props.getProperty("jdbc.driver"); 
D)  Properties props = SampleDataSource.init("jdbc.driver");

Question 8

An example of a desktop database is:

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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 11

What is the effect of the following statement? String product_code = 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 the product_code. 
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 the product_code. 
D)  it will return the name of the column.

Question 12

In SQL, the _____________ command is used to issue queries.

Accepted Answer

A)  QUERY 
B)  UPDATE 
C)  START 
D)  SELECT 
A)  QUERY 
B)  UPDATE 
C)  START 
D)  SELECT

Question 13

Based on the table below, the SQL statement that changes the last name of customer 3175 to Michael is _____________________. Customer table

Accepted Answer

A)  UPDATE Customer SET LastName = 'Michael' WHERE Customer_Number = 3175 
B)  UPDATE Customer SET Customer_Number = 3175 WHERE LastName = 'Michael' 
C)  UPDATE Customer table SET LastName = 'Michael' WHERE Customer_Number = 3175 
D)  UPDATE Customer SET FirstName = 'Susan' WHERE LastName = 'Michael' 
A)  UPDATE Customer SET LastName = 'Michael' WHERE Customer_Number = 3175 
B)  UPDATE Customer SET Customer_Number = 3175 WHERE LastName = 'Michael' 
C)  UPDATE Customer table SET LastName = 'Michael' WHERE Customer_Number = 3175 
D)  UPDATE Customer SET FirstName = 'Susan' WHERE LastName = 'Michael'

Question 14

What is one reason why you need a finally clause after a try/catch sequence that accesses 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 15

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

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

The outcome of a SQL query is a ____________________.

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

Beginners are afraid of issuing complex SQL queries, so they are ______

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

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

What statement will return the value of a given key from the configuration file? Assume props is of type Properties.

An example of a desktop database is:

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

One of the steps for testing the JDBC driver is:

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

In SQL, the _____________ command is used to issue queries.

Based on the table below, the SQL statement that changes the last name of customer 3175 to Michael is _____________________. Customer table

What is one reason why you need a finally clause after a try/catch sequence that accesses 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

Inputoutput and Exception Handling

Object-Oriented Design

Recursion

Sorting and Searching

The Java Collections Framework

Basic Data Structures

Tree Structures

Generic Classes

Graphical User Interfaces

Streams and Binary Inputoutput

Multithreading

Internet Networking

XML

Web Applications

Filters

Exam 23: Relational Databases

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

The outcome of a SQL query is a ____________________.

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

Beginners are afraid of issuing complex SQL queries, so they are ______

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

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

What statement will return the value of a given key from the configuration file? Assume props is of type Properties.

An example of a desktop database is:

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

One of the steps for testing the JDBC driver is:

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

In SQL, the _____________ command is used to issue queries.

Based on the table below, the SQL statement that changes the last name of customer 3175 to Michael is _____________________. Customer table

What is one reason why you need a finally clause after a try/catch sequence that accesses 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

Inputoutput and Exception Handling

Object-Oriented Design

Recursion

Sorting and Searching

The Java Collections Framework

Basic Data Structures

Tree Structures

Generic Classes

Graphical User Interfaces

Streams and Binary Inputoutput

Multithreading

Internet Networking

XML

Web Applications

Filters