0

databases Online Quiz - 6

Description: databases Online Quiz - 6
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN


Correct Option: D

A segment has 3 occurrences for a parent. This segment is called a

  1. multiple

  2. twin

  3. sibling

  4. none of these


Correct Option: B

What information is not included in DBD

  1. access method

  2. segment name

  3. parameter

  4. key field length


Correct Option: C

IMS Db uses what kind of database management

  1. network

  2. relational

  3. hierarchical

  4. object-oriented


Correct Option: C

What is the advantage of IMS DB?

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management


Correct Option: A
  1. multiple DBD s for each database

  2. cannot be used by DL/I

  3. created by a process called DBDGEN

  4. none of these


Correct Option: C

IMS Db uses what kind of database management

  1. network

  2. relational

  3. hierarchical

  4. object-oriented


Correct Option: C

What is the advantage of IMS DB?

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management


Correct Option: A
  1. multiple DBD s for each database

  2. none of these

  3. cannot be used by DL/I

  4. created by a process called DBDGEN


Correct Option: D
  1. access method

  2. segment name

  3. parameter

  4. key field length


Correct Option: C

Which of the following are not mentioned in PSB

  1. Number of sensitive segments

  2. dataset

  3. Segment name

  4. Key value


Correct Option: B
  1. To provide the database name

  2. To name the fields in the DBD

  3. To tell the program the data field segment sense sizes during any process stage

  4. To identify the segments in the database to which the application program is sensitive


Correct Option: D
  1. The segment level specified is not lower than the level of the established parent.

  2. There are no more segments for this message.

  3. The program has issued a call where no parent segment exists.

  4. An invalid length has been detected on a variable length record.


Correct Option: C
  1. DLITCBL

  2. CBLTDLI

  3. GOBACK

  4. PCB mask

  5. DBD


Correct Option: A
  1. The SSA must be qualified

  2. There is no difference.

  3. The key sequence of the data in loading

  4. There is no need for parentage in loading.

  5. The PCB processing options


Correct Option: E
  1. Will retrieve segment C and parentage will be set at segment C

  2. Will retrieve segment C and parentage will be set at segment A

  3. Will retrieve segment A and parentage will be set at segment A

  4. Will retrieve segment A and parentage will be set at segment C

  5. Error out


Correct Option: B

What status code is returned when a segment insert attempted duplicate insert?

  1. LS

  2. A

  3. IS

  4. L

  5. II


Correct Option: E
- Hide questions