Tag: mainframe

Questions Related to mainframe

Which of the following table locks will prevent concurrent applications (except for the lock owner) from having any access to the table, except read access by applications using UR isolation level?
technology mainframe

  1. Z

  2. X

  3. S

  4. U

Show answer
Correct Option: B

Which of the following products can be used to store image data in a DB2 database?
technology mainframe

  1. Net.Data

  2. Net Search

  3. DB2 AVI Extenders

  4. DB2 XML Extenders

  5. DB2 Text Extenders

Show answer
Correct Option: C

Which of the following statements eliminates all but one of each set of duplicate rows in the final result table?

technology mainframe

  1. SELECT UNIQUE * FROM t1

  2. SELECT DISTINCT * FROM t1

  3. SELECT UNIQUE (*) FROM t1

  4. SELECT DISTINCT (*) FROM t1

  5. None of above

Show answer
Correct Option: B

Which of the following will occur when a view is created on a DB2 table?
technology mainframe

  1. Memory usage is reduced

  2. Query compilation time is reduced

  3. Data access time is increased

  4. Data access control is increased

Show answer
Correct Option: D

We cannot restart the program that is loading a GSAM
technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

RSA (Key feed back area) stands for
technology mainframe

  1. Record Segment Argument

  2. Record Setting Argument

  3. Record Selection Argument

  4. Record Specifying Argument

Show answer
Correct Option: A

GSAM stands for
technology mainframe

  1. Generated Sequential Access Method

  2. Generalized Sequential Access Method

  3. Generalized Servicing Access Method

  4. Generalized Sequential Authendication Method

Show answer
Correct Option: B

GSAM is a
technology mainframe

  1. unordered and non hierarchical data base

  2. sequential and hierarchical data base

  3. sequential and non hierarchical data base

  4. unordered and hierarchical data base

Show answer
Correct Option: C

Data base access in GSAM can be done by
technology mainframe

  1. Queries

  2. Function calls

  3. DL/I calls

  4. DL/1 calls

Show answer
Correct Option: C

The format of GSAM call is
technology mainframe

  1. CALL 'CBLTDLI' USING call-func, pcb-name, ioarea

  2. CALL 'CBLTDLI' USING call-func, Ioarea

  3. CALL 'CBLTDLI' USING pcb-name, Ioarea

  4. CALL 'CBLTDLI' USING call-func, pdb-name pcb-name, Ioarea

Show answer
Correct Option: A