0

databases Online Quiz - 180

Description: databases Online Quiz - 180
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

select col1 from table_a where col1 between 0 and 11 is same as :

  1. select col1 from table_a where col1 > 0 and col1 <11

  2. select col1 from table_a where col1 >= 0 and col1 <11

  3. select col1 from table_a where col1 >= 0 and col1 <= 11

  4. select col1 from table_a where col1 > 0 and col1 < =11


Correct Option: C

What are the retrieval sequences in IMS DB?

  1. Top to Bottom

  2. Front to Back

  3. Right to Left

  4. Left to Right


Correct Option: A,B,D

What is command code 'D'?

  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: B

What is command code 'C'?

  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: A
  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: C
  1. Concatenated key

  2. path call

  3. first occurrence

  4. last occurrence


Correct Option: D

What is command code 'N'?

  1. path call

  2. set parentage

  3. path call ignore

  4. last occurrence


Correct Option: C
  1. path call

  2. path call ignore

  3. set parentage

  4. Concatenated key


Correct Option: C

what are the control blocks in IMS ?

  1. DBD

  2. PSD

  3. PSB

  4. SSA


Correct Option: A,C

What are the different types of SSA's ?

  1. QUALIFIED SSA

  2. UNQUALIFIED SSA

  3. All the above

  4. None of the above


Correct Option: C

What are the control blocks of Message Format Service (MFS) ?

  1. Message Input Data

  2. Message Output Data

  3. Data Input Format

  4. Data Output Format


Correct Option: A,B,C,D

What are the parameters used in CBLTDLI call?

  1. Function code

  2. PCB mask

  3. Segment I/O Area

  4. SSA's


Correct Option: A,B,C,D

What are the the 3 essential fields required for a DL/I call ?

  1. Function Code

  2. PCB Mask

  3. SSA

  4. I/O Area


Correct Option: A,B,D

What is the limitation on the no. of levels in a DL/I database?

  1. 10

  2. 15

  3. 125

  4. 255


Correct Option: B

What is the physical nature of a database called?

  1. IO-PCD

  2. DBD

  3. IO-AREA

  4. SSA


Correct Option: B

What is the return code you get after a successful IMS call?

  1. Zeros

  2. Spaces

  3. Both

  4. None of these


Correct Option: B

Which is the DL/I function used in CICS-IMS program?

  1. PCB

  2. PSB

  3. ACB

  4. DBD


Correct Option: A

which is the first statement in COBOL-IMS programs?

  1. ENTRY 'CBLDLI' USING ....

  2. ENTRY 'DLICBL' USING ....

  3. ENTRY 'DLIPLI' USING ....

  4. ENTRY 'PLICBL' USING ....


Correct Option: B
  1. End of database

  2. Segment not found

  3. Parentage not set

  4. Successful IMS call


Correct Option: B
- Hide questions