Deck 28: Accessing Databases With Jdbc

Question 1

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.

Answer 1

A

Question 2

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

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

Answer 2

D

Question 3

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

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

Answer 3

B

Question 4

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 5

Java programs communicate with databases using what API?

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

Question 6

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 7

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 8

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

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

Question 9

Which symbol indicates that all columns should be retrieved?

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

Question 10

Which SQL keyword is required in every query?

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

Question 11

SQL uses the _________ as a delimiter for strings.

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

Question 12

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 13

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

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

Question 14

The default sort order in a sorted query is _________.

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

Question 15

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 16

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

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

Question 17

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

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

Question 18

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 19

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 20

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

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

Question 21

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 22

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 23

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 24

PreparedStatement method ________ returns a ResultSet.

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

Question 25

What are individual SQL statements saved in a database called?

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

Question 26

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 27

In a PreparedStatement,parameters are counted from position ________.

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

Question 28

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

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

Question 29

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 30

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.

Question 31

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 32

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 33

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 34

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 35

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.