Question 1

Which of the following shows how a single quote is represented as part of a string in SQL?

Accepted Answer

A)  _' 
B)  "'" 
C)  /' 
D)  '' 
A)  _' 
B)  "'" 
C)  /' 
D)  ''

Question 2

In SQL, the equal to operator is ==, which is the same as Java.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

SQL does not provide functions for performing calculations.

Accepted Answer

A) True 
 B)False

Question 6

The DBMS works directly with the data, and sends the results of operations

Accepted Answer

A)  back to the application. 
B)  along the encrypted data path. 
C)  to the unified data component. 
D)  back to the Web server. 
A)  back to the application. 
B)  along the encrypted data path. 
C)  to the unified data component. 
D)  back to the Web server.

Question 7

What is the default concurrency level of a ResultSet object?

Accepted Answer

A)  Public 
B)  Updatable 
C)  Private 
D)  Read-only 
A)  Public 
B)  Updatable 
C)  Private 
D)  Read-only

Question 8

The data that is stored in a row is divided into which of the following?

Accepted Answer

A)  sections 
B)  tables 
C)  bytes 
D)  columns 
A)  sections 
B)  tables 
C)  bytes 
D)  columns

Question 9

The term commit refers to undoing changes to a database.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A)  contains the results of an SQL 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. 
A)  contains the results of an SQL 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.

Question 11

Which of the following is a Swing component that displays data in a two-dimensional table?

Accepted Answer

A)  JTable 
B)  JFrame 
C)  JPanel 
D)  JTable2D 
A)  JTable 
B)  JFrame 
C)  JPanel 
D)  JTable2D

Question 12

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 13

In SQL, you use this statement to delete one or more rows from a table.

Accepted Answer

A)  DELETE 
B)  DROP ROW 
C)  REMOVE 
D)  PURGE 
A)  DELETE 
B)  DROP ROW 
C)  REMOVE 
D)  PURGE

Question 14

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 15

SQL stands for

Accepted Answer

A)  structured query language. 
B)  standard equivalent language. 
C)  semiconductor qualified language. 
D)  simple equation library. 
A)  structured query language. 
B)  standard equivalent language. 
C)  semiconductor qualified language. 
D)  simple equation library.

Question 16

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

Accepted Answer

A)  JDBC driver 
B)  Database URL 
C)  JDBC locator 
D)  Database specifier 
A)  JDBC driver 
B)  Database URL 
C)  JDBC locator 
D)  Database specifier

Question 17

This SQL statement can be used to create a database table.

Accepted Answer

A)  NEW TABLE 
B)  MAKE TABLE 
C)  BUILD TABLE 
D)  CREATE TABLE 
A)  NEW TABLE 
B)  MAKE TABLE 
C)  BUILD TABLE 
D)  CREATE TABLE

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

In SQL, this is the not-equal-to operator.

Accepted Answer

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

Question 20

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

Accepted Answer

A)  GET 
B)  SELECT 
C)  READ 
D)  RETRIEVE 
A)  GET 
B)  SELECT 
C)  READ 
D)  RETRIEVE

Which of the following shows how a single quote is represented as part of a string in SQL?

In SQL, the equal to operator is ==, which is the same as Java.

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

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

SQL does not provide functions for performing calculations.

The DBMS works directly with the data, and sends the results of operations

What is the default concurrency level of a ResultSet object?

The data that is stored in a row is divided into which of the following?

The term commit refers to undoing changes to a database.

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

Which of the following is a Swing component that displays data in a two-dimensional table?

A qualified column name takes the following form:

In SQL, you use this statement to delete one or more rows from a table.

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

SQL stands for

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

This SQL statement can be used to create a database table.

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

In SQL, this is the not-equal-to operator.

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

Introduction to Computers and Java

Java Fundamentals

A First Look at Classes and Objects

Decision Structures

Loops and Files

A Second Look at Classes and Objects

Arrays and the ArrayList Class

Text Processing and Wrapper Classes

Inheritance

Exceptions and Advanced File I/O

GUI Applications–Part 1

GUI Applications–Part 2

Applets and More

Creating GUI Applications with JavaFX

Recursion

Filters

Exam 16: Databases

Which of the following shows how a single quote is represented as part of a string in SQL?

In SQL, the equal to operator is ==, which is the same as Java.

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

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

SQL does not provide functions for performing calculations.

The DBMS works directly with the data, and sends the results of operations

What is the default concurrency level of a ResultSet object?

The data that is stored in a row is divided into which of the following?

The term commit refers to undoing changes to a database.

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

Which of the following is a Swing component that displays data in a two-dimensional table?

A qualified column name takes the following form:

In SQL, you use this statement to delete one or more rows from a table.

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

SQL stands for

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

This SQL statement can be used to create a database table.

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

In SQL, this is the not-equal-to operator.

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

Introduction to Computers and Java

Java Fundamentals

A First Look at Classes and Objects

Decision Structures

Loops and Files

A Second Look at Classes and Objects

Arrays and the ArrayList Class

Text Processing and Wrapper Classes

Inheritance

Exceptions and Advanced File I/O

GUI Applications–Part 1

GUI Applications–Part 2

Applets and More

Creating GUI Applications with JavaFX

Recursion

Filters