DB2 Database Fundamentals

To store values up to 9999999.999, you need 7 digits before the decimal point and 3 digits after, requiring a total precision of 10. Thus, DECIMAL(10,3) is the correct data type.

When an application holding a Share lock needs to update a row, DB2 automatically converts (promotes) the row-level Share lock to an Update lock. The application does not need to explicitly release and reacquire locks - lock conversion is handled transparently by the database manager. Option D is incorrect because escalation is to table-level locks, not row-level Update locks.

Views are used to restrict access to specific rows or columns (A), simplify complex queries (D), and ensure data integrity through CHECK OPTION (B). Producing an action in response to table changes is the purpose of triggers, not views. Views are passive queries - they select data but cannot execute procedural logic in response to changes.

DB2 does not necessarily fetch all rows when opening a cursor. The behavior depends on cursor type and optimization - with a declared cursor, rows may be fetched one at a time as needed (FETCH operations), not all at once. The result set is materialized progressively, not entirely at cursor open time. This approach improves performance and reduces memory usage for large result sets.

Scalar functions in DB2 can be invoked using VALUES clause (A) for direct function calls returning a single value, or within a SELECT statement (B) to apply the function to each row. Option C (CALL) is used for stored procedures, not scalar functions. Option D is correct because both A and B demonstrate proper scalar function invocation syntax.

In SQL standard wildcard matching, the underscore character _ is used to represent a single character replacement, whereas the percent sign % represents zero or more characters.

Null indicator variables in COBOL use the picture clause S9(4) COMP. The S9(4) defines a signed 4-digit integer, and COMP (or COMP-4) specifies binary computational format. This is the standard declaration for indicator variables which are small integers (-1, 0, 1) used to detect null values in host variables. Options A (COMP-3) is packed decimal, B has no COMP specification, and C is unsigned.

In DB2, a SYNONYM is automatically dropped when its underlying table or tablespace is dropped. An ALIAS, however, is preserved even if the referenced table is dropped.

A schema is a collection of named database objects such as tables, views, and indexes. It provides a logical grouping and namespace for these objects. Tables are individual objects within a schema, not collections themselves. An alias is just an alternate name for an object.

In DB2, there is a limit on the number of tables that can be joined in a single query. The limit of 15 tables is a common constraint in many DB2 versions and mainframe environments. Options with 10, 20, or no limit do not represent the correct DB2 constraint.

SQL error code -805 in DB2 indicates that the application package or program name was not found in the specified plan, indicating a bind or execution mismatch.

B37 abend is a specific error code in mainframe systems indicating a DASD space issue - the dataset or work file has run out of space during SPUFI (SQL Processor Using File Input) execution. Data issues or missing records would result in different error codes like SQLCODEs, not B37.

Data can be retrieved from multiple tables using Joins (combining columns), Unions (combining rows), or Nested SELECT queries (subqueries). Therefore, all of the listed methods are correct.

Task Center is the correct tool in DB2 for automating table reorganization operations. Task Center allows scheduling and automating maintenance tasks including REORG commands. Control Center is for monitoring, Command Center is not a standard DB2 tool, and Command Line Processor is an interactive interface not an automation scheduler.

COL2 is the definition that will cause failure because VARCHAR columns cannot have DEFAULT NONE in DB2. The DEFAULT clause for VARCHAR must specify a valid string value or be omitted entirely. COL1, COL3, and COL4 definitions are syntactically valid.