Question 1

Which of one the following SQL data types would be the best choice for storing financial data?

Accepted Answer

A)  INT 
B)  REAL 
C)  DOUBLE 
D)  VARCHAR 
A)  INT 
B)  REAL 
C)  DOUBLE 
D)  VARCHAR

Question 2

The term commit refers to undoing changes to a database.

Accepted Answer

A) True 
 B)False

Question 3

By default, ResultSet objects allows you to move the cursor:

Accepted Answer

A)  backward only 
B)  vertically 
C)  forward only 
D)  horizontally 
A)  backward only 
B)  vertically 
C)  forward only 
D)  horizontally

Question 4

In an entity relationship diagram, the primary keys are denoted with:

Accepted Answer

A)  (PK) 
B)  (1) 
C)  (KEY) 
D)  (PRIM
E)  
A)  (PK) 
B)  (1) 
C)  (KEY) 
D)  (PRIM
E)

Question 5

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 6

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 7

The data that is stored in a table is organized in:

Accepted Answer

A)  rows 
B)  folders 
C)  pages 
D)  files 
A)  rows 
B)  folders 
C)  pages 
D)  files

Question 8

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 9

What does JDBC stand for?

Accepted Answer

A)  Java data binary collection 
B)  Java database connectivity 
C)  Java database collection 
D)  Java data basic computation 
A)  Java data binary collection 
B)  Java database connectivity 
C)  Java database collection 
D)  Java data basic computation

Question 10

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 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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 14

If you try to store duplicate data in a primary key column:

Accepted Answer

A)  the column is 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 is 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 15

The data that is stored in a row is divided into:

Accepted Answer

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

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

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

Accepted Answer

A) True 
 B)False

Question 18

A column in one table that references a primary key in another table is known as what?

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 19

System designers commonly use UML diagrams to show the relationships between database tables.

Accepted Answer

A) True 
 B)False

Question 20

What Java class 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

Which of one the following SQL data types would be the best choice for storing financial data?

The term commit refers to undoing changes to a database.

By default, ResultSet objects allows you to move the cursor:

In an entity relationship diagram, the primary keys are denoted with:

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

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

The data that is stored in a table is organized in:

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

What does JDBC stand for?

What is the default concurrency level of a ResultSet object?

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

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

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

If you try to store duplicate data in a primary key column:

The data that is stored in a row is divided into:

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

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

A column in one table that references a primary key in another table is known as what?

System designers commonly use UML diagrams to show the relationships between database tables.

What Java class is a Swing component that displays data in a two-dimensional table?

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

Which of one the following SQL data types would be the best choice for storing financial data?

The term commit refers to undoing changes to a database.

By default, ResultSet objects allows you to move the cursor:

In an entity relationship diagram, the primary keys are denoted with:

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

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

The data that is stored in a table is organized in:

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

What does JDBC stand for?

What is the default concurrency level of a ResultSet object?

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

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

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

If you try to store duplicate data in a primary key column:

The data that is stored in a row is divided into:

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

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

A column in one table that references a primary key in another table is known as what?

System designers commonly use UML diagrams to show the relationships between database tables.

What Java class is a Swing component that displays data in a two-dimensional table?

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