Exam 23: Relational Databases

A ______ lets you fetch a query result, one row at a time.

An example of a production-quality database is:

What should the database.properties file contain so you can connect to a database?

A _____________ is a column (or set of columns) whose value uniquely specifies a table record.

In database terminology, a column (or combination of columns) that uniquely identifies a row in a table is called a(n) ____.

To fetch a column in a result set that stores prices, use the ______ method.

To get the number of columns in a result set, you use _________ method of the ResultSetMetaData class.

An example of a lightweight database is:

Based on the customer table below, which of the attributes do you think represents the primary key? Customer table

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

In SQL, the _____________ command is used to issue queries that do not modify the database.

In jdbc.URL, the acronym URL stands for:

Oracle is an example of a:

Based on the table below, which of the following statements will return the number of customers in Michigan (MI)? Customer table

Based on the table below, the query that finds all customers who do not live in Pleasantville is _________________. Customer table

Based on the table below, the query that finds the names and zip codes of all customers is _____________________. Customer table

In the table below, the ____ correspond(s) to the attributes of a customer in the database. Customer table

What does the following statement do? String prodCode = nextLine(in, "Product Code (D=Done, L=List)");

If your program needs to look at several result sets at the same time, _____.

What is wrong with the following statement? boolean result = statement.execute("SELECT * from emp WHERE empNum = '?'");