IMS DB Online Quiz



Following quiz provides Multiple Choice Questions (MCQs) related to IMS DB Framework. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.

Questions and Answers

Answer : A

Explanation

DLI stands for Data Language Interface.

Q 2 - For FIELD macro statement in DBDGEN, what does TYPE=H parameter specifies?

A - Packed decimal data type

B - Hexadecimal data type

C - Character data type

D - Half word binary data type

Answer : D

Explanation

TYPE = H specifies Half word binary data type for the field which we have declared.

Q 3 - Which function is used to get a unique record for update purpose?

A - DLI-GU

B - DLI-GHU

C - DLI-GN

D - DLI-GHN

Answer : B

Explanation

'GHU' code is used for Get Hold Unique. Hold function specifies that we are going to update the segment after retrieval. The Get Hold Unique function corresponds to the Get Unique call.

Q 4 - Which function is used to restart a IMS Database?

A - DLI-CHKP

B - DLI-XRST

C - DLI-PCB

D - DLI-ISRT

Answer : B

Explanation

'XRST' code is used for the Restart function. It is used in the restart features of IMS.

Q 5 - In PCB which field is used to store the name of segment after each DLI call?

A - LENGTH-FB-KEY

B - NUMB-SENS-SEGS

C - KEY-FB-AREA

D - SEG-NAME

Answer : D

Explanation

SEG Name is known as segment name feedback area. It contains 8 bytes of character data. The name of the segment is stored in this field after each DL/I call.

Q 6 - What command code we used to code for Last Occurrence?

A - C

B - D

C - F

D - L

Answer : D

Explanation

To use command codes, specify an asterisk in the 9th position of the SSA and for Last Occurrence we code L at 10th position.

Q 7 - The function of transaction manager is to provide a communication platform between the database and the application programs. IMS acts as a transaction manager. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 8 - Application programs have their own PSB and it is common for application programs that have similar database processing requirements to share a PSB. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 9 - When an AND (* or &) operator is used with secondary indexes, it is known as a dependent AND operator. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Answer : A

Explanation

DBMS stands for Database Management System.

ims_db_questions_answers.htm
Advertisements