• databases Online Quiz - 5
Back
0

databases Online Quiz - 5

Description: databases Online Quiz - 5
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

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

technology databases

  1. Program name

  2. PSB name

  3. IMS mode of processing

  4. DBD name

Show answer
Correct Option: D

Which of the following are not mentioned in DBD

technology databases

  1. Number of sensitive segments

  2. Dataset

  3. Segment name

  4. Field name

Show answer
Correct Option: A

Which procopt is used to read from a segment

technology databases

  1. G

  2. R

  3. I

  4. D

  5. P

Show answer
Correct Option: A 
01 UNQUALIFIED-SSA.    
   05 UNIQUE-SSA-SEGMENT-NAME    PIC(8).    
   05 FILLER1                    PIC X VALUE '*-'.

What does "–" in filler1 specify?

technology databases

  1. Back to beginning of database

  2. Coding error

  3. No Command code used

  4. Concatenated command code

  5. Symantec error

Show answer
Correct Option: C

WS area contains definition of all except

technology databases

  1. SSA

  2. PCB

  3. Fuction code

  4. IO Area

Show answer
Correct Option: B

IMS uses what kind of database management

technology databases

  1. Heirarchical

  2. Network

  3. Relational

  4. Object oriented

Show answer
Correct Option: A

Segment is the smallest info that DLI can fetch

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Command code for path call

technology databases

  1. C

  2. P

  3. D

  4. K

  5. V

Show answer
Correct Option: C

Command code used to set parentage

technology databases

  1. P

  2. C

  3. D

  4. U

  5. V

Show answer
Correct Option: A

AI Explanation

To answer this question, you need to understand the command code used to set parentage. Let's go through each option to understand why it is correct or incorrect:

Option A) P - This option is correct because the command code "P" is commonly used to set parentage. It is used to establish a parent-child relationship between two entities or objects.

Option B) C - This option is incorrect because the command code "C" is not typically used to set parentage.

Option C) D - This option is incorrect because the command code "D" is not typically used to set parentage.

Option D) U - This option is incorrect because the command code "U" is not typically used to set parentage.

Option E) V - This option is incorrect because the command code "V" is not typically used to set parentage.

The correct answer is Option A) P. This option is correct because the command code "P" is commonly used to set parentage between entities or objects.

Which of the following is invalid call.

technology databases

  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

Show answer
Correct Option: D

CALL 'CBLTDLI' USING ?? i-o area pcb mask SSA Referring to the code above, what is the first parameter coded on the DL/I CALL?

technology databases

  1. The return code area

  2. The programming language

  3. The segment length

  4. The access type

  5. The DL/I function code

Show answer
Correct Option: E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions