Home / CSE MCQs / VSAM ::

CSE MCQs :: VSAM

  1. The utility used for sorting or merging is
  2. A.
    Dsort
    B.
    Dfsort
    C.
    Sort
    D.
    Dfmerge

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. What are the disadvantages of Vsam?
  4. A.
    VSAM Datasets require more storage space compared to other type of datasets due to Control information(CI) present in them
    B.
    VSAM can't be stored in TAPE Volume i.e., VSAM Stored only in DASD
    C.
    VSAM is not a database like DB2, IMS DB & IDMS
    D.
    All the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. What is the purpose of control intervals in VSAM?
  6. A.
    Control intervals are used to store the data sets of three types
    B.
    These are stored in groups and the control intervals allow the size of the groups to be controlled according to the optimization size
    C.
    To optimize the size the record length and type the disk device will be use
    D.
    All of the above mentioned

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. What are the IDCAMS commands that can be used for VSAM?
  8. A.
    To modify the information for a catalog, alternate index, cluster or a path, ALTER command is used
    B.
    DEFINE command is used for ALTERNATEINDEX, CLUSTER or PATH
    C.
    DELETE command is used for removing the catalog for a catalog, cluster, alternate index or path
    D.
    All of these

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. What are the Common Vsam error conditions and codes?
  10. A.
    End of file
    B.
    Duplicate key
    C.
    Record not found
    D.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. What are the different types of VSAM files available?
  12. A.
    ESDS
    B.
    KSDS
    C.
    RRDS
    D.
    All of these

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. What are the advantages of Vsam?
  14. A.
    Accessing the data is faster and easier
    B.
    VSAM supports more dataset types
    C.
    Supports variety of I/O Techniques
    D.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. What is Control Interval?
  16. A.
    Control Interval is similar to the physical block for QSAM files
    B.
    It is represented as the unit of I/O
    C.
    A control unit's range must be 512 bytes to 32 KB
    D.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. What is meant by dirty read in VSAM?
  18. A.
    High degree of concurrent access to VSAM files is achieved by an dirty read
    B.
    It is done by avoiding the complications associated with CI and CA splits
    C.
    Both A and B
    D.
    None

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. How is the sorting of VSAM files carried?
  20. A.
    The sorting of the VSAM files or records can be done either in ascending sequence or descending sequence
    B.
    There is a use of DEFINE CLUSTER that allocated the data set to the NON-INDEXED location for the sorting to take place
    C.
    The result will be generated in the sorted format of the dataset
    D.
    All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum