databases Online Quiz - 5

Description: databases Online Quiz - 5
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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

Correct Option: C

Which is not a IMS mode of processing

  1. DLI

  2. BMP

  3. CMP

  4. MPP

Correct Option: C
  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.

Correct Option: E

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?

  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.

Correct Option: A
  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

Correct Option: D

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

  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.

Correct Option: C

Which of the following is not passed as parameter to the IMS cobol program from JCL

  1. Program name

  2. PSB name

  3. IMS mode of processing

  4. DBD name

Correct Option: D

Which of the following are not mentioned in DBD

  1. Number of sensitive segments

  2. Dataset

  3. Segment name

  4. Field name

Correct Option: A
  1. Back to beginning of database

  2. Coding error

  3. No Command code used

  4. Concatenated command code

  5. Symantec error

Correct Option: C

WS area contains definition of all except

  1. SSA

  2. PCB

  3. Fuction code

  4. IO Area

Correct Option: B
  1. Heirarchical

  2. Network

  3. Relational

  4. Object oriented

Correct Option: A

Segment is the smallest info that DLI can fetch

  1. True

  2. False

Correct Option: B

Command code used to set parentage

  1. P

  2. C

  3. D

  4. U

  5. V

Correct Option: A





Correct Option: D
  1. The return code area

  2. The programming language

  3. The segment length

  4. The access type

  5. The DL/I function code

Correct Option: E
- Hide questions