Question 1

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

Accepted Answer

A)   (PK) .
B)   (1) .
C)   (KEY) .
D)   (PRIM
E)  .E) B) and C)
F) None of the above

Question 2

What does JDBC stand for?

Accepted Answer

A)   Java data binary collection
B)   Java database connectivity
C)   Java database collection
D)   Java data basic computationE) C) and D)
F) All of the above

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

What will happen if you try to store duplicate data in a primary key column?

Accepted Answer

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.E) B) and D)
F) C) and D) B

Question 5

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

Accepted Answer

A)   UPDATE
B)   ADD
C)   NEW
D)   INSERTE) None of the above
F) A) and D)

Question 6

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

Accepted Answer

A)   SET ROW
B)   CHANGE
C)   UPDATE
D)   REFRESHE) B) and D)
F) All of the above

Question 7

The columns in a table are assigned SQL data types.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A)   STR
B)   LIKE
C)   WHERE
D)   SUBE) B) and D)
F) B) and C)

Question 9

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

Accepted Answer

A) True 
 B)False  False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)   SQL
B)   BASIC
C)   ADA
D)   COBOLE) A) and C)
F) B) and C)

Question 12

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

Accepted Answer

A)   REM TABLE
B)   DEL TABLE
C)   DROP TABLE
D)   ERASE TABLEE) B) and D)
F) All of the above

Question 13

What term refers to data that describes other data?

Accepted Answer

A)   Pseudo-data
B)   Micro data
C)   Abstract data
D)   Meta dataE) A) and B)
F) None of the above D

Question 14

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

Accepted Answer

A)   executeUpdate
B)   executeStatement
C)   executeQuery
D)   executeSQLE) B) and C)
F) C) and D)

Question 15

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

Accepted Answer

A)   Secondary key
B)   Foreign key
C)   Referential key
D)   Meta keyE) None of the above
F) B) and D)

Question 16

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

Accepted Answer

A)   text files
B)   binary files
C)   a database management system
D)   Java DBE) A) and D)
F) A) and C)

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A)   %
B)   $
C)   _
D)   *E) None of the above
F) A) and B)

Question 19

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

Accepted Answer

A)   executeSQL
B)   executeStatement
C)   executeUpdate
D)   executeQueryE) A) and D)
F) None of the above

Question 20

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

Accepted Answer

A)   Price
B)   Description
C)   ItemNumber
D)   QuantityE) B) and C)
F) A) and B)

Exam 16: Databases

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

Correct AnswerverifiedShow Answer

What does JDBC stand for?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What will happen if you try to store duplicate data in a primary key column?

Correct AnswerverifiedB

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The columns in a table are assigned SQL data types.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What term refers to data that describes other data?

Correct AnswerverifiedD

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified