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 group containing alphabetic fields can be redefined only by

  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

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

Index is only used by

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

UNION selects only distinct value by default.

  1. True

  2. False


Correct Option: A

What do we call the PRIMARY KEY of a reference table?

  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