A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRM and Packages. According to the text, which statement best defines a Plan?

A DBRM is nothing more than a module containing SQL statements extracted from a source program by the DB2 precompiler. It is stored as a member of a partitioned dataset. According to the text, what is the correct definition of a DBRM?

A Package is a single, bound DBRM with optimized access paths. Prior to DB2, the only option available for binding was at the plan level. By using packages, the table access logic is "packaged" at a lower level of granularity, at the Package or program level. According to the text, what is the correct definition of a Package?

A process represents the input or output of a record or map. It consists of processing statements before and after a process option (type of I/O operation), and a process object (name of the defined record structure or map that the process option uses). A process is divided logically into the processing statements that are to be run before and after the process option is performed. Processes can be defined as main processes of the application or invoked from other processes or statement groups. According to the text, which is the correct answer?

Applications are defined as a top-down structure of processing logic blocks called processes and statement groups. The top level in the structure is a sequence of one or more processes called main processes. Each process and statement group contains CSP/AD language processing statements. According to the text, which is the correct answer?

PROCSEQ specifies the name of a secondary index that is used to process the database named in the DBNAME operand through a secondary processing sequence. The operand is optional. It is valid only if a secondary index exists for this database. According to the text, which is the correct answer?

An online application program always has exclusive use of the SHSAM or HSAM databases, which are referenced by PCBs in its PSB. No other application programs will be concurrently scheduled to access those same SHSAM or HSAM databases in an online environment. According to the text, which is the correct answer?

Floating-point exponentiation under COBOL II can yield more accurate results than fixed-point exponentiation. In addition, both VS COBOL and COBOL II do computations of fixed-point data items with large exponents faster in floating-point. The floating-point computations should even be more accurate than fixed-point computations. According to the text, which is the correct answer?

In VS COBOL, as well as in COBOL II, the period is an implicit scope terminator that ends the scope of any statements that have not yet terminated. For example, the scope of an AT END, ON OVERFLOW or ON SIZE ERROR clause in a VS COBOL program remains in effect until a period is reached. According to the text, which is the correct answer?

COBOL II is IBM's newest COBOL compiler that runs on IBM mainframes. It is based upon the VS COBOL programming language that has been used for years. It provides virtual storage constraint relief by allowing COBOL II programs, program data, the COBOL II compiler, and COBOL II library routines to run both above and below the 16 megabytes in line.

According to the text, which is the correct answer?