0

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

What segment processing occurs when you issue a DLET?

  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
  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
  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 are not mentioned in DBD

  1. Number of sensitive segments

  2. Dataset

  3. Segment name

  4. Field name


Correct Option: A

Which procopt is used to read from a segment

  1. G

  2. R

  3. I

  4. D

  5. P


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

Which of the following is invalid call.

  1. CALL 'CBLTDLI' USING DLI-ISRT

  2. CALL 'CBLTDLI' USING DLI-GHP

  3. CALL 'CBLTDLI' USING DLI-GU

  4. CALL 'CBLTDLI' USING DLI-GPH

  5. CALL 'CBLTDLI' USING DLI-REPL


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