Db2/400 Quiz - HCL-nrs

9 Questions | Attempts: 738
Share
SettingsSettings
Please wait...
  • 1/9 Questions

    Asterisk in position 7 indicates

    • File level Keyword
    • Field level keyword
    • Key field of the file
    • A comment line
    • None of the above
Please wait...
About This Quiz

This quiz is created for assesment after DB2/400 training

Db2 Quizzes & Trivia

Quiz Preview

  • 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

    Correct Answer
    A. PF,LF,DSPF,PRTF
  • 3. 

    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

    • 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

    Correct Answer
    A. Create a logical file on this file with emp name as key
  • 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

    Correct Answer
    A. CHGPF
  • 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

    Correct Answer
    A. Only Physical files can be journaled
  • 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

    Correct Answer
    A. SFLSIZ,SFLPAG
  • 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

    Correct Answer
    A. Create journal receiver, create journal, journal file
  • 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

    Correct Answer
    A. Joining the logical files only
  • 9. 

    PFILE is

    • File level keyword

    • Field level keyword

    • Records level keyword

    • All of the Above

    • Can be specified in a physical file only

    Correct Answer
    A. Records level keyword

Quiz Review Timeline (Updated): Mar 15, 2022 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 15, 2022
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 08, 2009
    Quiz Created by
    Anurodha
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.