Tag: databases

Questions Related to databases

What status code is returned when a segment insert attempted duplicate insert?
technology databases

  1. LS

  2. A

  3. IS

  4. L

  5. II

Show answer
Correct Option: E

What of the following is not a sequential processing?

technology databases

  1. Using a series of GN calls followed by a GNP call

  2. Using unqualified SSA's with GNP

  3. Using qualified SSA's with GU

  4. Using qualified SSA's with GN

  5. Using no SSA's with GNP

Show answer
Correct Option: C

Which is not a IMS mode of processing
technology databases

  1. DLI

  2. BMP

  3. CMP

  4. MPP

Show answer
Correct Option: C

What segment processing occurs when you issue a DLET?
technology databases

  1. The original segment is deleted and a status code is returned, prompting the program for further deletes.

  2. The segment at the highest level in the hierarchy is deleted.

  3. The segment is deleted and a new SSA must be specified on the next call.

  4. A delete does not occur unless the correct segment has been called.

  5. The segment and all subordinate segments are deleted.

Show answer
Correct Option: E

What is the first required call before a replace?

technology databases

  1. REPL

  2. GHU

  3. ISRT

  4. G

  5. GN

Show answer
Correct Option: B

GHU SUPPLIER*D(SUPPLRNO=10) PARTSIZE*DN What does IMS do if you use the D and N command codes together as illustrated in the sample code above?

technology databases

  1. The segment is retrieved, but is not replaced.

  2. The N command code applies only to ISRT calls

  3. An error is raised.

  4. The command code N is ignored.

  5. The segment is retrieved and is replaced.

Show answer
Correct Option: A

What command code causes more than one segment to be brought into the I/O area with a single call?

technology databases

  1. C

  2. D

  3. I

  4. L

  5. O

Show answer
Correct Option: B

What rule must you meet in order to fully qualify the GU call?

technology databases

  1. The PCB status code must be included.

  2. SSBs must be freed before call.

  3. A get call must be issued first.

  4. SSAs must be included for segments.

  5. Segment name must be specified for SSA

Show answer
Correct Option: D

What must be completed before a GNP is issued with the database?

technology databases

  1. All data must be sorted.

  2. All children must be grouped.

  3. The parent must be established

  4. All parents must be grouped.

  5. Finite control must be released.

Show answer
Correct Option: C

Which one of the following is a DL/I CALL that retrieves a unique occurrence?

technology databases

  1. PCB

  2. GN

  3. GNP

  4. GHU

  5. GHNP

Show answer
Correct Option: D