Question 1

How does a relational database store information?

Accepted Answer

A) Arrays 
B) Linked Lists 
C) Tables 
D) Charts 
A) Arrays 
B) Linked Lists 
C) Tables 
D) Charts

Question 2

The outcome of a SQL query is a ____________________.

Accepted Answer

A) table 
B) a 2D array of objects 
C) list 
D) subquery 
A) table 
B) a 2D array of objects 
C) list 
D) subquery

Question 3

To get the number of columns in a result set, you use _________ method of the ResultSetMetaData class.

Accepted Answer

A) getColumnInt() 
B) getColumnsCount() 
C) getCount() 
D) getColumnCount() 
A) getColumnInt() 
B) getColumnsCount() 
C) getCount() 
D) getColumnCount()

Question 4

In database terminology, a column (or combination of columns) that uniquely identifies a row in a table is called a(n) ____.

Accepted Answer

A) data type 
B) attribute 
C) primary key 
D) column header 
A) data type 
B) attribute 
C) primary key 
D) column header

Question 5

An example of a desktop database is:

Accepted Answer

A) Oracle 
B) MS Access 
C) Apache Derby 
D) MySQL 
A) Oracle 
B) MS Access 
C) Apache Derby 
D) MySQL

Question 6

What will the following command do?
java -classpath derby.sql;.ExecSQL database.properties Product.sql

Accepted Answer

A) It will execute the statements in the database.properties file. 
B) It will execute the statements in the derby.sql file. 
C) It will execute the statements in the Product.sql file. 
D) It will act as an interactive testing tool only. 
A) It will execute the statements in the database.properties file. 
B) It will execute the statements in the derby.sql file. 
C) It will execute the statements in the Product.sql file. 
D) It will act as an interactive testing tool only.

Question 7

What should be on the class path when you launch a Java program that accesses a database?

Accepted Answer

A) the JDBC driver 
B) the derby.jar file 
C) the user name and password 
D) the JDK 
A) the JDBC driver 
B) the derby.jar file 
C) the user name and password 
D) the JDK

Question 8

Which of the following table attributes could be a unique identifier for a person?

Accepted Answer

A) Name 
B) SocialSecurityNumber 
C) State 
D) Birthday 
A) Name 
B) SocialSecurityNumber 
C) State 
D) Birthday

Question 9

What is wrong with the following statement?
boolean result = statement.execute("SELECT * FROM emp WHERE empNum = '?'");

Accepted Answer

A) boolean should be ResultSet 
B) execute should be executeQuery 
C) execute should be prepareStatement 
D) (?) should be an integer 
A) boolean should be ResultSet 
B) execute should be executeQuery 
C) execute should be prepareStatement 
D) (?) should be an integer

Question 10

When you execute a rollback:

Accepted Answer

A) the temporary data are made permanent. 
B) the temporary tables are simply discarded. 
C) the database stores the changes in a temporary table. 
D) it will commit all the updates. 
A) the temporary data are made permanent. 
B) the temporary tables are simply discarded. 
C) the database stores the changes in a temporary table. 
D) it will commit all the updates.

Question 11

What will the following command do?
java -classpath derby.sql;.ExecSQL database.properties

Accepted Answer

A) It will execute the statements in the database.properties file. 
B) It will execute the statements in the derby.sql file. 
C) It will compile the statements in the derby.sql file. 
D) It will use ExecSQL program as an interactive testing tool. 
A) It will execute the statements in the database.properties file. 
B) It will execute the statements in the derby.sql file. 
C) It will compile the statements in the derby.sql file. 
D) It will use ExecSQL program as an interactive testing tool.

Question 12

A ____________ is a reference to a primary key in a linked table.

Accepted Answer

A) foreign key 
B) primary key 
C) column headers 
D) data type 
A) foreign key 
B) primary key 
C) column headers 
D) data type

Question 13

Which clause allows the joining of multiple tables in SQL?

Accepted Answer

A) WHERE with multiple items 
B) JOIN with multiple items 
C) FROM with multiple items 
D) WITH with multiple items 
A) WHERE with multiple items 
B) JOIN with multiple items 
C) FROM with multiple items 
D) WITH with multiple items

Question 14

Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________.
Customer table

Accepted Answer

A) SELECT * FROM Customer 
B) SELECT Name, Address, City, State, Zip INTO Customer 
C) SELECT FROM Customer FIELDS Name, Address, City, State, Zip 
D) SELECT Name, Address, City, State, Zip FROM Customer 
A) SELECT * FROM Customer 
B) SELECT Name, Address, City, State, Zip INTO Customer 
C) SELECT FROM Customer FIELDS Name, Address, City, State, Zip 
D) SELECT Name, Address, City, State, Zip FROM Customer

Question 15

An example of a production-quality database is:

Accepted Answer

A) Oracle 
B) MS Access 
C) Apache Derby 
D) Powerbuilder 
A) Oracle 
B) MS Access 
C) Apache Derby 
D) Powerbuilder

Question 16

What will the following expression match to?
Name LIKE '%e%'

Accepted Answer

A) all strings in the Name column that end with "e". 
B) all strings in the Name column whose second to last letter is an "e". 
C) all strings in the Name column that contain the letter "e". 
D) all strings in the Name column whose second letter is an "e". 
A) all strings in the Name column that end with "e". 
B) all strings in the Name column whose second to last letter is an "e". 
C) all strings in the Name column that contain the letter "e". 
D) all strings in the Name column whose second letter is an "e".

Question 17

A _____________ is a column (or set of columns) whose value uniquely specifies a table record.

Accepted Answer

A) foreign key 
B) primary key 
C) column headers 
D) data type 
A) foreign key 
B) primary key 
C) column headers 
D) data type

Question 18

You can use the generic ____ method to execute arbitrary SQL statements.

Accepted Answer

A) setString() 
B) prepareStatement() 
C) executeQuery() 
D) execute() 
A) setString() 
B) prepareStatement() 
C) executeQuery() 
D) execute()

Question 19

Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________
Customer table

Accepted Answer

A) SELECT Name FROM Customer WHERE City 'Pleasantville' B) SELECT Name FROM Customer WHERE City == 'Pleasantville' C) SELECT Name FROM Customer WHERE City >< 'Pleasantville' D) SELECT Name FROM Customer WHERE City = 'Pleasantville' A) SELECT Name FROM Customer WHERE City 'Pleasantville' B) SELECT Name FROM Customer WHERE City == 'Pleasantville' C) SELECT Name FROM Customer WHERE City >< 'Pleasantville' D) SELECT Name FROM Customer WHERE City = 'Pleasantville'

Question 20

"SQL injection attacks" have been responsible for many cases of data theft.One of the solutions for preventing these attacks is:

Accepted Answer

A) Never use double quotes in the query. 
B) Never use single quotes in the query. 
C) Never add a string to a query that you didn't type yourself. 
D) Never add a number to a query that you didn't type yourself. 
A) Never use double quotes in the query. 
B) Never use single quotes in the query. 
C) Never add a string to a query that you didn't type yourself. 
D) Never add a number to a query that you didn't type yourself.

Exam 24: Relational Databases

How does a relational database store information?

The outcome of a SQL query is a ____________________.

To get the number of columns in a result set, you use _________ method of the ResultSetMetaData class.

In database terminology, a column (or combination of columns) that uniquely identifies a row in a table is called a(n) ____.

An example of a desktop database is:

What will the following command do? java -classpath derby.sql;.ExecSQL database.properties Product.sql

What should be on the class path when you launch a Java program that accesses a database?

Which of the following table attributes could be a unique identifier for a person?

What is wrong with the following statement? boolean result = statement.execute("SELECT * FROM emp WHERE empNum = '?'");

When you execute a rollback:

What will the following command do? java -classpath derby.sql;.ExecSQL database.properties

A ____________ is a reference to a primary key in a linked table.

Which clause allows the joining of multiple tables in SQL?

Based on the following table, the query that gets the names and complete mailing addresses of all customers is ____________________. Customer table

An example of a production-quality database is:

What will the following expression match to? Name LIKE '%e%'

A _____________ is a column (or set of columns) whose value uniquely specifies a table record.

You can use the generic ____ method to execute arbitrary SQL statements.

Based on the table below, insert the statement that queries the database for the names of customers who live in the city of Pleasantville: ______________________ Customer table

"SQL injection attacks" have been responsible for many cases of data theft.One of the solutions for preventing these attacks is:

Introduction

Using Objects

Implementing Classes

Fundamental Data Types

Decisions

Loops

Arrays and Array Lists

Designing Classes

Inheritance

Interfaces

Input/Output and Exception Handling

Object-Oriented Design

Recursion

Sorting and Searching

The Java Collections Framework

Basic Data Structures

Tree Structures

Generic Classes

Stream Processing

Graphical User Interfaces

Advanced Input/Output

Multithreading

Internet Networking

XML

Filters