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
  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

What is the key word which is used to pass value from COBOL code to JCL?

  1. DD NAME

  2. SYSIN Parameter

  3. PARAM

  4. RETURN CODE


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

The keyword OPTIONAL in select clause is used only for

  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

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

  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

What are the different types of JOINS?

  1. LEFT JOIN

  2. RIGHT JOIN

  3. FULL JOIN

  4. SELF JOIN


Correct Option: A,B,C,D

CONSTRAINTS can be specified only on Creation of a table.

  1. True

  2. False


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