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

Q 1 - How many different types of segment can be there in a DLI database?

A - 15

B - 255

C - 355

D - 155

Answer : B

Explanation

A DL/I database can have 255 different segment types and 15 levels of hierarchy

Answer : A

Explanation

DBD stands for Database Descriptor.

Q 3 - Which function is used to get the unique record from the IMS databse?

A - DLI-GU

B - DLI-GHU

C - DLI-GN

D - DLI-GHN

Answer : A

Explanation

'GU' code is used for the Get Unique function. It works similar to the random read statement in COBOL. It is used to fetch a particular segment occurrence based on the field values.

Q 4 - Which function is used to remove a segment from an IMS DL/I database?

A - DLI-GNP

B - DLI-ISRT

C - DLI-DLET

D - DLI-REPL

Answer : C

Explanation

'DLET' code is used for the Delete function. It is used to remove a segment from an IMS DL/I database.

Answer : A

Explanation

SSA stands for Segment Search Arguments.

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

A - C

B - D

C - F

D - L

Answer : C

Explanation

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

Q 7 - How many key fields are allowed in segment?

A - 1

B - 100

C - No Limit

D - 255

Answer : A

Explanation

There can be only one key field in a segment.

Q 8 - The data element contains the key value from the segment in the indexed database over which the index is built. State whether true or false?

A - False

B - True

Answer : B

Explanation

This statement is correct.

Q 9 - A logical relationship is a path between two segments which are related logically and not physically. State whether true or false?

A - False

B - True

Answer : B

Explanation

This statement is correct.

Answer : A

Explanation

DBMS stands for Database Management System.


ims_db_questions_answers.htm

Advertisements