Db2/400 Quiz - HCL-nrs
This quiz is created for assesment after DB2/400 training
- 1.Which statement is correct
- A.
Physical and Logical files can be journaled
- B.
Only Logical Files can be journaled
- C.
Only Physical files can be journaled
- D.
Physical file can be deleted before logical file
- E.
Logical file can be created on another logical file
- 2.PFILE is
- A.
File level keyword
- B.
Field level keyword
- C.
Records level keyword
- D.
All of the Above
- E.
Can be specified in a physical file only
- 3.In order to journal a file, steps to be followed are
- A.
Journal the file, create journal receiver, create journal
- B.
Create journal, create journal receiver, journal file
- C.
Create journal receiver, journal file, create journal
- D.
Create journal receiver, create journal, journal file
- E.
None of the Above
- 4.JFILE keyword is used for
- A.
Joining the physical files
- B.
Joining the physical and logical files
- C.
Joining the logical files only
- D.
This is not a valid key word
- E.
None of the Above
- 5.Attributes of physical files, logical files, display files and printer files are
- A.
PF,LF,DSPF,PRT
- B.
PF,LF,DSP,PRT
- C.
PF,LF,DSPF,PRTF
- D.
*FILE,*FILE,*FILE,*FILE
- E.
None of the above
- 6.Asterisk in position 7 indicates
- A.
File level Keyword
- B.
Field level keyword
- C.
Key field of the file
- D.
A comment line
- E.
None of the above
- 7.Keywords for number of records in subfile and number of records on page are
- A.
SFLSIZ,SFLPAGE
- B.
SFLSIZE,SFLPAGE
- C.
SFLSIZ,SFLPAG
- D.
SUBSIZ,SUBPAG
- E.
None of the Above
- 8.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
- A.
CHGF
- B.
DLTF, CRTF
- C.
CHGPF
- D.
MODPF
- E.
None of the above
- 9.A physical file has following fields with emp number as key.Emp No.Emp NamePhone Number.This file needs to be used in a new program using employee name as key. Best possible solution is
- A.
Change the key of physical file to emp name
- B.
Create another physical file with emp name as key and copy this data
- C.
Create a logical file on this file with emp name as key
- D.
Use SQL to read the file
- E.
None of the Above
Questions: 20 | Attempts: 3087 | Last updated: Mar 21, 2022
-
Sample QuestionIn referential integrity each foreign key value have a matching ___________ Value.
Questions: 9 | Attempts: 8579 | Last updated: Mar 21, 2022
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Questions: 31 | Attempts: 7486 | Last updated: Mar 22, 2022
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Back to top