Get documents about "Questions on CICS DB2 AND JCL pitch
Document Sample
Questions on CICS
1. 10 users initiate a transaction “TRN1” simultaneously. Which of the following statements are true
a. There are 10 tasks and 10 transactions running in the system
b. There are 10 tasks and 1 transaction running in the system
c. There are 1 task and 10 transactions running in the system.
d. There is 1 task and 1 transaction running in the system
2. The scope of Handle command
a. propagates to called programs
b. Does not propagate to a called programs
c. Can be made to propagate to a called program by translate / compile options.
3. What does the CICS Attachment Facility do?
a Formats requests from CICS terminals for an application to access DB2 resources
b Provides data base services
c Returns the results of a program's execution to the CICS terminal
d Allows CICS command level applications issuing SQL statements to access DB2 resources
4. What does a thread do?
a) Defines an MVS subtask to run DB2 code
b) Defines the existence of an application's connection and traces its progress
c) Provides the resources for a CICS attachment and traces its progress
d) Creates control blocks (TCBs)
5. For the application programmer, one of the main uses of CICS control blocks is to
a) provide storage areas for data.
b) control Skip Sequential processing.
c) control how memory is allocated for online applications.
d) provide a scratch pad to modify system-related fields.
6. The CSA and CWA exist as long as
a) a particular task is running.
b) space is available.
c) CICS is running.
d) a task is run from the same terminal.
7. The TCA and TWA exist as long as
a) a particular task is running.
b) space is available.
c) CICS is running.
d) a task is run from the same terminal.
8. The TCTTE and TCTUA exist as long as
a) a particular task is running.
b) space is available.
c) the terminal is allocated to CICS.
d) a task is run from the same terminal.
9. The EIB exists as long as
a) a particular task is running.
b) space is available.
c) CICS is running.
d) a task is run from the same terminal.
10. To refer to fields in the EIB, you must
a) define EIB within the program.
b) first check to see which Attention key was pressed.
c) assign values to the EIB.
d) know the field name.
11. EDF will intercept and display status before executing the ------------------ command.
a) HANDLE CONDITION
b) MOVE
c) PERFORM
d) All of the above
12. Assume that the temporary storage queues MONITORQ, TOTALQ, and TESTQ already exist on the
system. If another temporary storage queue is to be created, which of the following queue names would be
acceptable?
a) TOTALQ
b) TRACKINGQ
c) TALLYQ
d) TOTALQUEUE
13. Before you use a temporary storage queue you must make sure the system programmer has defined it in the
File Control Table or in the CICS System Definition Data Set. True or False
14. Suppose you are writing a CICS/ESA program that stores data that is to be read by a non-CICS/ESA
program. Can you use an extrapartition data queue to store the data? Yes / No
15. Which kind of transient data queue allows records to be accessed randomly?
a) Extrapartition
b) Intrapartition
c) Both
d) Neither
16. Assume that two CICS/ESA programs are to read the same record created by ORDTEST at different times.
Which transient data queue can you use to store the data output from ORDTEST?
a) Extrapartition
b) Intrapartition
c) Both
d) Neither
17. Assume you are writing a CICS/ESA program that stores data to be read by another CICS/ESA program.
The program that reads the data is to be started after 50 records have been written to the queue. Which transient
data queue can you use to store the data?
a) Extrapartition
b) Intrapartition
c) Both
d) Neither
18. Which exceptional condition should your program handle to avoid an abnormal termination if your program
is executed via automatic task initiation?
a) IOERR
b) LENGERR
c) QIDERR
d) QZERO
19. What type of data set could you access in virtual storage and have all of its updates within the CICS region
synchronized?
a) CICS-maintained Data Table
b) User-maintained Data Table
c) Source VSAM KSDS data set
d) Database
20. What type of data set could you load into virtual storage by building keyed records using data from a
database?
a) CICS-maintained Data Table
b) User-maintained Data Table
c) Source VSAM KSDS data set
d) Database
Questions on DB2
1.What does SQL State 00000 mean?
a. Successful Execution of SQL
b. Warnings
c. Unsuccessful Execution of SQL
d. None of the above.
2. Where does DB2 keep the details about the changes made to its Active log
a. A second active log
b. Archive log
c. Boot Strap Data Set
d. DB2 Catalog
3. A cursor is declared using WITH HOLD option.
a. When a Commit or Rollback is issued the cursor is closed
b. When a commit is issued the cursor is closed; but when a rollback is issued the cursor is not closed
c. When a commit is issued the cursor is not closed; but when a rollback is issued the cursor is closed
d. The cursor is not closed when we commit or Rollback.
4. Which of the following statements regarding the differences between a Synonym and an Alias are true?
(I) An alias and a synonym is an alternative name for a table
(II) An alias can be used by all the users; but a Synonym is private to the user who creates it.
(III) An alias is private to the user who creates it, while a Synonym can be used by all the users.
a. I and II
b. I and III
c. Only I
d. None of the three are true
5. A DB2 table is created with a Primary Key specified. Which of the following is true?
a. A unique index is required to enforce primary key uniqueness.
b. Data can be inserted into the table before an index is created.
c.
6. Can we declare a table with a Primary Key having the constraints not null with default? Yes or No.
7. For the imagecopy utility to be run the DB2 subsystem must be brought down? True or False.
8. If you specify the _________________ option in the “create table” statement, then the RDBMS will insert a
null in that column if the user does not enter a value.
a. Unique
b. Primary
c. Null
d. None of the above
9. There are two types of embedded SQL SELECT statements, _____________ SELECTs and ___________
SELECTs
a. single and multiple
b. one-value and multi-value
c. singleton and cursor
d. None of the above
10. Which of the following statements best describes when to use IF SQLCODE?
a. Is always used after each SQL statement
b. Is coded after a SQL statement is executed and verification of these results are required
c. Can be in the place of the WHENEVER statement before an SQL statement is executed
d. Is coded immediately after the Procedure Division
11. You've just executed the REORG utility and received a return code of 0. What should you do next?
a) Rerun the utility.
b) Start the data base.
c) Generate JCL using the DB2 Utilities Panel.
d) Continue with your planned activities.
12. Why is it important to code one utility per job stream?
a) If the utility fails, it's easier to identify and correct problems.
b) If you run one utility per job stream, processing is much more efficient.
c) DB2 requires that you run only one utility per job stream.
13. You have just executed the JCL for the REORG utility. You notice that DB2 returns a code of 8. What
should you do next?
a) Examine the REORG utility JCL and then restart the data base.
b) Rerun the REORG utility with attention given to each phase.
c) Check SYSPRINT along with your DB2 Messages and Codes Manual to determine error severity.
d) Stop the data base, wait one day, and then restart the data base.
14. What is the recommended way to ensure successful completion of a utility run?
a) Code multiple utilities per job stream.
b) Code complex job return codes.
c) Code one utility per job stream.
15. You have been presented with the following tasks. Which of these task descriptions best defines normal
DB2 operations?
a) Resolving resource unavailability by analyzing an application to determine the cause of a problem.
b) Starting or stopping the DB2 subsystem and subsystem attachment, and start or stop DB2 data bases.
c) Recovering damaged user data after an application program abends and user data is lost.
16. You are about to start DB2. Select the best description of why you would take this action. You need to
a) reconnect attached subsystems and reset subsystem parameters.
b) restrict subsystem access and reset subsystem parameters.
c) initiate recovery and install a requested ID.
d) install a load module and respond to an MVS START message.
17. Where is a QMF item, such as a query, kept when it's being referenced during a QMF session?
a) in QMF
b) in the DB2 data base
c) in its corresponding temporary storage area
d) in the system data base
18. For QMF you specify the output file which stores the results of the SQL Query. Yes / No.
19. Which of the following methods would present a Query Panel that displays the last query accessed during
your current QMF session?
a) entering the command RESET QUERY
b) entering the command EXIT
c) pressing the PF key assigned to END
d) pressing the PF key assigned to QUERY
20. Which of the following statements does not describe the authority level of SYSADM?
a) A SYSADM can grant group-level privileges.
b) A SYSADM can update the DB2 catalog.
c) A SYSADM has control over almost all DB2 resources.
d) A SYSADM can revoke single-level privileges.
Questions on JCL
1. Why do you use INTRDR for?
2. What is the difference between CLASS and MSGCLASS?
3. Suppose you have a statement that requires a combination of positional and keyword parameters. Which of
these represents the correct sequence?
a) Keyword, keyword, positional
b) Positional, keyword, positional
c) Positional, positional, keyword
d) Keyword, positional, keyword
4. //linename JOB PARM=number
Based on the manual notation above, which of the following is acceptable JCL code?
a) //JOBNAME JOB Parm=6
b) //JOBNAME JOB PARM=number
c) //linename JOB PARM=value
d) //JOBNAME JOB PARM=6
5. //linename JOB PARM={OLD|NEW|BORROWED}
Based on the manual notation above, which of the following is acceptable JCL code for this parameter?
a) //JOBNAME JOB PARM=OLD,NEW,BORROWED
b) //JOBNAME JOB PARM=|NEW|
c) //JOBNAME JOB PARM={BORROWED}
d) //JOBNAME JOB PARM=OLD
6. If the TIME parameter is coded, which subparameter values are required?
a) 1440
b) TIME=
c) Either 1440 or minutes and/or seconds
d) Both minutes and seconds are required
7. What function do parentheses serve in JCL notation?
a) Enclose optional code
b) Enclose required values
c) Enclose multiple values
d) Start a JCL comment statement
8. Which of the following is a restriction for coding positional and keyword parameters?
a) Positional and keyword parameters are coded alphabetically.
b) Keyword parameters may be coded before positional parameters.
c) Parameters may be coded in any order but must be separated by commas.
d) All positional parameters used must be coded before any keyword parameters.
9. Which of the following represents a time of 3 minutes in correct coding syntax? Assume any code that is not
required has been omitted.
a) TIME=(,3)
b) TIME=3,
c) TIME=(3)
d) TIME=<3>
e) TIME={3,0}
10. Which of the following parameters refers to an input job class?
a) CLASS=1,
b) MSGCLASS=1,
c) MSGLEVEL=1,
d) TIME=1,
11. Which of the following is true about comment statements?
a) Comments are single words surrounded by asterisks.
Example: *** COMMENT ***
b) Comments appear in columns 72-80 only.
c) A comment line is identified by //* in the code and *** on the line print in columns 1, 2, and 3.
d) Comments can not be made within an series of JCL instructions.
12. Which of the following statements is correct about the DEFER subparameter of the UNIT parameter?
a) Names a specific device to be used when the originally requested device is unavailable
b) Is used to request that volumes not be mounted until data sets are opened
c) Is used to concentrate a group of devices
13. Which of the following is a correct format for the UNIT parameter?
a) UNIT=(<DEFER><,,device>)
b) UNIT=(<AFF><,,DEFER>)
c) UNIT=(<device><,,DEFER>)
d) UNIT=(<device><,,group>)
14. What device serial number does the SER subparameter of the VOLUME parameter specify?
a) Disk or tape volume which contains the data set
b) Device type on which the volume is mounted
c) Disk or tape drive on which the volume is mounted
15. If JCL specifies the RETAIN subparameter, what would the system do with the volume?
a) Mount it for the current job step.
b) Dismount it after the current job step.
c) Not mount it for the current job step.
d) Not dismount it after the current job step.
16. What does the PRIVATE subparameter of the VOL parameter specify about the volume?
a) Mount the volume for the current job step.
b) Use the volume only when specifically requested.
c) Volume can be used only by the specified owner.
17. Which of the following statements is true of the LABEL parameter?
a) Requests disk space on a DASD volume for a data set
b) Identifies the volume on which a data set will reside
c) Describes the type of internal labels on a data set
18. Which subparameter of the LABEL parameter indicates that a data set can be used as read only?
a) IN
b) OUT
c) label
19. Which of the following statements is correct of the Data Control Block information?
a) If the record length is not supplied in the program, the system next will look at the data set label to
determine the record length.
b) If the blocksize is not specified in the program or JCL, the system will cause an ABEND.
c) If the record format is not supplied in the JCL or the program, the system will look at the data set label.
20. Which of the following is correct of the BLKSIZE subparameter?
a) Format of each record is specified
b) Number of bytes in a single record is specified
c) Number of bytes in a block is specified
21. Which of the following is preferred for indicating the end of in-stream data?
a) *
b) /*
c) //
22. With which of the following JCL statements do you use the PARM parameter?
a) JOB
b) EXEC
c) DD
d) OUTPUT
23. Why do you use data set concatenation?
a) To combine multiple data sets into one data set logically but not physically
b) To read a multivolume data set
c) To separate one data set into multiple data sets logically but not physically
d) To sort data sets on two or more devices
24. When you concatenate data sets, where will the data sets originate?
a) They must reside on different devices and share the same device type.
b) They may reside on different devices, but must share the same device type.
c) They may reside on different devices and also on different device types.
25.
DAILY 1 SINGLE S 8 1/2 x 11 *
WEEKLY 2 DUPLICATE D 8 1/2 x 14 +
MONTHLY 3 TRIPLICATE T STANDARD -
ON-REQUEST 0
Using the table shown above, code a PARM parameter specifying weekly reports printed in triplicate on 8 1/2
by 14 forms. Assume this JCL statement does not continue.
a) //STEP01 EXEC PGM=REPORT, ,PARM='2,t,+'
b) //STEP01 EXEC PGM=REPORT, ,PARM=(2,t,’+')
