Question 1

Which constants are used to indicate that a ResultSet is scrollable,insensitive to changes and read only?

Accepted Answer

A) TYPE_SCROLLABLE_INSENSITIVE,CONCUR_READ_ONLY. 
B) TYPE_SCROLLABLEINSENSITIVE,CONCUR_READONLY. 
C) TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY. 
D) TYPE_SCROLL_INSENSITIVE,CONCUR_READONLY. 
A) TYPE_SCROLLABLE_INSENSITIVE,CONCUR_READ_ONLY. 
B) TYPE_SCROLLABLEINSENSITIVE,CONCUR_READONLY. 
C) TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY. 
D) TYPE_SCROLL_INSENSITIVE,CONCUR_READONLY.

Question 2

In a PreparedStatement,parameters are counted from position ________.

Accepted Answer

A) 0 
B) 1 
C) 2 
D) 3 
A) 0 
B) 1 
C) 2 
D) 3

Question 3

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 4

Which statement is false?

Accepted Answer

A) A DELETE statement removes rows from a table. 
B) A DELETE statement must specify the table from which to delete. 
C) A DELETE statement starts with the keyword DELETE. 
D) A WHERE clause must be present in a DELETE statement. 
A) A DELETE statement removes rows from a table. 
B) A DELETE statement must specify the table from which to delete. 
C) A DELETE statement starts with the keyword DELETE. 
D) A WHERE clause must be present in a DELETE statement.

Question 5

SQL uses the _________ as a delimiter for strings.

Accepted Answer

A) double quotes (" and ") 
B) single quotes (' and ') 
C) underscore (-) 
D) percent (%) 
A) double quotes (" and ") 
B) single quotes (' and ') 
C) underscore (-) 
D) percent (%)

Question 6

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 7

To obtain data from a table,you ________ the database?

Accepted Answer

A) select 
B) query 
C) get 
D) None of the above 
A) select 
B) query 
C) get 
D) None of the above

Question 8

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 9

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 10

Which of the following is a key benefit of using JDBC?

Accepted Answer

A) It is a simple-to-use database management system. 
B) Allows developers to change the underlying database without modifying the Java code. 
C) It is a multi-platform database management system. 
D) It provides a GUI for database management systems. 
A) It is a simple-to-use database management system. 
B) Allows developers to change the underlying database without modifying the Java code. 
C) It is a multi-platform database management system. 
D) It provides a GUI for database management systems.

Question 11

Which symbol indicates that all columns should be retrieved?

Accepted Answer

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

Question 12

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 13

What exception is thrown if the class loader cannot locate the driver class?

Accepted Answer

A) NoSuchClassException. 
B) ClassCastException. 
C) ClassNotFoundException. 
D) IllegalClassException. 
A) NoSuchClassException. 
B) ClassCastException. 
C) ClassNotFoundException. 
D) IllegalClassException.

Question 14

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 15

To retrieve specific columns from a table,use _________ to separate the column names.

Accepted Answer

A) (?) 
B) * 
C)  , 
D) - 
A) (?) 
B) * 
C)  , 
D) -

Which constants are used to indicate that a ResultSet is scrollable,insensitive to changes and read only?

In a PreparedStatement,parameters are counted from position ________.

What does a primary key do?

Which statement is false?

SQL uses the _________ as a delimiter for strings.

The default sort order in a sorted query is _________.

To obtain data from a table,you ________ the database?

What are individual SQL statements saved in a database called?

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

Which of the following is a key benefit of using JDBC?

Which symbol indicates that all columns should be retrieved?

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

What exception is thrown if the class loader cannot locate the driver class?

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

To retrieve specific columns from a table,use _________ to separate the column names.

Introduction to Computers and Java

Introduction to Java Applications

Introduction to Classes and Objects

Control Statements: Part 1

Control Statements: Part 2

Methods: a Deeper Look

Arrays and Arraylists

Classes and Objects: a Deeper Look

Object Oriented Programming: Inheritance

Object-Oriented Programming: Polymorphism

Exception Handling

Gui Components: Part 1

Graphics and Java 2D

Strings

Files,streams and Object Serialization

Generic Collections

Lambdas

Recursion

Searching, Sorting and Big O

Generic Classes and Methods

Custom Generic Data Structures

Concurrency

JavaFX

Filters

Exam 24: Accessing Databases With Jdbc

Which constants are used to indicate that a ResultSet is scrollable,insensitive to changes and read only?

In a PreparedStatement,parameters are counted from position ________.

What does a primary key do?

Which statement is false?

SQL uses the _________ as a delimiter for strings.

The default sort order in a sorted query is _________.

To obtain data from a table,you ________ the database?

What are individual SQL statements saved in a database called?

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

Which of the following is a key benefit of using JDBC?

Which symbol indicates that all columns should be retrieved?

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

What exception is thrown if the class loader cannot locate the driver class?

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

To retrieve specific columns from a table,use _________ to separate the column names.

Introduction to Computers and Java

Introduction to Java Applications

Introduction to Classes and Objects

Control Statements: Part 1

Control Statements: Part 2

Methods: a Deeper Look

Arrays and Arraylists

Classes and Objects: a Deeper Look

Object Oriented Programming: Inheritance

Object-Oriented Programming: Polymorphism

Exception Handling

Gui Components: Part 1

Graphics and Java 2D

Strings

Files,streams and Object Serialization

Generic Collections

Lambdas

Recursion

Searching, Sorting and Big O

Generic Classes and Methods

Custom Generic Data Structures

Concurrency

JavaFX

Filters

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