mainframe Online Quiz - 90
|Description: mainframe Online Quiz - 90|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which parameter decides the allocation size for the tablespace
________is a collection of direct access volumes all of the same device type.
________means another name for the table, but is private to the user who created it.
Opens all tablespaces and acquires all tablespace locks when the plan is allocated
__________utility gathers information about data in tablespaces, indexes and updates DB2 catalog
If a transaction successfully updates a record, it is imperative that it has an ________ on it
If a table is dropped, the space for that table can be reclaimed with minimum reorg in
In Partitioned Tablespace, individual partitions cannot be independently recovered and reorganized
DB2 Security is provided internal to DB2 using the
DEFINE DATA LOCAL 1 #VAR-1 (A25) END-DEFINE MOVE 'THIS IS MY FIRST PROGRAM' TO #VAR-1 WRITE #VAR-1 END The above statements are correct or not.
Packed numeric, 7 positions before and 2 after decimal point and 1 sign position
Command used to catch the syntax errors
A list of the last names and salaries of all employees earning at least $40,000 a year. READ EMPLOYEES WITH SALARY STARTING FROM 40000 DISPLAY NAME SALARY END
What the EXAMINE command will do
What is name of the debug tool for natural programs
Which parameter will be used to stop the execution of a step(which resides in the proc) in JCL.
Which option will be used for spilitting the file using the records count
What does abend code S806 signify
Which parameter is used to call the jcl from another jcl
What does AVGREC parameter will do