0

mainframe Online Quiz - 52

Description: mainframe Online Quiz - 52
Number of Questions: 20
Created by:
Tags: mainframe
Attempted 0/20 Correct 0 Score 0
  1. ... can be used for input, to use both DD entries describing sequential datasets and DD

  2. ... can be used to write multiple output datasets.

  3. ... can contain a dummy data set in the input, which will indicate the end of the input.

  4. ... stored on different device types, can not be used for input.


Correct Option: A,C
  1. We can override parameters on EXEC statements and add DD statements.

  2. We can override, nullify and add parameters on all statements and add DD and/or OUTPUT

  3. We can add and override parameters to all statements, but can only nullify parameters

  4. We can nullify, override and add parameters to all statements, but can only add DD statements.


Correct Option: B

Which of the following inequality comparison operators can be used in predicates.

  1. less than (

  2. greater than (>)

  3. less than or equal to (<=)

  4. Any of the above.


Correct Option: D
  1. Removes duplicate rows from your result.

  2. Selects all the rows.

  3. Puts the rows in descending order.

  4. None of the above


Correct Option: A

Can UNION be used along with outer join.

  1. True

  2. False


Correct Option: A

The DB2 object Alias which represents a table.

  1. Can represent remote tables and views.

  2. Can us used by anyone.

  3. Does not need DB2 authority to use.

  4. All the above.


Correct Option: D

What privelege do you need to create alias ?

  1. SYSADM authority.

  2. CREATEALIAS authority.

  3. Either a or b

  4. Both a & b


Correct Option: D

A view can be used to :

  1. Control access to table.

  2. Make data easier to use.

  3. Only b

  4. Both a and b


Correct Option: D

DB2 data can be modifed using :

  1. INSERT

  2. UPDATE

  3. DELETE

  4. All the above.


Correct Option: D

Subquery can be included in :

  1. WHERE clause

  2. HAVING clause

  3. Either of the above

  4. None of the above


Correct Option: C

The source form of static SQL statements is :

  1. Embedded within application program.

  2. Prepared during the execution of SQL application.

  3. Is the result of a DB2 query.

  4. None of the above


Correct Option: A

Application plan contains :

  1. A list of package names

  2. The bound form of SQl statements taken from one or more DBRMs.

  3. Neither of the above

  4. Both of the above


Correct Option: A

The data retrieved from SQL is called as :

  1. View

  2. Synonym

  3. Result table

  4. Alias


Correct Option: C

Which INFO-Variable is used to store the first six characters of the program name in demand ?

  1. INFO-PROGRAM-ID

  2. INFO-FUNCTION-KEY

  3. INFO-CONVERSATION

  4. INFO-PASSOFF


Correct Option: A

Which INFO-Variable is used to set the function key number if a function key is received ?

  1. INFO-PROGRAM-ID

  2. INFO-CONVERSATION

  3. INFO-PREVIOUS-PROGRAM-ID

  4. INFO-FUNCTION-KEY


Correct Option: D

Which INFO-Variable is used to set to Y if using PASSOFF ?

  1. INFO-PROGRAM-ID

  2. INFO-PREVIOUS-PROGRAM-ID

  3. INFO-CONVERSATION

  4. INFO-PASSOFF


Correct Option: D
- Hide questions