• mainframe Online Quiz - 16
Back
0

mainframe Online Quiz - 16

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

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

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

A group containing alphabetic fields can be redefined only by

technology mainframe

  1. Group containing alphabetic fields

  2. Group containing numeric fields

  3. Group containing alphabetic and numeric fields

  4. None of the above

Show answer
Correct Option: C

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

technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

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

technology mainframe

  1. 256

  2. 253

  3. 255

  4. None of the above

Show answer
Correct Option: B

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

technology mainframe

  1. REDEFINES

  2. REPLACING

  3. REUSE

  4. REORG

Show answer
Correct Option: B

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

  1. DD NAME

  2. SYSIN Parameter

  3. PARAM

  4. RETURN CODE

Show answer
Correct Option: D

Index is only used by
technology mainframe

  1. SET

  2. SEARCH

  3. PERFORM

  4. All the above

Show answer
Correct Option: D

A path is a logical relation established between ______ and _______ in VSAM catalog

technology mainframe

  1. Unique index and base clusters

  2. Primary index and base clusters

  3. Alternate index and base clusters

  4. Secondary index and base clusters

Show answer
Correct Option: C

The keyword OPTIONAL in select clause is used only for

technology mainframe

  1. Output files

  2. Input files

  3. Both the files

  4. All the above is correct

Show answer
Correct Option: B

SQL can

technology mainframe

  1. Create Database

  2. Update Table

  3. Drop Views

  4. Reverse Table

Show answer
Correct Option: A,B,C

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

technology mainframe

  1. SELECT COUNT(*) FROM Persons

  2. SELECT COLUMNS() FROM Persons

  3. SELECT COLUMNS(*) FROM Persons

  4. SELECT COUNT() FROM Persons

Show answer
Correct Option: A

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

  1. SELECT

  2. OPEN

  3. GET

  4. EXTRACT

Show answer
Correct Option: A

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

technology mainframe

  1. SELECT FirstName FROM Persons

  2. SELECT Persons.FirstName

  3. EXTRACT FirstName FROM Persons

  4. EXTRACT Persons.FirstName

Show answer
Correct Option: A

Which SQL statement is used to return only different values?

technology mainframe

  1. SELECT DISTINCT

  2. SELECT DIFFERENT

  3. SELECT UNIQUE

  4. SELECT SAME

Show answer
Correct Option: A

AI Explanation

To answer this question, you need to understand the purpose of the DISTINCT keyword in SQL.

Option A) SELECT DISTINCT - This option is correct because the DISTINCT keyword is used in a SELECT statement to return only unique/distinct values from a column or set of columns. It eliminates duplicate rows from the result set.

Option B) SELECT DIFFERENT - This option is incorrect because there is no SQL keyword called "DIFFERENT". It is not a valid SQL statement.

Option C) SELECT UNIQUE - This option is incorrect because there is no SQL keyword called "UNIQUE" that is used to return only different values. The UNIQUE keyword is used to specify that a column or set of columns must contain unique values.

Option D) SELECT SAME - This option is incorrect because there is no SQL keyword called "SAME" that is used to return only different values. It is not a valid SQL statement.

The correct answer is Option A) SELECT DISTINCT. This option is correct because the DISTINCT keyword is used to return only unique/distinct values from a column or set of columns.

What are the different types of JOINS?

technology mainframe

  1. LEFT JOIN

  2. RIGHT JOIN

  3. FULL JOIN

  4. SELF JOIN

Show answer
Correct Option: A,B,C,D

UNION selects only distinct value by default.

technology mainframe

  1. True

  2. False

Show answer
Correct Option: A

CONSTRAINTS can be specified only on Creation of a table.

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

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

technology mainframe

  1. Alternate Key

  2. Foreign Key

  3. Unique Key

  4. Alias Key

Show answer
Correct Option: B

Which funtion is used to return the total of a numeric field?

technology mainframe

  1. COUNT()

  2. GROUP BY()

  3. SUM()

  4. MAX()

Show answer
Correct Option: C

Indicate what is not correct in a REXX program.

technology mainframe

  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

Show answer
Correct Option: B

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) A REXX clause can be coded in uppercase, lowercase, or mixed case. - This option is correct. In REXX, the case of the keywords does not matter, so it can be coded in uppercase, lowercase, or mixed case.

Option B) Multiple instructions can be coded on 1 line, as long as they are separated by a ',' - This option is incorrect. In REXX, multiple instructions are typically coded on separate lines, and not on the same line separated by a comma.

Option C) A REXX program should start with a comment clause /* REXX */ - This option is correct. It is good practice to start a REXX program with a comment clause to indicate that it is a REXX program.

Option D) Continuation of REXX instructions is achieved by using a ',' as a continuation indicator - This option is correct. In REXX, when an instruction is too long to fit on a single line, a comma (",") can be used as a continuation indicator to continue the instruction on the next line.

The correct answer is B. Multiple instructions cannot be coded on 1 line in REXX.

- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions