Question 1

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 2

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 3

You can use the generic ____ method to execute arbitrary SQL statements.

Accepted Answer

A)  setString() 
B)  prepareStatement() 
C)  executeQuery() 
D)  execute() 
A)  setString() 
B)  prepareStatement() 
C)  executeQuery() 
D)  execute()

Question 4

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 5

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 6

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 7

What should be on the class path when you launch a Java program that accesses a database?

Accepted Answer

A)  the JDBC driver 
B)  the derby.jar file 
C)  the user name and password 
D)  the JDK 
A)  the JDBC driver 
B)  the derby.jar file 
C)  the user name and password 
D)  the JDK

Question 8

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 9

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 10

Which of the following statements is correct?

Accepted Answer

A)  SQL uses double quotes (") to delimit strings. 
B)  The SQL command INSERT AT adds data to a database 
C)  SQL is not case sensitive. 
D)  SQL is a part of the Java API. 
A)  SQL uses double quotes (") to delimit strings. 
B)  The SQL command INSERT AT adds data to a database 
C)  SQL is not case sensitive. 
D)  SQL is a part of the Java API.

Question 11

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 12

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 13

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 14

In SQL, ____ is used to test for equality.

Accepted Answer

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

Question 15

Which of the following table attributes could be a unique identifier for a person?

Accepted Answer

A)  Name 
B)  SocialSecurityNumber 
C)  State 
D)  Birthday 
A)  Name 
B)  SocialSecurityNumber 
C)  State 
D)  Birthday

Question 16

To fetch a column in a result set that stores the number of children, use the ______ method.

Accepted Answer

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

Question 17

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 18

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 19

Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________. Customer table

Accepted Answer

A)  SELECT * FROM Customer 
B)  SELECT Name, Address, City, State, Zip INTO Customer 
C)  SELECT FROM Customer FIELDS Name, Address, City, State, Zip 
D)  SELECT Name, Address, City, State, Zip FROM Customer 
A)  SELECT * FROM Customer 
B)  SELECT Name, Address, City, State, Zip INTO Customer 
C)  SELECT FROM Customer FIELDS Name, Address, City, State, Zip 
D)  SELECT Name, Address, City, State, Zip FROM Customer

Question 20

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

Exam 23: Relational Databases

When you are done with a Statement object, _______.

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

You can use the generic ____ method to execute arbitrary SQL statements.

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 of the following would be a good primary key for a Course table designed to hold course information for a university?

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

What should be on the class path when you launch a Java program that accesses a database?

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

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

Which of the following statements is correct?

All database URLs have the format:

Apache Derby is an example of a:

Metadata are ______

In SQL, ____ is used to test for equality.

Which of the following table attributes could be a unique identifier for a person?

To fetch a column in a result set that stores the number of children, use the ______ method.

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

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 following table, the query that gets the names and complete mailing addresses of all customers is ____________________. Customer table

Database tables store rows that contain the following except

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