0

mainframe Online Quiz - 16

Description: mainframe Online Quiz - 16
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0

A program can be cancelled by itself or subroutines called by it.

  1. True

  2. False


Correct Option: B
  1. Group containing alphabetic fields

  2. Group containing numeric fields

  3. Group containing alphabetic and numeric fields

  4. None of the above


Correct Option: C

Group moves are always considered alphanumeric moves regardless of the elementary items in it.

  1. True

  2. False


Correct Option: A

How many alternative indexes can be specified maximum for a base cluster?

  1. 256

  2. 253

  3. 255

  4. None of the above


Correct Option: B

Which keyword allows the same copy to be used more than once in the same code by changing the replace value?

  1. REDEFINES

  2. REPLACING

  3. REUSE

  4. REORG


Correct Option: B
  1. SET

  2. SEARCH

  3. PERFORM

  4. All the above


Correct Option: D
  1. Unique index and base clusters

  2. Primary index and base clusters

  3. Alternate index and base clusters

  4. Secondary index and base clusters


Correct Option: C
  1. Output files

  2. Input files

  3. Both the files

  4. All the above is correct


Correct Option: B
  1. Create Database

  2. Update Table

  3. Drop Views

  4. Reverse Table


Correct Option: A,B,C

With SQL, how can you return the number of records in the "Persons" table?

  1. SELECT COUNT(*) FROM Persons

  2. SELECT COLUMNS() FROM Persons

  3. SELECT COLUMNS(*) FROM Persons

  4. SELECT COUNT() FROM Persons


Correct Option: A

Which SQL statement is used to extract data from a database?

  1. SELECT

  2. OPEN

  3. GET

  4. EXTRACT


Correct Option: A
  1. SELECT FirstName FROM Persons

  2. SELECT Persons.FirstName

  3. EXTRACT FirstName FROM Persons

  4. EXTRACT Persons.FirstName


Correct Option: A
  1. SELECT DISTINCT

  2. SELECT DIFFERENT

  3. SELECT UNIQUE

  4. SELECT SAME


Correct Option: A
  1. LEFT JOIN

  2. RIGHT JOIN

  3. FULL JOIN

  4. SELF JOIN


Correct Option: A,B,C,D
  1. Alternate Key

  2. Foreign Key

  3. Unique Key

  4. Alias Key


Correct Option: B
  1. A REXX clause can be coded in uppercase, lowercase or mixed case.

  2. Multiple instructions can be coded on 1 line, as long as they are separated by a ','

  3. A REXX program should start with a comment clause /* REXX */

  4. Continuation of REXX instructions is achieved by using a ',' as a continuation indicator


Correct Option: B
- Hide questions