Exam 23: Relational Databases

Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________ Customer table

When you execute a rollback:

The acronym JDBC stands for ________:

Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________. Customer table

If you encounter an error during updating a transaction, then call the ______ method:

The ______ class has a next method to visit the next row of a query result.

What does the execute method return?

Microsoft Access is an example of a:

Which SQL command(s) modify the data in a database? I SELECT II INSERT III DELETE IV UPDATE

The following command will compile a Java program called TestDB:

What will the following command do? java -classpath derby.sql;. ExecSQL database.properties

When you close a connection:

If your statement has variable parts, you should use a _________ object.

Which Java statement connects to a database using a Connection object?

Given the following two statements, what does the call to the next() method return? ResultSet result = statement.executeQuery(); Result.next();

A ____________ is a reference to a primary key in a linked table.

"SQL injection attacks" have been responsible for many cases of data theft. One of the solutions is:

A ______________ object can create statement objects that are used to execute SQL commands.

What will the following expression match to? Name LIKE '%e%'

If you want to find out about properties of a result set from an unknown table, you need to use: