Tag: databases

Questions Related to databases

Running an IMS program in DBB is faster than running it in DLI.
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which of the following are true regarding SSA's and IMS database calls?
technology databases

  1. INIT call gets the database availability status

  2. It is not advisable to use GOBACK for ending an IMS COBOL program

  3. If the SSA contains only the segment name, byte 9 must contain a blank

  4. Basic checkpoint calls do not support GSAM files

Show answer
Correct Option: A,C,D

For GSAM databases, which status code will be issued if the input data set was not present and a get call was tried?
technology databases

  1. AI

  2. AM

  3. AO

  4. NI

Show answer
Correct Option: A

When CMPAT=YES is specified in a PSB, IMS provides PCBs to the application as if it were executing in a batch processing region
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following statements are true.
technology databases

  1. The name of the PSB and its associated application program must be the same in a telecommunications system

  2. The name of the PSB and its associated application program must not be the same in a telecommunications system

  3. The name of the PSB and its associated application program must be the same in an IMS Batch environment

  4. The name of the PSB and its associated application program need not be the same in an IMS Batch environment

Show answer
Correct Option: A,D

Which message is displayed for the normal completion of a DB2 utility command ?
technology databases

  1. DSN9025I

  2. DSN9024I

  3. DSN9023I

  4. DSN9022I

Show answer
Correct Option: D

TEMPLATE utility control statement is used for REPAIR UTILITY.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

which utility is used for preformatting the active log?
technology databases

  1. DSNJLOGF

  2. DSN1LOGP

  3. DSNJU003

  4. DSNJU004

Show answer
Correct Option: A

To prevent time outs or deadlocks when you use REORG with SHRLEVEL CHANGE option, run the REORG with the
technology databases

  1. DRAIN WRITERS

  2. DRAIN ALL

  3. DRAIN CLAIMERS

  4. DRAIN *

Show answer
Correct Option: B

What are the advantages of column-oriented architecture over traditional row-oriented architecture? (Choose 3)
technology databases

  1. Better data compression

  2. Less I/O

  3. Faster performance for decision support queries that involve only a few columns

  4. Best suited for OLTP

Show answer
Correct Option: A,B,C