Db2 Basics, Part 1

A ________ may contain multiple ________ (each behaving like a separate installation of DB2), and an instance can control multiple ________.

A DB2 ________ manages the storage, modification, and retrieval of data.

A DB2 database is a collection of related ________.

A DB2 database may be created with the

A DB2 database is implicitly ________ as soon as it is created.

A DB2 database can be explicitly cataloged using any of these 3 methods:      the ________ Center      the ________ Assistant      the ________ ________ command 

The ________ statement deletes existing database objects when they are no longer needed.

Any of the DB2 database objects is created using the _________ statement.

Which of the following is NOT a numeric data type?

Which of the following is NOT a numeric data type?

Which of the following is NOT a character data type?

An equivalent term for CHARACTER VARYING is ________.

An equivalent term for CHARACTER LARGE OBJECT is ________.

The double-byte character data types (in alpha order) are ________, ________, ________, ________.

The date and time data types (in alpha order) are ________, _______, ________.

The binary and XML data types (in alpha order) are ________, _______.

Execution of an SQL statement in a basic client/server environment:      SQL statement is sent through a ________ from the ________ workstation to a database ________.      The database ________ processes the statement.      The results are sent back through the ________ to the ________. 

For every SQL statement executed, how many messages must go through the network?

Focus of client/server development:      Place the application logic on one or more ________.      Place the code that interacts directly with a database on a ________. 

Structured Query Language (SQL) is a standardized language used to work with ________ ________ and the ________ they contain.

SQL is a procedural programming language.

When using the WHERE clause predicate LIKE, the metacharacter (wildcard) "_" represents any single alphanumeric character.

When using the WHERE clause predicate LIKE, the metacharacter (wildcard) "%" represents any single alphanumeric character.

The searched update uses one of the normal forms of the UPDATE statement.  The positioned update uses a ________.

When using a positioned update, the UPDATE statement must contain a ________________ [CursorName] clause.