Question 1

Which of the following is the Statement interface method that should be used to execute an INSERT statement.

Accepted Answer

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

Question 2

Although SQL is a language, you don't use it to write applications.

Accepted Answer

A) True 
 B)False  True

Question 3

Which of the following is the not-equal-to operator in SQL?

Accepted Answer

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

Question 4

__________ refers to data that describes other data.

Accepted Answer

A)  pseudodata 
B)  microdata 
C)  abstract data 
D)  metadata 
A)  pseudodata 
B)  microdata 
C)  abstract data 
D)  metadata

Question 5

In SQL, the __________ statement is used 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 6

The standard lanuage for working with database management systems is __________.

Accepted Answer

A)  SQL 
B)  BASIC 
C)  ADA 
D)  COBOL 
A)  SQL 
B)  BASIC 
C)  ADA 
D)  COBOL

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

The __________ 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 9

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 10

A column in one table that references a primary key in another table is known as a __________.

Accepted Answer

A)  secondary key 
B)  foreign key 
C)  referential key 
D)  meta key 
A)  secondary key 
B)  foreign key 
C)  referential key 
D)  meta key

Question 11

Which of the following can be used as a wildcard to represent a single character in SQL?

Accepted Answer

A)  percent sign ( % ) 
B)  dollar sign ( $ ) 
C)  underscore ( _ ) 
D)  asterisk ( * ) 
A)  percent sign ( % ) 
B)  dollar sign ( $ ) 
C)  underscore ( _ ) 
D)  asterisk ( * )

Question 12

The term commit refers to undoing changes in a database.

Accepted Answer

A) True 
 B)False

Question 13

To sort the results of a 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 14

A qualified column name takes the 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 15

The data that is stored in a row of a database is divided into __________.

Accepted Answer

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

Question 16

The __________ 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 17

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

Accepted Answer

A)  The column will be 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. 
A)  The column will be 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.

Question 18

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

Accepted Answer

A)  contains the result of a SQL statement 
B)  allows the program to execute a SQL statement 
C)  predicts the outcome of a SQL statement 
D)  provides the rules for how a SQL statement should be executed 
A)  contains the result of a SQL statement 
B)  allows the program to execute a SQL statement 
C)  predicts the outcome of a SQL statement 
D)  provides the rules for how a SQL statement should be executed

Question 19

Which term refers to undoing changes to a database?

Accepted Answer

A)  uncommit 
B)  reverse 
C)  rollback 
D)  undo 
A)  uncommit 
B)  reverse 
C)  rollback 
D)  undo

Question 20

In SQL, the __________ statement is used to delete a table from a database.

Accepted Answer

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

Which of the following is the Statement interface method that should be used to execute an INSERT statement.

Although SQL is a language, you don't use it to write applications.

Which of the following is the not-equal-to operator in SQL?

__________ refers to data that describes other data.

In SQL, the __________ statement is used to delete one or more rows from a table.

The standard lanuage for working with database management systems is __________.

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

The __________ SQL operator can be used to disqualify search criteria in a WHERE clause.

What is the default concurrency level of a ResultSet object?

A column in one table that references a primary key in another table is known as a __________.

Which of the following can be used as a wildcard to represent a single character in SQL?

The term commit refers to undoing changes in a database.

To sort the results of a SQL query, you can use the __________ clause.

A qualified column name takes the form __________.

The data that is stored in a row of a database is divided into __________.

The __________ SQL operator can be used to perform a search for a substring.

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

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

Which term refers to undoing changes to a database?

In SQL, the __________ statement is used to delete a table from 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

Java-Fx: Gui Programming and Basic Controls

Java-Fx: Advanced Controls

Java-Fx: Graphics, Effects, and Media

Recursion

Filters

Exam 16: Databases

Which of the following is the Statement interface method that should be used to execute an INSERT statement.

Although SQL is a language, you don't use it to write applications.

Which of the following is the not-equal-to operator in SQL?

__________ refers to data that describes other data.

In SQL, the __________ statement is used to delete one or more rows from a table.

The standard lanuage for working with database management systems is __________.

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

The __________ SQL operator can be used to disqualify search criteria in a WHERE clause.

What is the default concurrency level of a ResultSet object?

A column in one table that references a primary key in another table is known as a __________.

Which of the following can be used as a wildcard to represent a single character in SQL?

The term commit refers to undoing changes in a database.

To sort the results of a SQL query, you can use the __________ clause.

A qualified column name takes the form __________.

The data that is stored in a row of a database is divided into __________.

The __________ SQL operator can be used to perform a search for a substring.

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

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

Which term refers to undoing changes to a database?

In SQL, the __________ statement is used to delete a table from 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

Java-Fx: Gui Programming and Basic Controls

Java-Fx: Advanced Controls

Java-Fx: Graphics, Effects, and Media

Recursion

Filters