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

AI Explanation

To understand the retrieval sequences in IMS DB, let's go through each option:

A. Top to Bottom - This option is correct because in IMS DB, the retrieval sequence starts from the top level segment and goes down to the child segments. This ensures that the data is retrieved in a hierarchical manner.

B. Front to Back - This option is incorrect because the retrieval sequence in IMS DB is not based on the front-to-back order of segments. It is based on the hierarchy of segments.

C. Right to Left - This option is incorrect because the retrieval sequence in IMS DB is not based on the right-to-left order of segments. It is based on the hierarchy of segments.

D. Left to Right - This option is correct because after traversing down the hierarchy from top to bottom, IMS DB retrieves the segments from left to right within each level. This ensures that the segments at the same level are retrieved in a consistent order.

Therefore, the correct answer is A, B, D. These options represent the retrieval sequences in IMS DB, where the data is retrieved from top to bottom, from front to back, and from left to right.

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
  1. path call

  2. set parentage

  3. path call ignore

  4. last occurrence


Correct Option: C

What is command code 'P'?

  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
  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 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