VSAM MCQ Quiz With Answers

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Srinimf

Srinimf

Community Contributor

Quizzes Created: 6 | Total Attempts: 22,469

Questions: 15 | Attempts: 6,283 | Updated: Aug 24, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Do you understand all concepts of VSAM well? To see if you know everything or not, take this VSAM Quiz. VSAM is basically the Virtual Storage Access Method which is widely used for high performance of the mainframe data. This is the quiz mainly for Mainframe and CICS professionals. Here, you can test your knowledge as well as enhance it by learning new things. All the best for a perfect score on this quiz! Do not forget to share the quiz.

Questions and Answers

1.

What is the Record format for VSAM file?
- A.
  
  VB
- B.
  
  FBA
- C.
  
  FB
- D.
  
  None of the above
Correct Answer
A. VB

Explanation
The record format for a VSAM file is Variable Blocked (VB). In this format, each record in the file can have a different length, and records are grouped into blocks of data. This allows for efficient storage and retrieval of variable-length records. The other options, FBA (Fixed Blocked) and FB (Fixed Blocked), are not the correct formats for a VSAM file.

Rate this question:

1
0
2.

RLS stands for Record Level Sharing
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
This is used to share each record by batch process.

Rate this question:

1
0
3.

Can we Query on VSAM file like DB2?
- A.
  
  Yes
- B.
  
  No
- C.
  
  VSAM is not RDBMS
- D.
  
  None of the above
Correct Answer
A. Yes

Explanation
VSAM (Virtual Storage Access Method) is a file storage access method used in mainframe computers. While it is not a relational database management system (RDBMS) like DB2, it is still possible to query data stored in a VSAM file. VSAM provides various access methods, such as sequential, random, and indexed, which can be used to retrieve and manipulate data. Therefore, although it may not have the same capabilities as DB2, querying on a VSAM file is still possible.

Rate this question:

1
0
4.

VSAM has four file types KSDS, RRDS, ESDS, and LDS. Out of that, which one is being used, DB2 underlying tables?
- A.
  
  RRDS
- B.
  
  KSDS
- C.
  
  LDS
- D.
  
  ESDS
Correct Answer
C. LDS

Explanation
LDS. This linear sequential VSAM file

Rate this question:

1
0
5.

Which command do we use to see the VSAM file in CICS?
- A.
  
  CEBR
- B.
  
  CEMT I
- C.
  
  CEDA
- D.
  
  None
Correct Answer
B. CEMT I

Explanation
CEMT I FILE(FILENAME)

Rate this question:

1
0
6.

Broadly how many parts of a VSAM data set can be classified?
- A.
  
  2
- B.
  
  3
- C.
  
  4
- D.
  
  None
Correct Answer
A. 2

Explanation
A VSAM data set can be classified into two broad parts: the data component and the index component. The data component contains the actual records or data stored in the data set, while the index component contains the index entries that allow for efficient access and retrieval of the data. These two components work together to provide efficient storage and retrieval capabilities in a VSAM data set.

Rate this question:

2
0
7.

KSDS Load process is carried with Sequential access instead of Direct access.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The KSDS Load process is carried out with sequential access instead of direct access. This means that the records are read and loaded into the KSDS (Key Sequenced Data Set) in a sequential manner, one after the other. Sequential access is typically used when the records are stored in a specific order and need to be processed in that order. In contrast, direct access allows for accessing specific records directly without having to go through the entire dataset sequentially. Therefore, the statement "KSDS Load process is carried with Sequential access instead of Direct access" is true.

Rate this question:
8.

ESDS records can not be deleted. How can this be done by the programmer when logic wants to delete a record?
- A.
  
  Programmer helpless
- B.
  
  Can delete a record.Only flag sets as inactive record
- C.
  
  None
Correct Answer
B. Can delete a record.Only flag sets as inactive record

Explanation
The correct answer suggests that although ESDS (Entry Sequenced Data Set) records cannot be deleted, the programmer can still simulate the deletion by setting a flag that marks the record as inactive. This means that the record is technically still present in the dataset, but it is considered inactive and will not be accessed or used in any further processing. This approach allows the programmer to achieve the desired outcome of "deleting" a record while working within the limitations of ESDS.

Rate this question:
9.

In ESDS, the first record RBA is '0'. The record length is '80' bytes. So what is RBA for 2nd record?
- A.
  
  1
- B.
  
  2
- C.
  
  80
- D.
  
  None
Correct Answer
D. None

Explanation
0+80=80

Rate this question:

1
0
10.

For the RRDS cluster, what is the keyword we define in the IDCAMS DEFINE command?

Correct Answer
NUMBERED

Explanation
In the context of the RRDS (Relative Record Data Set) cluster, the keyword "NUMBERED" is used in the IDCAMS DEFINE command. This keyword is used to specify that the records in the RRDS cluster are to be numbered sequentially. By using this keyword, each record in the cluster will have a unique number associated with it, allowing for easy identification and retrieval of specific records within the cluster.

Rate this question:

4
11.

One difference between KSDS and (RRDS, ESDS, LDS). KSDS= Contains both RDF/CIDF RRDS,ESDS,LDS=All are data components
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
The correct answer is true because KSDS (Key Sequenced Data Set) is a type of VSAM (Virtual Storage Access Method) file organization that contains both Relative Data Format (RDF) and Control Interval Data Format (CIDF). On the other hand, RRDS (Relative Record Data Set), ESDS (Entry Sequenced Data Set), and LDS (Linear Data Set) are all different types of data components used in mainframe systems. Therefore, the statement is true as it correctly highlights the difference between KSDS and the other data components.

Rate this question:
12.

Is DITTO one of the tools used to work with VSAM files?
- A.
  
  Yes
- B.
  
  No
- C.
  
  I never heard
- D.
  
  None
Correct Answer
A. Yes

Explanation
DITTO is indeed one of the tools used to work with VSAM files.

Rate this question:
13.

HFS- Hierarchical file system on Unix. ZFS-Z series file system on Unix Both are ESDS VSAM files. But ZFS files have metadata log. So when a disaster occurs, ZFS files are recoverable.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
ZFS files have a metadata log, which means that in the event of a disaster, these files can be recovered. This implies that the metadata log in ZFS allows for the restoration of data even after a catastrophic event. Therefore, the statement "ZFS files are recoverable" is true.

Rate this question:
14.

Can VSAM files be accessed by both Batch and CICS?
- A.
  
  Yes in CICS transaction server
- B.
  
  No
- C.
  
  I never heard
- D.
  
  None
Correct Answer
A. Yes in CICS transaction server

Explanation
Yes, VSAM files can be accessed by both Batch and CICS. CICS (Customer Information Control System) is a transaction processing system that allows online access to applications and databases. It provides a way to interact with VSAM (Virtual Storage Access Method) files in real-time, allowing users to access and update data stored in these files during online transactions. Therefore, the correct answer is "Yes in CICS transaction server."

Rate this question:

1
0

Quiz Review Timeline +

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

Current Version
Aug 24, 2023

Quiz Edited by
ProProfs Editorial Team
Mar 30, 2013

Quiz Created by
Srinimf

VSAM MCQ Quiz With Answers

What is the Record format for VSAM file?

RLS stands for Record Level Sharing

Can we Query on VSAM file like DB2?

VSAM has four file types KSDS, RRDS, ESDS, and LDS. Out of that, which one is being used, DB2 underlying tables?

Which command do we use to see the VSAM file in CICS?

Broadly how many parts of a VSAM data set can be classified?

KSDS Load process is carried with Sequential access instead of Direct access.

ESDS records can not be deleted. How can this be done by the programmer when logic wants to delete a record?

In ESDS, the first record RBA is '0'. The record length is '80' bytes. So what is RBA for 2nd record?

For the RRDS cluster, what is the keyword we define in the IDCAMS DEFINE command?

One difference between KSDS and (RRDS, ESDS, LDS). KSDS= Contains both RDF/CIDF RRDS,ESDS,LDS=All are data components

Is DITTO one of the tools used to work with VSAM files?

HFS- Hierarchical file system on Unix. ZFS-Z series file system on Unix Both are ESDS VSAM files. But ZFS files have metadata log. So when a disaster occurs, ZFS files are recoverable.

Can VSAM files be accessed by both Batch and CICS?