IMS DB Online Quiz


Advertisements


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

Predefined pattern for accessing data in DL/I is first down the hierarchy, then left to right.

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

A - Packed decimal data type

B - Hexadecimal data type

C - Character data type

D - Half word binary data type

Answer : C

Explanation

TYPE = C specifies Character 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 stores the area for its own internal linkage related to an application program?

A - SEG-LEVEL

B - STATUS-CODE

C - PROC-OPTIONS

D - RESERVED-DLI

Answer : D

Explanation

Reserved DL/I is known as the reserved area of the IMS. It stores four bytes binary data. IMS uses this area for its own internal linkage related to an application program.

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 - What are the maximum number of fields in a database?

A - 1000

B - 555

C - 755

D - 899

Answer : A

Explanation

Maximum number of fields per database are 1000.

Q 8 - When we issue a GU or GN call, the DL/I establishes its parentage at the lowest level segment that is retrieved. If we include a P command code, then the DL/I establishes its parentage at a higher level segment in the hierarchical path. State whether true or false?

A - False

B - True

Answer : B

Explanation

This is self explanatory.

Q 9 - Logical twins are the occurrences of a logical child segment type that are all subordinate to a single occurrence of the logical parent segment type. 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