Interactive Crossword Puzzle - May 2002

 

You need Java enabled to view the crossword applet.

Across
2. The portion of the DB2 log to which log records are written.
6. An SQL operation that combines the results of two select statements.
7. Event Identifier
9. In SQL, a distinct part of a statement.
10. Unresolvable contention for the use of a resource such as a table or an index.
11. A collection of tables, or a collection of table spaces and index spaces.
13. A stored PL/SQL construct made of related procedures, functions, exceptions, and other PL/SQL constructs.
17. A collection of commands that can be issued against a managed service known by the Intelligent Agent.
18. A named data object consisting of a specific number of columns and some number of unordered rows.
20. The system database that contains internal objects such as database descriptors.
21. A segment header structure that allows for tracking of blocks that are updateable or can be inserted into.
25. A Data Definition Language command that is used to change database objects.
27. User-defined function
28. The file-system directory that serves as the root of the Web Listener's virtual file system.
29. A structure that enhances data retrieval by providing rapid access to frequently  queried column values
30. A value or set of values mapped from a primary or parent table into a dependent or child table used to enforce referential integrity.
Down
1. An object that represents something to be made.
3. A low level locking mechanism usually used to protect internal database resources such as memory.
4. A SQL*Plus command that loads SQL or PL/SQL from an external operating system file into the SQL*Plus command buffer.
5. The process of taking a physical or logical copy of the database for disaster recovery purposes.
8. A database structure made up of one or more tables that jointly store key values in the same physical database blocks.
10. An attribute of columns, literals, host variables, special registers, and the results of functions and expressions.
11. The process of allowing redundancy in a table so that it can remain flat.
12. The operation that ends a unit of work by releasing locks so the database changes made can be perceived by other processes.
14. An identifier with a specific thread.
15. A SQL*Plus command that enables a SQL program to prompt a user for a variable at runtime and accept an input.
16. In DB2, a collection of tables that contain descriptions of objects such as tables, views, and indexes.
19. Main storage reserved to satisfy the buffering requirements for one or more tablespaces or indexes.
22. A runtime occurrence in PL/SQL or Java that requires special handling and may indicate an error.
23. A SELECT statement within the WHERE or HAVING clause of anther SQL statement
24. An explicitly stated "suggestion" to the Oracle optimizer embedded into a SQL statement as a comment.
26. The smallest unit of data manipulated in SQL.

Solution