0

programming languages Online Quiz - 283

Description: programming languages Online Quiz - 283
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0
  1. DISP=NEW,CATLG,CATLG

  2. DISP=OLD,DELETE,CATLG

  3. DISP=NEW,CATLG,DELETE

  4. DISP=OLD,CATLG,CATLG


Correct Option: A

Which keyword allocates the largest available volume for the dataset?

  1. CONTIG

  2. MXIG

  3. ROUND

  4. RLSE


Correct Option: B

Which one of the following keyword a PROC cannot have?

  1. EXEC

  2. SYSABEND

  3. JOBLIB

  4. SYSPRINT


Correct Option: C

What is the maximum number of DD stmt a step can have?

  1. 100

  2. 15

  3. 300

  4. 255


Correct Option: D

Which is the correct statement which will check only for errors?

  1. TYPRUN=COMPILE

  2. TYPRUN=ERRFREE

  3. TYPRUN=HOLD

  4. TYPRUN=SCAN


Correct Option: D

What IBM utility is used to rename a dataset?

  1. IEBCOPY

  2. IEBGENER

  3. IEHPROGM

  4. IEBCOMPR


Correct Option: C

If DISP parameter is not coded in the DD statement that what is the default value?

  1. DISP=OLD,DELETE,KEEP

  2. DISP=OLD,KEEP,KEEP

  3. DISP=NEW,DELETE,DELETE

  4. DISP=SHR,KEEP,DELETE


Correct Option: C

Which one of the following is used to print the dump of the abended job in an unformatted way?

  1. SYSOUT

  2. SYSABEND

  3. SYSUDUMP

  4. SYSMDUMP


Correct Option: D

Which one of the following is used to pass input to the COBOL program?

  1. INPUT

  2. PARM

  3. SYSOUT

  4. COND


Correct Option: B

How many types of triggers are there?

  1. 4

  2. 8

  3. 12

  4. 16


Correct Option: C

What does the cursor attribute ‘%rowcount’ do?

  1. Check whether cursor has fetched any row

  2. Check whether cursor has not fetched any row.

  3. Check the number of rows returned by the cursor

  4. Both A and C


Correct Option: C

What are the types of cursors available in plsql?

  1. user defined

  2. implied

  3. implicit and explicit

  4. Implied and user defined


Correct Option: C

The structure of simple explicit cursor is

  1. open cursor; ---some statements close;

  2. open cursor; fetch into variables; ---some statements close cursor;

  3. open cursor; fetch into variables; ---some statements close;

  4. All of the above


Correct Option: B

The data type returned by a ‘%FOUND’ cursor attribute is

  1. NUMBER

  2. BOOLEAN

  3. CHARACTER

  4. STRING


Correct Option: B

In which property does a NUMBER datatype differs from a PLS_INTEGER datatype

  1. Padding

  2. Length

  3. Storage

  4. All of the above


Correct Option: C

A database storage is stored in the database as

  1. In compiled form

  2. As source code

  3. Both A and B

  4. None of the above


Correct Option: C

The default mode of parameters that can be passes to a procedure?

  1. IN

  2. OUT

  3. OUTIN

  4. INOUT


Correct Option: A

What are the modes of parameters that can be passes to a procedure?

  1. IN

  2. IN, OUT

  3. IN, OUT,INOUT

  4. IN, OUT, INOUT , OUTIN


Correct Option: C

True of False :A package specification can exist without a body

  1. True

  2. False


Correct Option: B
- Hide questions