Deck 17: Databases

Question 1

Column names in a database are:

A) case sensitive
B) similar to Java data types
C) not case sensitive
D) always uppercase letters

Answer 1

C

Question 2

If you wish to sort the results of an SQL query, you can use the ________ clause.

A) SORT BY
B) ALIGN ROW
C) ORDER BY
D) ASCEND

Answer 2

C

Question 3

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

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

Answer 3

A

Question 4

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

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 5

This type of SQL statement is used to retrieve the rows from a table.

A) GET
B) SELECT
C) READ
D) RETRIEVE

Question 6

In SQL, this character can be used as a wildcard to represent a single character.

A) %
B) $
C) _
D) *

Question 7

In SQL, the not equal-to operator is:

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

Question 8

What do most developers prefer to use when developing applications that work with an intensive amount of data?

A) Text files
B) Binary files
C) A database management system
D) Java DB

Question 9

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

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

Question 10

What SQL operator can be used to disqualify search criteria in a WHERE clause?

A) AND
B) NOT
C) EXCLUDE
D) NOR

Question 11

SQL stands for:

A) structured query language
B) standard equivalent language
C) semiconductor qualified language
D) Simple equation library

Question 12

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

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

Question 13

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

A) back to the application
B) along the encrypted data path
C) to the unified data component
D) back to the Web server

Question 14

This is the standard language for working with database management systems.

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

Question 15

What SQL operator can be used to perform a search for a substring?

A) STR
B) LIKE
C) WHERE
D) SUB

Question 16

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

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

Question 17

Of the following column names, which one is most likely a primary key column?

A) Price
B) Description
C) ItemNumber
D) Quantity

Question 18

What does JDBC stand for?

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

Question 19

What must you have installed on your system before you can use JDBC to access a database?

A) DBMS
B) Java
C) Both A and B
D) Neither A nor B

Question 20

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

A) _'
B) "'"
C) /'
D) ''

Question 21

Appending the attribute ;create=true to the database URL:

A) creates a new database
B) creates a new table
C) creates a new row
D) creates a new column

Question 22

What is the default concurrency level of a ResultSet object?

A) Public
B) Updatable
C) Private
D) Read-only

Question 23

To what package does the Connection interface belong?

A) java.swing
B) java.awt
C) java.sql
D) java.io

Question 24

Which SQL statement is used to delete a table from a database?

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

Question 25

Which Statement interface method should be used to execute an INSERT statement?

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

Question 26

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

A) (PK)
B) (1)
C) (KEY)
D) (PRIME)

Question 27

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

A) JDBC driver
B) Database URL
C) JDBC locator
D) Database specifier

Question 28

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

Question 29

What is determined by the following code?
ResultSet.last();
Int numRows = resultSet.getRow();
ResultSet.first();

A) the number of rows in the result set
B) the number of columns in the result set
C) the value of the cursor's current position
D) the sum of all rows in the result set

Question 30

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

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

Question 31

In SQL, this statement is used to change the contents of an existing row in a table:

A) SET ROW
B) CHANGE
C) UPDATE
D) REFRESH

Question 32

The columns in a table are assigned SQL data types.

Question 33

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

A) Secondary key
B) Foreign key
C) Referential key
D) Meta key

Question 34

You use this statement in SQL to insert a new row into a table:

A) UPDATE
B) ADD
C) NEW
D) INSERT

Question 35

What term refers to data that describes other data?

A) Pseudo-data
B) Micro data
C) Abstract data
D) Meta data

Question 36

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

A) NEW TABLE
B) MAKE TABLE
C) BUILD TABLE
D) CREATE TABLE

Question 37

A qualified column name takes the following form:

A) ColumnName.TableName
B) TableName.ColumnName
C) RowName.TableName
D) DatabaseURL.ColumnName

Question 38

Which Statement interface method should be used to execute a SELECT statement?

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

Question 39

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

A) JTable
B) JFrame
C) JPanel
D) JTable2D

Question 40

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

A) DELETE
B) DROP ROW
C) REMOVE
D) PURGE

Question 41

SQL does not provide functions for performing calculations.

Question 42

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

Question 43

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

Question 44

No two rows in a table can have the same value in the primary key column

Question 45

In SQL, the REFERENCES qualifier ensures referential integrity between tables.

Question 46

In a transaction, all updates to database must be successfully executed.

Question 47

The term commit refers to undoing changes to a database.

Question 48

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