Tag: databases

Questions Related to databases

A recursive relationship is a relationship between an entity and ________ .
technology databases

  1. itself

  2. a subtype entity

  3. an archetype entity

  4. an instance entity

Show answer
Correct Option: A

What is the command code use to update the path of the segment?

technology databases

  1. Q

  2. D

  3. N

  4. I

Show answer
Correct Option: B

What are the two types of recovery?

technology databases

  1. Horizontal and Vertical

  2. Forward and Backward

  3. Left and Right

  4. Front and Back

Show answer
Correct Option: B

__________ is the smallest information that a DLI can fetch .
technology databases

  1. Field

  2. Segment

  3. Branch

  4. Character

Show answer
Correct Option: B

What is the limitation on number of segment occurrences?
technology databases

  1. 255

  2. 1000

  3. 453

  4. No Limitation

Show answer
Correct Option: D

What does Procopt O in PSB stand for?

technology databases

  1. Sequential Initial Load

  2. Access only Key of segment

  3. Used with G to Indicate that Hold is not allowed

  4. None of the above

Show answer
Correct Option: C

What are the two types of SSA's?

technology databases

  1. Basic and Complex

  2. General and Specific

  3. Qualified and Unqualified

  4. None of these

Show answer
Correct Option: C

What is the retrieval sequence in IMS DB?
technology databases

  1. Top to Bottom, Front to back, Left to right

  2. Front to back, Left to right, Top to Bottom

  3. Left to right, Top to Bottom, Front to back

  4. Left to right, Front to back, Top to Bottom

Show answer
Correct Option: A

What Status code is returned when trying to insert a segment that already exists?
technology databases

  1. IX

  2. IQ

  3. II

  4. ID

Show answer
Correct Option: C

What is the status code for an invalid SSA?
technology databases

  1. AJ

  2. AI

  3. AC

  4. Ak

Show answer
Correct Option: A