Multiple Choice Instructions: Write the letter of the correct response on your paper.
- When the condition of having no repeating groups is satisfied, the data is said to be ______.
a. finalized
b. normalized
c. completed
d. finished
- A(n) ______is one or more fields in a table that reference the primary key field(s) of another table.
a. foreign key
b. secondary key
c. other key
d. reference key
- The process of encoding the state of an object into a stream is called ______.
a. serialization
b. interacing
c. deserialization
d. marking
- A(n) ______is the name used instead of the actual database name when establishing a connection to the database.
a. reference source name
b. reference code name
c. data code name
d. data source name
- A(n) ______is a statement in which the parameters do not change as the program executes.
a. database session
b. DriverManager
c. static SQL statement
d. concrete SQL statement
- The deletion of an index or table is called a(n) ______.
a. cut
b. drop
c. erasure
d. execution
- A ______restricts the field value with respect to all other values in the table.
a. keyword
b. code
c. statement
d. table constraint
- A ______has parameter values that can change as the program executes.
a. dynamic SQL statement
b. abstract SQL statement
c. floating statement
d. PreparedStatement
- The ______method of either a Statement or PreparedStatement object is call to perform an SQL query.
a. go()Query
b. find() Query
c. execute()Query
d. execute() statement
- The ______is a class given responsibility of accessing the data from its persistent storage and providing it to the requesting application.
a. storage access class
b. data access class
c. application access class
d. reference access class
True/False Instructions: Write T if the statement is true or F if the statement is false on your paper.
1. An index is an internal data structure built from a field or group of fields.
2. A foreign key field does not have to be named the same as the primary key it references.
3. Serialization is simply the conversion of an object into a stream.
4. Placeholders are represented as (*) characters in the SQL statement.
5. You can examine directly the tables created by opening the database in Microsoft Access.
6. The search condition specified in a WHERE clause of an SQL update statement does not reference the primary key.
7. A transaction is an illogical unit of work.
8. By default, new connections automatically commit SQL statements as individual transactions.
9. Setting a connection’s auto-commit mode to false allows multiple SQL statements to be grouped into a single transaction.
10. An SQLException is not used for database access errors.
Short Answer Instructions: Write the best answer on your paper.
1. A ______provides a grouping of related data in terms of rows and columns.
2. The ______of a relationship is described as one-to-one, one-to-many, or many-to
many.
3. The ______of an object is the value of its attributes, or variables, at a given point.
4. ______is the ability of an object to be saved over time, allowing the object to be
restored later.
5. An interface with no methods or fields is called a(n) ______.
6. ______objects represent instances of classes (and interfaces) running in a Java
application.
7. Once an appropriate driver is loaded, a(n) ______must be established to the
database
8. A(n) ______returns a set of data results based on the parameters of the query.
9. A(n) ______is used to add, modify, or delete data from a database.
10. A(n) ______is a rule that restricts the data value entered in a column.