DB2 Dump for 700
Posted by admin on June 4, 2010
0 comments
Hi Friends
I am attaching DB2 UDB V8.1 Family Fundamentals dump.
Exam code : 700
Hope it will helps you
VSAM SECTION3
Posted by admin on April 13, 2010
0 comments
SECTION 3
Choose the correct answer:
1) Which VSAM clusters support only fixed length records? (b)
a LDS
b RRDS
c ESDS
d KSDS
2) FREESPACE can be specified for which type of cluster? (d)
a LDS
b RRDS
c ESDS
d KSDS
3) In which cluster type are records added at the end of the data set? (c)
a LDS
b RRDS
c ESDS
d KSDS
4) The types of processing supported by RRDS are (e)
a sequential
b skip-sequential
c direct
d a and b
e a, b and c
5) The types of processing supported by ESDS are (d)
a sequential
b skip-sequential
c direct
d a and b
e a and c
6) Spanned records can be found in (d)
a ESDS
b KSDS
c RRDS
d a or b
e a or c
7) Spanned records can be accessed in (a)
a MOVE
b LOCATE
c a and b
d None
Alternate Index is a special type of (a)
a KSDS
b ESDS
c RRDS
d None
9) Specifying CISZ(4096) at the cluster level for a KSDS results in (c)
a VSAM ignoring the specification
b Data and index CISZ 4k each
c Data CISZ 4k; index CISZ selected by VSAM
d Index CISZ 4K; data CISZ selected by VSAM
10) When defining a KSDS, which of the following parameters is not required? (b)
a Space allocation (either CYL, REC or TRK)
b VOLUMES
c KEYS
d NAME
11) Default RECORD SIZE for a NONSPANNED data set is (d)
a (80 80)
b (4086 32600)
c (100 32600)
d (4089 4089)
12) If the key of a KSDS record begins in the second field (first field is 25 bytes long), the offset in the
KEYS parameter is (a)
a 24
b 25
c 26
d None
13) Data organization in KSDS is (a)
a INDEXED
b NUMBERED
c LINEAR
d NONINDEXED
14) The default cluster type is (d)
a ESDS
b RRDS
c LDS
d KSDS
15) VOLUMES parameter can be specified at (c)
a cluster level
b data level and index level
c All the above
d None
16) The RECORDSIZE parameter cannot be coded for (c)
a ESDS
b RRDS
c LDS
d KSDS
17) The default PRINT format is (b)
a Character
b Dump
c Hexadecimal
d None
18) Which of the following REPRO selection parameters can be specified for an LDS? (e)
a FROMKEY
b FROMADDRESS
c FROMNUMBER
d SKIP
e None
19) The REPLACE parameter causes (c)
a KSDS records to be replaced by an input record with the same key
b ESDS records to be replaced by an input record with the same RBA
c RRDS records to be replaced by an input record with the same RRN
d a and c
e All the above
20) Which of the following is not a modal command? (e)
a IF
b THEN
c ELSE
d DO
e GOTO
21) Using REPRO to reorganize a KSDS, which of the following is true? (e)
a Input must be ascending key sequence.
b No duplicate keys are allowed.
c Non-unique keys are allowed.
d a and c
e a and b
22) Which of the following entry names are valid for ALTER FREESPACE? (b)
a Cluster name
b Data component name
c Index component name
d b and c
e a, b and c
23) Which of the following is a correct generic name specification for TEST.USER.DATA.A? (a)
a TEST.USER.*
b TEST.*.*.A
c *.USER.DATA.A
d TEST.USER.*.A
24) To alter a cluster to an LDS, the cluster must (e)
a be an ESDS
b be NONSPANNED
c have a CISZ of 4K
d not have an alternate index associated with it
e all the above
25) For which access mode below must the application program interpret RDFs? (b)
a KEY
b ADR
c ADR(for a KSDS)
d CNV
e None
26) At OPEN, VSAM determines processing options in the following order (d)
a JCL, program, catalog
b program, JCL, catalog
c JCL, catalog, program
d catalog, program, JCL
e None
27) VSAM request macros (e.g., GET, PUT) point to which other macros? (c)
a OPEN
b ACB
c RPL
d CLOSE
e b and c
f None
28) If a program uses direct processing exclusively, DIR is specified in which macros? (c)
a OPEN
b ACB
c RPL
d CLOSE
e b and c
f None
29) VSAM processing options could be specified in (e)
a Catalog
b Program control blocks
c JCL
d None
e All the above
30) Which of the following is not a COBOL verb? (d)
a START
b READ
c DELETE
d UPDATE
e REWRITE
31) Which of the following is/are not supported by COBOL? (d)
a Skip-sequential processing
b RBA addressing
c Replacing existing record
d a and b
e a, b and c
f a and c
32) Which is a valid SHAREOPTIONS specification? (b)
a SHR(2 2)
b SHR(2 3)
c SHR(4 1)
d SHR(1 2)
e None
33) For a data set defined with SPEED, which of the following is true? (a)
a SPEED is effective for the initial load only.
b SPEED is effective for all additions to the data set after initial load.
c If the load program ABENDS, VERIFY can determine the HIGH-USED-RBA of the data set.
d If the load program ABENDS, only those records remaining in buffers need to be added to the data set.
e None
34) VERIFY cannot be used for (c)
a Empty data set
b LDS
c a and b
d None
35) For a data set defined with NOERASE, which of the following is not true? (a)
a Desirable for sensitive data
b Removes catalog entries
c All the above
d None
36) Buffer space cannot be specified in which of the following? (d)
a DD statement
b Assembler program
c AMS DEFINE
d COBOL program
37) How many data buffers are required for sequential processing to overlap I/O processing? (c)
a 2
b 3
c 4
d 5
38) When defining a KSDS, the best place to specify CISZ is generally (b)
a At the cluster level
b At the data level only
c At the index level only
d At both data and index levels
39) For direct processing the recommended number of data buffers is (b)
a STRNO
b STRNO+1
c STRNO+2
d STRNO+3
e None
40) For 3380 DASD, TRK(50 5) results in which CA size for a KSDS defined with NOIMBED? (b)
a 1 TRK
b 5 TRKS
c 15 TRKS
d 50 TRKS
e None
41) Suppose you are defining a multi-volume data set with VOL(A B) and five key ranges specified. Which of the following correctly indicates where each key range will be located? (c)
a First key range on VOL A; second on B; third on A; etc.
b First key range on VOL B; second on A; third on B; etc.
c First key range on VOL A; remaining key ranges on B.
d All key ranges on VOL A; B is used for overflow only.
e All key ranges on VOL B; A is used for overflow only.
42) An alternate index can be defined for which cluster type? (b)
a KSDS and RRDS
b KSDS and ESDS
c KSDS and LDS
d KSDS only
e KSDS, ESDS and RRDS
43) If an application program accesses a base cluster in alternate key sequence, then DD statements are needed for which data sets? (f)
a Base cluster
b Alternate index
c Path
d a and b
e a and c
f a, b and c
44) An alternate index itself is which cluster type? (d)
a LDS
b RRDS
c ESDS
d KSDS
e None
45) Which of the following backs up data in CI mode? (b)
a REPRO only
b EXPORT only
c Both REPRO and EXPORT
d Neither REPRO nor EXPORT
46) Which of the following writes catalog information into the backup data set? (b)
a REPRO only
b EXPORT only
c Both REPRO and EXPORT
d Neither REPRO nor EXPORT
47) Which of the following requires a DELETE/DEFINE before the command can be used to restore an
existing data set? (a)
a REPRO only
b IMPORT only
c Both REPRO and IMPORT
d Neither REPRO nor IMPORT
48) With HBACKDS the use of apostrophes to enclose the dsname is (b)
a Required
b Used to exclude the TSO id as the high level qualifier
c Required only if one or more segments are specified generically
d Not allowed if the data set is password protected