Db2/400 Quiz - HCL-nrs - Quiz & Trivia

1. Asterisk in position 7 indicates

File level Keyword

Field level keyword

Key field of the file

A comment line

None of the above

2. Attributes of physical files, logical files, display files and printer files are

PF,LF,DSPF,PRT

PF,LF,DSP,PRT

PF,LF,DSPF,PRTF

*FILE,*FILE,*FILE,*FILE

None of the above

3. A physical file has following fields with emp number as key.
Emp No.
Emp Name
Phone Number.
This file needs to be used in a new program using employee name as key. Best possible solution is

Change the key of physical file to emp name

Create another physical file with emp name as key and copy this data

Create a logical file on this file with emp name as key

Use SQL to read the file

None of the Above

4. A physical file is changed to add a new field in it. This file contains data. What command must be used to create the file with new strucure and old data

CHGF

DLTF, CRTF

CHGPF

MODPF

None of the above