TEST BANK
Starting Out With Java, Control
Structures through Objects, 8th
Edition by Tony Gaddis
Complete Chapter Test Bank
are included (Ch 1 to 17)
** Immediate Download
** Swift Response
** All Chapters included
,Table of Contents are given below
1.Introduction to Computers and Java
2.Java Fundamentals
3.Decision Structures
4.Loops and Files
5.Methods
6.A First Look at Classes
7.Arrays and the ArrayList Class
8.A Second Look at Classes and Objects
9.Text Processing and Wrapper Classes
10.Inheritance
11.Exceptions and Advanced File I/O
12.JavaFX: GUI Programming and Basic Controls
13.JavaFX: Advanced Controls
14.JavaFX: Graphics, Effects and Media
15.Recursion
16.Databases
,The test bank is organized in reverse order, with the last chapter displayed first, to ensure that all
chapters are included in this document. (Complete Chapters included Ch16-1)
Starting Out with Java: From Control Structures through Objects 8e (Gaddis)
Chapter 16 Databases
TRUE/FALSE
1. Although SQL is a language, you don't use it to write applications.
ANS: T
2. The columns in a table are assigned SQL data types.
ANS: T
3. In SQL the equal operator is ==, the same as Java.
ANS: F
4. SQL does not provide functions for performing calculations.
ANS: F
5. Systems designers commonly use UML diagrams to show the relationships between database tables.
ANS: F
6. No two rows in a table can have the same value in the primary key column.
ANS: T
7. In SQL the REFERENCES qualifier ensures referential integrity between tables.
ANS: T
8. SQL statements that are stored in the DBMS are called resident queries.
ANS: F
9. In a transaction, all updates to the database must be successfully executed.
ANS: T
10. The term commit refers to undoing changes in a database.
ANS: F
, MULTIPLE CHOICE
1. Which of the following do most developers prefer to use when developing applications that work with
an intensive amount of data?
a. text files c. a database management system
b. binary files d. Java DB
ANS: C
2. The standard language for working with database management systems is __________.
a. SQL b. BASIC c. ADA d. COBOL
ANS: A
3. The DBMS works directly with the data and sends the results of operations __________.
a. back to the application c. to the unified data component
b. along the encrypted data path d. back to the Web server
ANS: A
4. SQL stands for __________.
a. structured query language c. semiconductor qualified language
b. standard equivalent language d. simple equation library
ANS: A
5. The data that is stored in a row of a database is divided into __________.
a. sections b. tables c. bytes d. columns
ANS: D
6. What will happen if you try to store duplicate data in a primary key column?
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.
ANS: B
7. A result set is an object that is somewhat similar to a collection and it __________.
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
ANS: A
8. The __________ type of SQL statement is used to retrieve the rows from a table.
a. GET b. SELECT c. READ d. RETRIEVE
ANS: B
Starting Out With Java, Control
Structures through Objects, 8th
Edition by Tony Gaddis
Complete Chapter Test Bank
are included (Ch 1 to 17)
** Immediate Download
** Swift Response
** All Chapters included
,Table of Contents are given below
1.Introduction to Computers and Java
2.Java Fundamentals
3.Decision Structures
4.Loops and Files
5.Methods
6.A First Look at Classes
7.Arrays and the ArrayList Class
8.A Second Look at Classes and Objects
9.Text Processing and Wrapper Classes
10.Inheritance
11.Exceptions and Advanced File I/O
12.JavaFX: GUI Programming and Basic Controls
13.JavaFX: Advanced Controls
14.JavaFX: Graphics, Effects and Media
15.Recursion
16.Databases
,The test bank is organized in reverse order, with the last chapter displayed first, to ensure that all
chapters are included in this document. (Complete Chapters included Ch16-1)
Starting Out with Java: From Control Structures through Objects 8e (Gaddis)
Chapter 16 Databases
TRUE/FALSE
1. Although SQL is a language, you don't use it to write applications.
ANS: T
2. The columns in a table are assigned SQL data types.
ANS: T
3. In SQL the equal operator is ==, the same as Java.
ANS: F
4. SQL does not provide functions for performing calculations.
ANS: F
5. Systems designers commonly use UML diagrams to show the relationships between database tables.
ANS: F
6. No two rows in a table can have the same value in the primary key column.
ANS: T
7. In SQL the REFERENCES qualifier ensures referential integrity between tables.
ANS: T
8. SQL statements that are stored in the DBMS are called resident queries.
ANS: F
9. In a transaction, all updates to the database must be successfully executed.
ANS: T
10. The term commit refers to undoing changes in a database.
ANS: F
, MULTIPLE CHOICE
1. Which of the following do most developers prefer to use when developing applications that work with
an intensive amount of data?
a. text files c. a database management system
b. binary files d. Java DB
ANS: C
2. The standard language for working with database management systems is __________.
a. SQL b. BASIC c. ADA d. COBOL
ANS: A
3. The DBMS works directly with the data and sends the results of operations __________.
a. back to the application c. to the unified data component
b. along the encrypted data path d. back to the Web server
ANS: A
4. SQL stands for __________.
a. structured query language c. semiconductor qualified language
b. standard equivalent language d. simple equation library
ANS: A
5. The data that is stored in a row of a database is divided into __________.
a. sections b. tables c. bytes d. columns
ANS: D
6. What will happen if you try to store duplicate data in a primary key column?
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.
ANS: B
7. A result set is an object that is somewhat similar to a collection and it __________.
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
ANS: A
8. The __________ type of SQL statement is used to retrieve the rows from a table.
a. GET b. SELECT c. READ d. RETRIEVE
ANS: B
