QUESTION 1

What will happen if you try to store duplicate data in a primary key column?

	a.	The column is duplicated.
	b.	An error will occur.
	c.	The duplicate data will have concurrency issues
	d.	The primary key column will not display the duplicate data.

1 points

QUESTION 2

This type of SQL statement is used to retrieve the rows from a table.

	a.	GET
	b.	SELECT
	c.	RETRIEVE
	d.	READ

1 points

QUESTION 3

A result set is an object that is somewhat similar to a collection and

	a.	contains the results of an SQL Select statement.
	b.	allows the program to execute an SQL statement.
	c.	predicts the outcome of an SQL statement.
	d.	provides rules for how an SQL statement should be executed.

1 points

QUESTION 4

What does JDBC stand for?

	a.	Java data binary collection
	b.	Java database connectivity
	c.	Java database collection
	d.	Java data basic computation

1 points

QUESTION 5

What string lists the protocol that should be used to access a database, the name of the database, and potentially other items?

	a.	JDBC driver
	b.	Database URL
	c.	JDBC locator
	d.	Database specifier

1 points

QUESTION 6

Which Statement interface method should be used to execute a SELECT statement?

	a.	executeSQL
	b.	executeStatement
	c.	executeUpdate
	d.	executeQuery

1 points

QUESTION 7

Which Statement interface method should be used to execute an INSERT statement?

	a.	execute
	b.	executeStatement
	c.	executeQuery
	d.	executeSQL

1 points

QUESTION 8

What term refers to data that describes other data?

	a.	Pseudo-data
	b.	Micro data
	c.	Abstract data
	d.	Meta data

1 points

QUESTION 9

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.

1 points

QUESTION 10

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.

1 points

QUESTION 11

What exception is thrown if a syntax error is in the SQL query that is beining invoked by the JDBCs executeQuery method?

	a.	NoSuchClassException
	b.	ClassCastException.
	c.	SQLException
	d.	IllegalClassException.