Question 1

SQL uses single quotes (') to delimit strings.What is the standard in order to include a single quote in a String? For example: 'Joe's Burgers'

Accepted Answer

A) Use double quotes (") 
B) Use a normal single quote 
C) Use the single quote twice 
D) Escape with a (\') as in Java 
A) Use double quotes (") 
B) Use a normal single quote 
C) Use the single quote twice 
D) Escape with a (\') as in Java

Question 2

Which of the following statements is correct?

Accepted Answer

A) SQL uses double quotes (") to delimit strings. 
B) The SQL command INSERT AT adds data to a database 
C) SQL is not case sensitive. 
D) SQL is a part of the Java API. 
A) SQL uses double quotes (") to delimit strings. 
B) The SQL command INSERT AT adds data to a database 
C) SQL is not case sensitive. 
D) SQL is a part of the Java API.

Question 3

What is the purpose of the LIKE clause?

Accepted Answer

A) Selects data that fulfills a numerical condition 
B) Finds the location of the initial starting point 
C) Matches all strings which contains certain characters 
D) Tests for equality in ASCII value 
A) Selects data that fulfills a numerical condition 
B) Finds the location of the initial starting point 
C) Matches all strings which contains certain characters 
D) Tests for equality in ASCII value

Question 4

Based on the customer table below, which of the attributes do you think represents the primary key?
Customer table

Accepted Answer

A) Address 
B) Name 
C) Customer_Number 
D) Zip 
A) Address 
B) Name 
C) Customer_Number 
D) Zip

Question 5

An important part of database processing is transaction handling.What is a transaction?

Accepted Answer

A) A set of data that is translated into the required language and then added to the database 
B) A set of database transfers to another database 
C) A set of database updates that may have some parts successful 
D) A set of database updates that should either succeed fully or not happen at all 
A) A set of data that is translated into the required language and then added to the database 
B) A set of database transfers to another database 
C) A set of database updates that may have some parts successful 
D) A set of database updates that should either succeed fully or not happen at all

Question 6

Which Java statement connects to a database using a Connection object?

Accepted Answer

A) Connection conn = new Connection(url, username, password); 
B) Conenction conn = DriverManager.getConnection(); 
C) Connection conn = DriverManager.connect(url, username, password); 
D) Connection conn = DriverManager.getConnection(url, username, password); 
A) Connection conn = new Connection(url, username, password); 
B) Conenction conn = DriverManager.getConnection(); 
C) Connection conn = DriverManager.connect(url, username, password); 
D) Connection conn = DriverManager.getConnection(url, username, password);

Question 7

Based on the table below, the query that finds the names and zip codes of all customers is _____________________.
Customer table

Accepted Answer

A) SELECT ALL Name, Zip FROM Customer 
B) SELECT Name, Zip 
C) SELECT * FROM Customer 
D) SELECT Name, Zip FROM Customer 
A) SELECT ALL Name, Zip FROM Customer 
B) SELECT Name, Zip 
C) SELECT * FROM Customer 
D) SELECT Name, Zip FROM Customer

Question 8

What is the main purpose of the Connection object?

Accepted Answer

A) Accesses a database from a Java program 
B) Combines multiple data tables 
C) Skips the loading step of the database driver class 
D) Manually loads the database driver class 
A) Accesses a database from a Java program 
B) Combines multiple data tables 
C) Skips the loading step of the database driver class 
D) Manually loads the database driver class

Question 9

What does the execute method return?

Accepted Answer

A) ResultSet 
B) Query 
C) RecordSet 
D) boolean 
A) ResultSet 
B) Query 
C) RecordSet 
D) boolean

Question 10

In the table below, the ____ correspond(s) to the attributes of a customer in the database.
Customer 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 11

Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________. Customer table

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 12

Based on the table below, which of the following statements will return the number of customers in Michigan (MI)?
Customer table

Accepted Answer

A) SELECT COUNT(*) FROM Customer WHERE State = 'MI' 
B) SELECT AVG(*) FROM Customer WHERE State = 'MI' 
C) SELECT MAX(*) FROM Customer WHERE State = 'MI' 
D) SELECT SUM(*) FROM Customer WHERE State = 'MI' 
A) SELECT COUNT(*) FROM Customer WHERE State = 'MI' 
B) SELECT AVG(*) FROM Customer WHERE State = 'MI' 
C) SELECT MAX(*) FROM Customer WHERE State = 'MI' 
D) SELECT SUM(*) FROM Customer WHERE State = 'MI'

Question 13

In jdbc.URL, the acronym URL stands for:

Accepted Answer

A) Universal Resource Locator 
B) Uniform Resource Locator 
C) Universe Resultset Locator 
D) Uniform Resultset Locator 
A) Universal Resource Locator 
B) Uniform Resource Locator 
C) Universe Resultset Locator 
D) Uniform Resultset Locator

Question 14

The ______ class has a next method to visit the next row of a query result.

Accepted Answer

A) Scanner 
B) Statement 
C) ResultSet 
D) Connection 
A) Scanner 
B) Statement 
C) ResultSet 
D) Connection

Question 15

What statement will return the value of a given key from the configuration file? Assume props is of type Properties.

Accepted Answer

A) String driver = props.getProperty("database.properties"); 
B) Connection conn = SimpleDataSource.getProperty("database.properties"); 
C) String driver = props.getProperty("jdbc.driver"); 
D) Properties props = SampleDataSource.init("jdbc.driver"); 
A) String driver = props.getProperty("database.properties"); 
B) Connection conn = SimpleDataSource.getProperty("database.properties"); 
C) String driver = props.getProperty("jdbc.driver"); 
D) Properties props = SampleDataSource.init("jdbc.driver");

SQL uses single quotes (') to delimit strings.What is the standard in order to include a single quote in a String? For example: 'Joe's Burgers'

Which of the following statements is correct?

What is the purpose of the LIKE clause?

Based on the customer table below, which of the attributes do you think represents the primary key? Customer table

An important part of database processing is transaction handling.What is a transaction?

Which Java statement connects to a database using a Connection object?

Based on the table below, the query that finds the names and zip codes of all customers is _____________________. Customer table

What is the main purpose of the Connection object?

What does the execute method return?

In the table below, the ____ correspond(s) to the attributes of a customer in the database. Customer table

Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________. Customer table

Based on the table below, which of the following statements will return the number of customers in Michigan (MI)? Customer table

In jdbc.URL, the acronym URL stands for:

The ______ class has a next method to visit the next row of a query result.

What statement will return the value of a given key from the configuration file? Assume props is of type Properties.

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

Exam 24: Relational Databases

SQL uses single quotes (') to delimit strings.What is the standard in order to include a single quote in a String? For example: 'Joe's Burgers'

Which of the following statements is correct?

What is the purpose of the LIKE clause?

Based on the customer table below, which of the attributes do you think represents the primary key? Customer table

An important part of database processing is transaction handling.What is a transaction?

Which Java statement connects to a database using a Connection object?

Based on the table below, the query that finds the names and zip codes of all customers is _____________________. Customer table

What is the main purpose of the Connection object?

What does the execute method return?

In the table below, the ____ correspond(s) to the attributes of a customer in the database. Customer table

Based on the table below, the SQL statement that changes the address and city of customer 3175, Gregory Adams, to 1337 Parkway Ave and Pembrook, SD, 57462, respectively, is _____________________. Customer table

Based on the table below, which of the following statements will return the number of customers in Michigan (MI)? Customer table

In jdbc.URL, the acronym URL stands for:

The ______ class has a next method to visit the next row of a query result.

What statement will return the value of a given key from the configuration file? Assume props is of type Properties.

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