Db2/400 Quiz - HCL-nrs

9 Questions | Total Attempts: 735

SettingsSettingsSettings
Please wait...
Db2 Quizzes & Trivia

This quiz is created for assesment after DB2/400 training


Questions and Answers
  • 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

Related Topics
Back to Top Back to top