Ims-db - Ims-DC Quiz
This is the Quiz on IMS-DB and IMS-DC for mainframe professionals. Quiz by Mainframe-Srini Blogs http://srinimf.wordpress.com
Questions and Answers
- 1.
Can we Delete records in GSAM files?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
GSAM files, also known as General Sequential Access Method files, are read-only files in the IBM mainframe environment. These files cannot be modified or deleted directly. Therefore, the correct answer is False.Rate this question:
-
- 2.
Through IMS-DB we can process online transactions?
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because IMS-DB (Information Management System-Database) is a hierarchical database management system that is primarily used for batch processing, not for processing online transactions. Online transaction processing is typically done using relational database management systems (RDBMS) such as Oracle or MySQL. IMS-DB is designed for high-volume, batch processing of large amounts of data, making it more suitable for tasks such as generating reports or performing data analysis rather than processing online transactions.Rate this question:
-
- 3.
What is the option for Exclusive Batch in IMS-DB?
- A.
MPP
- B.
DLI
- C.
BMP
- D.
DLI and DBB
Correct Answer
D. DLI and DBBExplanation
The option for Exclusive Batch in IMS-DB is DLI and DBB. DLI stands for Data Language Interface, which is used to access and manipulate IMS-DB data using high-level languages like COBOL and PL/I. DBB stands for Database Batch Backout, which is a utility used to recover from a failed batch job that has updated IMS databases. Together, DLI and DBB provide the exclusive batch processing capability in IMS-DB.Rate this question:
-
- 4.
What are the functions of IMS database manager?
- A.
Create hierarchial Model
- B.
Inform IMSDM about your data Model
- C.
Provides access to User
- D.
DBA looks after all the above
- E.
All of the above
Correct Answer
E. All of the aboveExplanation
The correct answer is "All of the above". The IMS database manager performs multiple functions, including creating a hierarchical model, informing IMSDM about the data model, and providing access to users. Additionally, the DBA (Database Administrator) is responsible for overseeing all of these functions. Therefore, all of the listed options are valid functions of the IMS database manager.Rate this question:
-
- 5.
What are the four elements in DLI call?
- A.
Function,PCB,SSA,DBD
- B.
Function,PCB,SSA,IO Area
- C.
Function,PCB,SSA,PSB
- D.
PSB,PCB,SSA,DBD
Correct Answer
B. Function,PCB,SSA,IO AreaExplanation
The four elements in DLI call are Function, PCB, SSA, and IO Area. These elements are essential components in a DLI (Data Language Interface) call, which is used to access and manipulate data in a database. The Function element determines the type of operation to be performed, the PCB (Program Control Block) contains information about the program and its execution, the SSA (System Services Area) contains the data to be accessed or modified, and the IO Area is used for input and output operations.Rate this question:
-
- 6.
What is record access sequence in IMS DB? Top to Bottom and Left to Right
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The record access sequence in IMS DB is indeed from top to bottom and left to right. This means that when accessing records in the database, IMS starts from the topmost record and moves downwards, and within each level, it moves from left to right. This sequence ensures that records are accessed in a systematic and organized manner, following a specific order.Rate this question:
-
- 7.
We can do in HSAM databases ?
- A.
Replace
- B.
Delete, Replace
- C.
Insert
- D.
Insert,Delete
Correct Answer
C. InsertExplanation
In HSAM (Highly Scalable Analytical Processing) databases, we can perform various operations including insert, delete, and replace. However, the given options suggest the possible combinations of these operations. The correct answer "Insert" implies that we can perform the insert operation in HSAM databases.Rate this question:
-
- 8.
How many datasets are created in HISAM?
- A.
1
- B.
4
- C.
2
- D.
3
Correct Answer
C. 2Explanation
The correct answer is 2 because the question is asking about the number of datasets created in HISAM. The options provided are numerical values, and out of those options, 2 is the only value that represents the number of datasets.Rate this question:
-
- 9.
What is Logical Record?
- A.
Database Record
- B.
Part of the Database Record
- C.
HSAM
- D.
None
Correct Answer
B. Part of the Database RecordExplanation
A logical record refers to a portion or segment of a database record. It represents a specific set of data that is logically related and grouped together within a larger database record. This allows for efficient organization and retrieval of information within a database system. Unlike a physical record, which refers to the actual storage of data on a disk or other storage medium, a logical record is a conceptual representation of data that is structured and organized in a meaningful way. Therefore, the correct answer is "Part of the Database Record".Rate this question:
-
- 10.
DBRC is set to on when?
- A.
Batch production jobs
- B.
Testing jobs
- C.
Online
- D.
Both online and batch production
Correct Answer
D. Both online and batch productionExplanation
DBRC (Database Recovery Control) is set to "on" in both online and batch production environments. In online environments, DBRC is used to manage and control database recovery processes during online transactions. In batch production environments, DBRC is also utilized to ensure the integrity and recoverability of the database during batch processing jobs. Therefore, the correct answer is that DBRC is set to "on" in both online and batch production scenarios.Rate this question:
-
- 11.
What is Lock controller in IMSDB?
- A.
IRLM
- B.
DLI
- C.
DBRC
- D.
None
Correct Answer
A. IRLMExplanation
The Lock controller in IMSDB refers to IRLM (Information Resource Lock Manager). IRLM is responsible for managing and controlling the locking and unlocking of resources in the database. It ensures that concurrent transactions do not interfere with each other and maintains data integrity by enforcing proper locking protocols. IRLM plays a crucial role in coordinating and facilitating access to shared resources in IMSDB.Rate this question:
-
- 12.
DBRC is stored in separate Address space. This will be invoked by IMS start procedure. What is the duty of DBRC?
- A.
Database changes stored in a Log
- B.
Database changes deleted from in a Log
- C.
Database changes stored in a Log for Batch and Online
- D.
None
Correct Answer
C. Database changes stored in a Log for Batch and OnlineExplanation
DBRC stands for Database Recovery Control. Its duty is to store database changes in a log for both batch and online operations. This log serves as a record of all modifications made to the database, allowing for recovery in the event of a failure or error. By storing the changes in a log, DBRC ensures that data integrity is maintained and provides a means to roll back or forward changes if necessary.Rate this question:
-
- 13.
ACB will be dynamically created in?
- A.
DLI batch
- B.
Online
- C.
Both DLI batch and Online
- D.
None
Correct Answer
A. DLI batchExplanation
ACB will be dynamically created in the DLI batch. This means that the creation of ACB will happen during the DLI batch, which could be a specific training program or course. It is not created online or in any other format, and it is not created in both DLI batch and online simultaneously.Rate this question:
-
- 14.
EXEC PGM=DFSCRC00 Parm=(DLI, , ,) What is the parameter in first space above?
- A.
PSB
- B.
Program name
- C.
PCB
- D.
None
Correct Answer
B. Program nameExplanation
The parameter in the first space above is the program name. This is indicated by the "PGM=" statement at the beginning of the line, followed by the program name "DFSCRC00".Rate this question:
-
- 15.
How to Trigger a transaction in IMS-DC?
- A.
/FOR EMPO
- B.
/EMPO
- C.
FOR EMPO
- D.
None
Correct Answer
A. /FOR EMPOExplanation
The correct answer is "/FOR EMPO". This is the correct syntax to trigger a transaction in IMS-DC. The "/FOR" statement is used to specify the transaction code, and "EMPO" is the transaction code in this case. By using this statement, the transaction with the code "EMPO" will be triggered in IMS-DC.Rate this question:
-
- 16.
How many types of BMPs avaialable?
- A.
2 - Batch BMP and MPP
- B.
1 - Batch BMP
- C.
1 - MPP
- D.
None
Correct Answer
A. 2 - Batch BMP and MPPExplanation
The correct answer is 2 - Batch BMP and MPP. This means that there are two types of BMPs available, which are Batch BMP and MPP.Rate this question:
-
- 17.
The imporatant Libraries in IMS test jcl are STEPLIB DD IMS.RESLIB ==> Contains IMS modules PROCLIB DD IMS.Proclib ==> Contains all cataloged procedures SYSDUMP DD ==> dump dataset DFSCTL DD ==> Contains Contains SETO/ SETR statement DFSSTAT DD ==> Dataset describing DB call IMS DD ==> IMS.PSBLib and IMS.DBD Lib
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The given answer is true because the libraries mentioned in the IMS test JCL are indeed important for the functioning of IMS. The STEPLIB DD statement specifies the library that contains IMS modules, the PROCLIB DD statement specifies the library that contains all cataloged procedures, the SYSDUMP DD statement is used for dump datasets, the DFSCTL DD statement contains SETO/SETR statements, the DFSSTAT DD statement describes DB calls, and the IMS DD statement specifies the IMS.PSBLib and IMS.DBDLib libraries. Therefore, all of these libraries are necessary for the successful execution of the IMS test JCL.Rate this question:
-
- 18.
What are the functions in DLI call specified?
- A.
Create, Replace, Update, Delete
- B.
Create, Replace
- C.
Create, Delete
- D.
Create, Replace, Update
Correct Answer
A. Create, Replace, Update, DeleteExplanation
The functions in DLI call specified are Create, Replace, Update, and Delete. These functions allow for various operations to be performed on the data stored in DLI. "Create" is used to create new data, "Replace" is used to update existing data or replace it with new data, "Update" is used to modify existing data, and "Delete" is used to remove data from the DLI database. These functions provide flexibility and control over managing and manipulating data in DLI.Rate this question:
-
- 19.
IMS-DC Uses four control blocks? DIF, MID, DOF, MOD
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
IMS-DC (Information Management System - Data Communications) uses four control blocks: DIF (Data Interchange Format), MID (Message ID), DOF (Data Output Format), and MOD (Message Origin Descriptor). These control blocks are used for various purposes in IMS-DC, such as formatting and transmitting data, identifying and tracking messages, and providing information about the origin of messages. Therefore, the statement "IMS-DC uses four control blocks" is true.Rate this question:
-
- 20.
How many bytes Status code will take?
- A.
1
- B.
3
- C.
2
- D.
4
Correct Answer
C. 2Explanation
The correct answer is 2 because a status code typically consists of a 2-byte value. This value is used to indicate the outcome of a request made to a server, such as whether the request was successful or encountered an error.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Feb 11, 2012Quiz Created by
Srinimf
Back to top