Deck 16: Databases

Question 1

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

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

Answer 1

B

Question 2

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

Answer 2

True

Question 3

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

Answer 3

False

Question 4

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.

Question 5

The standard lanuage for working with database management systems is __________.

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

Question 6

SQL does not provide functions for performing calculations.

Question 7

SQL stands for __________.

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

Question 8

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 9

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

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

Question 10

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

Question 11

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

Question 12

In SQL the REFERENCES qualifier ensures referential integrity between tables.

Question 13

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

Question 14

The term commit refers to undoing changes in a database.

Question 15

Which of the following 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 16

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

Question 17

"'"
C) /'
D) ''

Question 18

The columns in a table are assigned SQL data types.

Question 19

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

Question 20

The data that is stored in a row of a database is divided into __________.

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

Question 21

Which of the following is the not-equal-to operator in SQL?

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

Question 22

Which of the following is the Statement interface method that should be used to execute an INSERT statement.

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

Question 23

What is the default concurrency level of a ResultSet object?

A) public
B) updatable
C) private
D) read-only

Question 24

Which of the following is the Statement interface method that should be used to execute a SELECT statement?

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

Question 25

A column in one table that references a primary key in another table is known as a __________.

A) secondary key
B) foreign key
C) referential key
D) meta key

Question 26

To sort the results of a SQL query, you can use the __________ clause.

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

Question 27

In SQL, the __________ statement is used to delete a table from a database.

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

Question 28

What does JDBC stand for?

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

Question 29

The __________ statement is used in SQL to insert a new row into a table,

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

Question 30

__________ refers to data that describes other data.

A) pseudodata
B) microdata
C) abstract data
D) metadata

Question 31

In an entity relationship diagram, the primary key is denoted with __________.

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

Question 32

In SQL, the __________ statement can be used to create a database table.

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

Question 33

In SQL, the __________ statement is used to delete one or more rows from a table.

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

Question 34

Which of the following can be used as a wildcard to represent a single character in SQL?

A) percent sign ( % )
B) dollar sign ( $ )
C) underscore ( _ )
D) asterisk ( * )

Question 35

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 36

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

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

Question 37

The __________ SQL operator can be used to perform a search for a substring.

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

Question 38

A qualified column name takes the form __________.

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

Question 39

The __________ SQL operator can be used to disqualify search criteria in a WHERE clause.

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

Question 40

Which term refers to undoing changes to a database?

A) uncommit
B) reverse
C) rollback
D) undo