Question 1

What is the name of a key in one table that is required to matche a primary key in another table?

Accepted Answer

A)  Foreign key. 
B)  Matching key. 
C)  Joined key. 
D)  Linking key. 
A)  Foreign key. 
B)  Matching key. 
C)  Joined key. 
D)  Linking key. A

Question 2

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. B

Question 3

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 (%) B

Question 4

Pattern matching in a SQL query is performed with which clause?

Accepted Answer

A)  FROM. 
B)  WHERE. 
C)  SELECT. 
D)  LIKE. 
A)  FROM. 
B)  WHERE. 
C)  SELECT. 
D)  LIKE.

Question 5

Which SQL keyword is used to merge rows from multiple tables?

Accepted Answer

A)  JOIN. 
B)  INNER JOIN. 
C)  GROUP. 
D)  MERGE. 
A)  JOIN. 
B)  INNER JOIN. 
C)  GROUP. 
D)  MERGE.

Question 6

Which statement is false?

Accepted Answer

A)  Interface JdbcRowSet is in the javax.rowset package. 
B)  A CachedRowSet object is scrollable and updatable by default. 
C)  A JdbcRowSet object is scrollable and updatable by default. 
D)  JdbcRowSet is a connected RowSet. 
A)  Interface JdbcRowSet is in the javax.rowset package. 
B)  A CachedRowSet object is scrollable and updatable by default. 
C)  A JdbcRowSet object is scrollable and updatable by default. 
D)  JdbcRowSet is a connected RowSet.

Question 7

What is the relationship between a primary key and its corresponding foreign keys?

Accepted Answer

A)  One-to-one. 
B)  Many-to-one. 
C)  Many-to-many. 
D)  One-to-many. 
A)  One-to-one. 
B)  Many-to-one. 
C)  Many-to-many. 
D)  One-to-many.

Question 8

When joining tables, the _________ clause specifies the columns from each table that are compared to determine which rows are merged.

Accepted Answer

A)  ON 
B)  WHERE 
C)  LIKE 
D)  GROUP 
A)  ON 
B)  WHERE 
C)  LIKE 
D)  GROUP

Question 9

Classes and interfaces for the JDBC API can be found in which package?

Accepted Answer

A)  java.jdbc. 
B)  javax.jdbc. 
C)  java.sql. 
D)  java.sql.jdbc. 
A)  java.jdbc. 
B)  javax.jdbc. 
C)  java.sql. 
D)  java.sql.jdbc.

Question 10

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 11

A ________ is a column (or set of columns) which have a unique value that cannot be duplicated in other rows?

Accepted Answer

A)  primary key. 
B)  query. 
C)  SQL statement. 
D)  lookup value. 
A)  primary key. 
B)  query. 
C)  SQL statement. 
D)  lookup value.

Question 12

Selection criteria can be added to a SQL query using which keyword?

Accepted Answer

A)  FROM. 
B)  WHERE. 
C)  SELECT. 
D)  LIKE. 
A)  FROM. 
B)  WHERE. 
C)  SELECT. 
D)  LIKE.

Question 13

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

Accepted Answer

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

Question 14

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 15

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 16

The result of a query can be sorted by using the optional _________ clause.

Accepted Answer

A)  ORDER BY 
B)  ORDER 
C)  SORT BY 
D)  SORT 
A)  ORDER BY 
B)  ORDER 
C)  SORT BY 
D)  SORT

Question 17

If a query includes columns from multiple tables that have the same name, the statement must precede those column names with _________.

Accepted Answer

A)  their database names. 
B)  their database names and a dot. 
C)  their table names and a dot. 
D)  their table names. 
A)  their database names. 
B)  their database names and a dot. 
C)  their table names and a dot. 
D)  their table names.

Question 18

Java programs communicate with databases using what API?

Accepted Answer

A)  DBMS. 
B)  JDBC. 
C)  RDBMS. 
D)  Database. 
A)  DBMS. 
B)  JDBC. 
C)  RDBMS. 
D)  Database.

Question 19

An 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 20

Transaction processing enables a program to treat a database operation, or set of operations, as single operation. This is known as a(n) ________ or a(n) ________.

Accepted Answer

A)  atomic operation, unique operation. 
B)  unique operation, transaction. 
C)  atomic operation, transaction. 
D)  None of the above. 
A)  atomic operation, unique operation. 
B)  unique operation, transaction. 
C)  atomic operation, transaction. 
D)  None of the above.

Exam 23: Accessing Databases With Jdbc

What is the name of a key in one table that is required to matche a primary key in another table?

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

SQL uses the _________ as a delimiter for strings.

Pattern matching in a SQL query is performed with which clause?

Which SQL keyword is used to merge rows from multiple tables?

Which statement is false?

What is the relationship between a primary key and its corresponding foreign keys?

When joining tables, the _________ clause specifies the columns from each table that are compared to determine which rows are merged.

Classes and interfaces for the JDBC API can be found in which package?

Which statement is false?

A ________ is a column (or set of columns) which have a unique value that cannot be duplicated in other rows?

Selection criteria can be added to a SQL query using which keyword?

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

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

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

The result of a query can be sorted by using the optional _________ clause.

If a query includes columns from multiple tables that have the same name, the statement must precede those column names with _________.

Java programs communicate with databases using what API?

An a PreparedStatement, parameters are counted from position ________.

Transaction processing enables a program to treat a database operation, or set of operations, as single operation. This is known as a(n) ________ or a(n) ________.

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 treat a database operation, or set of operations, as single operation. This is known as a(n) or a(n) .