0

mainframe Online Quiz - 108

Description: mainframe Online Quiz - 108
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0
  1. ')' shifts columns left and '>' shift data left

  2. ')' shifts columns and '>' shift data

  3. ')' shifts columns and '>' shift data to the right

  4. both B and C


Correct Option: D
  1. :TS on command line and pressing enter by placing the cursor on desired split position of the line

  2. SPLIT on command prompt

  3. TS as line command and pressing enter by placing the cursor on desired split position of the line

  4. Break on Command prompt


Correct Option: A,C
  1. scrolls down 10,000 lines

  2. Scrolls 10,000 columns

  3. Invalid Scroll Amount

  4. We cannot issue such command


Correct Option: C

When a view is deleted, any dependent view is

  1. Marked Deleted

  2. Marked Inoperative

  3. Marked Invalid

  4. Marked Cascaded

  5. None of above


Correct Option: B

Given the Table STAFF ----------- ID LASTNAME 1 Malleswar 2 Kiran 3 Praveen 4 Yuva When issuing the query "SELECT * FROM STAFF" , the row return order will be based on which of the following?

  1. An ambiguous order

  2. The primary key order

  3. The order that the rows were inserted into the table

  4. The values for the ID column, then the LASTNAME column


Correct Option: A

Which of the following isolation levels is most likely to acquire a table level lock during an index scan?

  1. Read Stability

  2. Cursor Stability

  3. Repeatable Read

  4. Uncommitted Read


Correct Option: C

Which of the following tools can be used to catalog a database?

  1. Journal

  2. Alert Center

  3. License Center

  4. Client Configuration Assistant


Correct Option: D

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

  1. Net.Data

  2. Net Search

  3. DB2 AVI Extenders

  4. DB2 XML Extenders

  5. DB2 Text Extenders


Correct Option: C
  1. SELECT UNIQUE * FROM t1

  2. SELECT DISTINCT * FROM t1

  3. SELECT UNIQUE (*) FROM t1

  4. SELECT DISTINCT (*) FROM t1

  5. None of above


Correct Option: B
  1. Memory usage is reduced

  2. Query compilation time is reduced

  3. Data access time is increased

  4. Data access control is increased


Correct Option: D

We cannot restart the program that is loading a GSAM

  1. True

  2. False


Correct Option: B

RSA (Key feed back area) stands for

  1. Record Segment Argument

  2. Record Setting Argument

  3. Record Selection Argument

  4. Record Specifying Argument


Correct Option: A
- Hide questions