Question 1

What term refers to data that describes other data?

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False  False

Question 3

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. 
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. B

Question 4

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

Accepted Answer

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

Question 5

What does JDBC stand for?

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A)  (PK). 
B)  (1). 
C)  (KEY). 
D)  (PRIM
E) . 
A)  (PK). 
B)  (1). 
C)  (KEY). 
D)  (PRIM
E) .

Question 10

The columns in a table are assigned SQL data types.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 DB 
A)  text files 
B)  binary files 
C)  a database management system 
D)  Java DB

Question 13

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

Accepted Answer

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

Question 14

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 key 
A)  Secondary key 
B)  Foreign key 
C)  Referential key 
D)  Meta key

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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)  REFRESH 
A)  SET ROW 
B)  CHANGE 
C)  UPDATE 
D)  REFRESH

Question 18

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

Accepted Answer

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

Question 19

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 TABLE 
A)  REM TABLE 
B)  DEL TABLE 
C)  DROP TABLE 
D)  ERASE TABLE

Question 20

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

Accepted Answer

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

What term refers to data that describes other data?

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

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

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

What does JDBC stand for?

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

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

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

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

The columns in a table are assigned SQL data types.

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

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

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

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

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

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

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

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

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

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

Introduction to Computers and Java

Java Fundamentals

A First Look at Classes and Objects

Decision Structures

Loops and Files

A Second Look at Classes and Objects

Arrays and the ArrayList Class

Text Processing and Wrapper Classes

Inheritance

Exceptions and Advanced File I/O

GUI Applications–Part 1

GUI Applications–Part 2

Applets and More

Creating GUI Applications with JavaFX

Recursion

Filters

Exam 16: Databases

What term refers to data that describes other data?

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

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

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

What does JDBC stand for?

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

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

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

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

The columns in a table are assigned SQL data types.

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

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

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

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

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

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

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

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

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

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

Introduction to Computers and Java

Java Fundamentals

A First Look at Classes and Objects

Decision Structures

Loops and Files

A Second Look at Classes and Objects

Arrays and the ArrayList Class

Text Processing and Wrapper Classes

Inheritance

Exceptions and Advanced File I/O

GUI Applications–Part 1

GUI Applications–Part 2

Applets and More

Creating GUI Applications with JavaFX

Recursion

Filters