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

5. Which statement is correct

Physical and Logical files can be journaled

Only Logical Files can be journaled

Only Physical files can be journaled

Physical file can be deleted before logical file

Logical file can be created on another logical file

6. Keywords for number of records in subfile and number of records on page are

SFLSIZ,SFLPAGE

SFLSIZE,SFLPAGE

SFLSIZ,SFLPAG

SUBSIZ,SUBPAG

None of the Above

7. In order to journal a file, steps to be followed are

Journal the file, create journal receiver, create journal

Create journal, create journal receiver, journal file

Create journal receiver, journal file, create journal

Create journal receiver, create journal, journal file

None of the Above

8. JFILE keyword is used for

Joining the physical files

Joining the physical and logical files

Joining the logical files only

This is not a valid key word

None of the Above

9. PFILE is

File level keyword

Field level keyword

Records level keyword

All of the Above

Can be specified in a physical file only