Question 1

To what package does the Connection interface belong?

Accepted Answer

A)  java.swing 
B)  java.awt 
C)  java.sql 
D)  java.io 
A)  java.swing 
B)  java.awt 
C)  java.sql 
D)  java.io C

Question 2

No two rows in a table can have the same value in the primary key column

Accepted Answer

A) True 
 B)False  True

Question 3

In SQL, the REFERENCES qualifier ensures referential integrity between tables.

Accepted Answer

A) True 
 B)False  True

Question 4

If you wish to sort the results of an SQL query, you can use the ________ clause.

Accepted Answer

A)  SORT BY 
B)  ALIGN ROW 
C)  ORDER BY 
D)  ASCEND 
A)  SORT BY 
B)  ALIGN ROW 
C)  ORDER BY 
D)  ASCEND

Question 5

What is determined by the following code?
ResultSet.last();
Int numRows = resultSet.getRow();
ResultSet.first();

Accepted Answer

A)  the number of rows in the result set 
B)  the number of columns in the result set 
C)  the value of the cursor's current position 
D)  the sum of all rows in the result set 
A)  the number of rows in the result set 
B)  the number of columns in the result set 
C)  the value of the cursor's current position 
D)  the sum of all rows in the result set

Question 6

A qualified column name takes the following form:

Accepted Answer

A)  ColumnName.TableName 
B)  TableName.ColumnName 
C)  RowName.TableName 
D)  DatabaseURL.ColumnName 
A)  ColumnName.TableName 
B)  TableName.ColumnName 
C)  RowName.TableName 
D)  DatabaseURL.ColumnName

Question 7

What SQL operator can be used to disqualify search criteria in a WHERE clause?

Accepted Answer

A)  AND 
B)  NOT 
C)  EXCLUDE 
D)  NOR 
A)  AND 
B)  NOT 
C)  EXCLUDE 
D)  NOR

Question 8

In SQL, the not equal-to operator is:

Accepted Answer

A)  != 
B)  NOT 
C)  || 
D)   
A)  != 
B)  NOT 
C)  || 
D)

Question 9

You use this statement in SQL to insert a new row into a table:

Accepted Answer

A)  UPDATE 
B)  ADD 
C)  NEW 
D)  INSERT 
A)  UPDATE 
B)  ADD 
C)  NEW 
D)  INSERT

Question 10

The columns in a table are assigned SQL data types.

Accepted Answer

A) True 
 B)False

Question 11

SQL does not provide functions for performing calculations.

Accepted Answer

A) True 
 B)False

Question 12

What do most developers prefer to use when developing applications that work with an intensive amount of data?

Accepted Answer

A)  Text files 
B)  Binary files 
C)  A database management system 
D)  Java DB 
A)  Text files 
B)  Binary files 
C)  A database management system 
D)  Java DB

Question 13

Which SQL statement is used to delete a table from a database?

Accepted Answer

A)  REM TABLE 
B)  DEL TABLE 
C)  DROP TABLE 
D)  ERASE TABLE 
A)  REM TABLE 
B)  DEL TABLE 
C)  DROP TABLE 
D)  ERASE TABLE

Question 14

What SQL operator can be used to perform a search for a substring?

Accepted Answer

A)  STR 
B)  LIKE 
C)  WHERE 
D)  SUB 
A)  STR 
B)  LIKE 
C)  WHERE 
D)  SUB

Question 15

SQL statements that are stored in the DBMS are called resident queries.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A)  executeUpdate 
B)  executeStatement 
C)  executeQuery 
D)  executeSQL 
A)  executeUpdate 
B)  executeStatement 
C)  executeQuery 
D)  executeSQL

Question 17

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

Accepted Answer

A)  executeSQL 
B)  executeStatement 
C)  executeUpdate 
D)  executeQuery 
A)  executeSQL 
B)  executeStatement 
C)  executeUpdate 
D)  executeQuery

Question 18

In a transaction, all updates to database must be successfully executed.

Accepted Answer

A) True 
 B)False

Question 19

What term refers to data that describes other data?

Accepted Answer

A)  Pseudo-data 
B)  Micro data 
C)  Abstract data 
D)  Meta data 
A)  Pseudo-data 
B)  Micro data 
C)  Abstract data 
D)  Meta data

Question 20

What must you have installed on your system before you can use JDBC to access a database?

Accepted Answer

A)  DBMS 
B)  Java 
C)  Both A and B 
D)  Neither A nor B 
A)  DBMS 
B)  Java 
C)  Both A and B 
D)  Neither A nor B

To what package does the Connection interface belong?

No two rows in a table can have the same value in the primary key column

In SQL, the REFERENCES qualifier ensures referential integrity between tables.

If you wish to sort the results of an SQL query, you can use the ________ clause.

What is determined by the following code? ResultSet.last(); Int numRows = resultSet.getRow(); ResultSet.first();

A qualified column name takes the following form:

What SQL operator can be used to disqualify search criteria in a WHERE clause?

In SQL, the not equal-to operator is:

You use this statement in SQL to insert a new row into a table:

The columns in a table are assigned SQL data types.

SQL does not provide functions for performing calculations.

What do most developers prefer to use when developing applications that work with an intensive amount of data?

Which SQL statement is used to delete a table from a database?

What SQL operator can be used to perform a search for a substring?

SQL statements that are stored in the DBMS are called resident queries.

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

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

In a transaction, all updates to database must be successfully executed.

What term refers to data that describes other data?

What must you have installed on your system before you can use JDBC to access a database?

Introduction to Computers and Java

Java Fundamentals

Decision Structures

Loops and Files

Methods

A First Look at Classes

Arrays and the Arraylist Class

A Second Look at Classes and Objects

Text Processing and More About Wrapper Classes

Inheritance

Exceptions and Advanced File IO

A First Look at GUI Applications

Advanced GUI Applications

Applets and More

Creating GUI Applications With Javafx and Scene Builder

Recursion

Filters

Exam 17: Databases

To what package does the Connection interface belong?

No two rows in a table can have the same value in the primary key column

In SQL, the REFERENCES qualifier ensures referential integrity between tables.

If you wish to sort the results of an SQL query, you can use the ________ clause.

What is determined by the following code? ResultSet.last(); Int numRows = resultSet.getRow(); ResultSet.first();

A qualified column name takes the following form:

What SQL operator can be used to disqualify search criteria in a WHERE clause?

In SQL, the not equal-to operator is:

You use this statement in SQL to insert a new row into a table:

The columns in a table are assigned SQL data types.

SQL does not provide functions for performing calculations.

What do most developers prefer to use when developing applications that work with an intensive amount of data?

Which SQL statement is used to delete a table from a database?

What SQL operator can be used to perform a search for a substring?

SQL statements that are stored in the DBMS are called resident queries.

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

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

In a transaction, all updates to database must be successfully executed.

What term refers to data that describes other data?

What must you have installed on your system before you can use JDBC to access a database?

Introduction to Computers and Java

Java Fundamentals

Decision Structures

Loops and Files

Methods

A First Look at Classes

Arrays and the Arraylist Class

A Second Look at Classes and Objects

Text Processing and More About Wrapper Classes

Inheritance

Exceptions and Advanced File IO

A First Look at GUI Applications

Advanced GUI Applications

Applets and More

Creating GUI Applications With Javafx and Scene Builder

Recursion

Filters