• databases Online Quiz - 6
Back
0

databases Online Quiz - 6

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

Which of the following is true about DBD ?
technology databases

  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

Show answer
Correct Option: D

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

technology databases

  1. multiple

  2. twin

  3. sibling

  4. none of these

Show answer
Correct Option: B

What information is not included in DBD

technology databases

  1. access method

  2. segment name

  3. parameter

  4. key field length

Show answer
Correct Option: C

IMS Db uses what kind of database management

technology databases

  1. network

  2. relational

  3. hierarchical

  4. object-oriented

Show answer
Correct Option: C

What is the advantage of IMS DB?

technology databases

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management

Show answer
Correct Option: A

Which of the following is true about DBD ?
technology databases

  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

Show answer
Correct Option: C

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

  1. multiple

  2. twin

  3. sibling

  4. none of these

Show answer
Correct Option: B

IMS Db uses what kind of database management

technology databases

  1. network

  2. relational

  3. hierarchical

  4. object-oriented

Show answer
Correct Option: C

What is the advantage of IMS DB?

technology databases

  1. Faster access

  2. easy implementation

  3. high flexibility

  4. simple management

Show answer
Correct Option: A

Which of the following is true about DBD ?
technology databases

  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

Show answer
Correct Option: D

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

  1. multiple

  2. twin

  3. sibling

  4. none of these

Show answer
Correct Option: B

What information is not included in DBD
technology databases

  1. access method

  2. segment name

  3. parameter

  4. key field length

Show answer
Correct Option: C

Proc opt for path call
technology databases

  1. C

  2. P

  3. D

  4. K

  5. L

Show answer
Correct Option: B

Which of the following are not mentioned in PSB

technology databases

  1. Number of sensitive segments

  2. dataset

  3. Segment name

  4. Key value

Show answer
Correct Option: B

SENSEG NAME=CUSTOMER,PARENT=0, PROCOPT=K Referring to the code above, what is the purpose of the SENSEG statements?
technology databases

  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

Show answer
Correct Option: D

You issue a GNP call from a program and receive a status code of GP. Referring to the above scenario, which one of the following describes the cause of this error?
technology databases

  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.

Show answer
Correct Option: C

The first statement in a COBOL IMS program
technology databases

  1. DLITCBL

  2. CBLTDLI

  3. GOBACK

  4. PCB mask

  5. DBD

Show answer
Correct Option: A

What is the difference in coding between inserting segments into an existing database and loading a database?
technology databases

  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

Show answer
Correct Option: E

CALL ‘CBLTDLI’ USING ‘GU ‘ LS-PCB-MASK, WS-IO-AREA SEGMENTA*P SEGMENTC Based on above code what will be retrieved
technology databases

  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

Show answer
Correct Option: B

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

technology databases

  1. LS

  2. A

  3. IS

  4. L

  5. II

Show answer
Correct Option: E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1088 Quizzes
13125 Questions
 physics
537 Quizzes
11445 Questions
 biology
1026 Quizzes
11462 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
432 Quizzes
8610 Questions
 maths
438 Quizzes
7860 Questions
 softskills
0 Quizzes
7131 Questions