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

The following commands are used to split a line

  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
  1. Marked Deleted

  2. Marked Inoperative

  3. Marked Invalid

  4. Marked Cascaded

  5. None of above


Correct Option: B
  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
  1. Journal

  2. Alert Center

  3. License Center

  4. Client Configuration Assistant


Correct Option: D
  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

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

  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
  1. Record Segment Argument

  2. Record Setting Argument

  3. Record Selection Argument

  4. Record Specifying Argument


Correct Option: A
- Hide questions