Question 1

JDBC supports _______, so you do not need to manually load the database driver before accessing a database.

Accepted Answer

A)  automatic driver downloading 
B)  automatic driver creation 
C)  automatic driver discovery 
D)  None of the above. 
A)  automatic driver downloading 
B)  automatic driver creation 
C)  automatic driver discovery 
D)  None of the above.

Question 2

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 3

In an UPDATE statement, the SET keyword is followed by _________.

Accepted Answer

A)  a comma-separated list of column value-name pairs in the format value = columnName 
B)  a comma-separated list of column name-value pairs in the format columnName = value 
C)  a semicolon-separated list of column value-name pairs in the format value = columnName 
D)  a semicolon-separated list of column name-value pairs in the format columnName = value 
A)  a comma-separated list of column value-name pairs in the format value = columnName 
B)  a comma-separated list of column name-value pairs in the format columnName = value 
C)  a semicolon-separated list of column value-name pairs in the format value = columnName 
D)  a semicolon-separated list of column name-value pairs in the format columnName = value

Question 4

This keyword is used to add a row to a table.

Accepted Answer

A)  INSERT. 
B)  ADD. 
C)  UPDATE. 
D)  CREATE. 
A)  INSERT. 
B)  ADD. 
C)  UPDATE. 
D)  CREATE.

Question 5

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 6

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 7

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

Question 8

What exception is thrown if DriverManager method getConnection cannot connect to the database?

Accepted Answer

A)  DatabaseConnectionException. 
B)  DatabaseNotFoundException. 
C)  SQLException. 
D)  IllegalAccessException. 
A)  DatabaseConnectionException. 
B)  DatabaseNotFoundException. 
C)  SQLException. 
D)  IllegalAccessException.

Question 9

What are individual SQL statements saved in a database called?

Accepted Answer

A)  Stored statements. 
B)  Stored queries. 
C)  Stored commands. 
D)  Stored procedures. 
A)  Stored statements. 
B)  Stored queries. 
C)  Stored commands. 
D)  Stored procedures.

Question 10

Transaction processing enables a program to ________ or ________ a transaction based on whether the transaction was successful.

Accepted Answer

A)  save, delete 
B)  commit, rollback 
C)  save, rollback 
D)  commit, delete 
A)  save, delete 
B)  commit, rollback 
C)  save, rollback 
D)  commit, delete

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 does a primary key do?

Accepted Answer

A)  Identifies each row of a table. 
B)  Selects a number of rows from a database. 
C)  Stores a bunch of related data. 
D)  None of the above. 
A)  Identifies each row of a table. 
B)  Selects a number of rows from a database. 
C)  Stores a bunch of related data. 
D)  None of the above.

Question 13

An implementation of the _________ interface configures the database connection and prepares query statements automatically.

Accepted Answer

A)  ResultSet 
B)  RowSet 
C)  Both of the above 
D)  Neither of the above 
A)  ResultSet 
B)  RowSet 
C)  Both of the above 
D)  Neither of the above

Question 14

Which symbol indicates that all columns should be retrieved?

Accepted Answer

A)  (?) 
B)  (*) 
C)  (+) 
D)  (/) 
A)  (?) 
B)  (*) 
C)  (+) 
D)  (/)

Exam 23: Accessing Databases With Jdbc

JDBC supports _______, so you do not need to manually load the database driver before accessing a database.

Which of the following states the Rule of Entity Integrity?

In an UPDATE statement, the SET keyword is followed by _________.

This keyword is used to add a row to a table.

PreparedStatement method ________ returns a ResultSet.

Which SQL keyword is required in every query?

Initially, a ResultSet cursor is positioned _________.

What exception is thrown if DriverManager method getConnection cannot connect to the database?

What are individual SQL statements saved in a database called?

Transaction processing enables a program to ________ or ________ a transaction based on whether the transaction was successful.

The default sort order in a sorted query is _________.

What does a primary key do?

An implementation of the _________ interface configures the database connection and prepares query statements automatically.

Which symbol indicates that all columns should be retrieved?

Introduction to Computers, the Internet and Java

Introduction to Java Applications; Inputoutput and Operators

Introduction to Classes, Objects, Methods and Strings

Control Statements: Assignment, and Operators

Control Statements: Logical Operators

Methods: a Deeper Look

Arrays and Arraylists

Classes and Objects: a Deeper Look

Object-Oriented Programming: Inheritance

Object-Oriented Programming: Polymorphism and Interfaces

Exception Handling: a Deeper Look

Javafx Graphical User Interfaces

Javafx Gui

Strings, Characters and Regular Expressions

Files, Inputoutput Streams, Nio and Xml Serialization

Generic Collections

Lambdas and Streams

Recursion

Searching, Sorting and Big O

Generic Classes and Methods: a Deeper Look

Custom Generic Data Structures

Concurrency

Swing Gui Components

Graphics and Java 2d

Networking

Java Persistence Api Jpa

Javaserver Faces Web Apps

Javaserver Faces Web Apps

Swing Gui Components

Filters

Transaction processing enables a program to or a transaction based on whether the transaction was successful.