Deck 24: Accessing Databases With Jdbc

Question 1

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

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

Answer 1

B

Question 2

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

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

Answer 2

B

Question 3

Which SQL keyword is required in every query?

A)FROM.
B)WHERE.
C)ORDER BY.
D)LIKE.

Answer 3

A

Question 4

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

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

Question 5

Which symbol indicates that all columns should be retrieved?

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

Question 6

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

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

Question 7

SQL uses the _________ as a delimiter for strings.

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

Question 8

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

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

Question 9

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

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

Question 10

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

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

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

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

Question 12

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

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

Question 13

Which of the following states the Rule of Entity Integrity?

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 14

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

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

Question 15

The default sort order in a sorted query is _________.

A)ascending
B)descending
C)natural
D)None of the above

Question 16

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

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

Question 17

Java programs communicate with databases using what API?

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

Question 18

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

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

Question 19

What does a primary key do?

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 20

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

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

Question 21

PreparedStatement method ________ returns a ResultSet.

A)executeUpdate
B)executeQuery
C)execute
D)None of the above.

Question 22

SQL statements that are stored in a database can be invoked using an object that implements interface ________.

A)Callable
B)StoredStatement
C)CallableStatement
D)Connection

Question 23

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

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 24

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

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

Question 25

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

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

Question 26

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

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

Question 27

Initially,a ResultSet cursor is positioned _________.

A)before the first row
B)at the first row
C)at the last row
D)after the last row

Question 28

Which statement is false?

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 29

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

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

Question 30

What are individual SQL statements saved in a database called?

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

Question 31

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

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

Question 32

Which statement is false?

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 33

In a PreparedStatement,parameters are counted from position ________.

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

Question 34

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

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 35

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)________.

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