0
Alien head

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

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

  1. True

  2. False


Correct Option: B

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

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

  1. IN

  2. OUT

  3. OUTIN

  4. INOUT


Correct Option: A

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

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

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

  1. NUMBER

  2. BOOLEAN

  3. CHARACTER

  4. STRING


Correct Option: B

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

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

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

How many types of triggers are there?

  1. 4

  2. 8

  3. 12

  4. 16


Correct Option: C

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

STEP1 EXEC PGM=P1 STEP2 EXEC PGM=P2,COND=EVEN STEP3 EXEC PGM=P3,COND=((8,LE,STEP1),ONLY) If the condition code of the step1 is 4 and the step2 was abended then which statement is correct.

  1. step1, step2 and step3 will execute

  2. only step1 and step3 will execute

  3. only step1 and step2 will execute

  4. only step1 will execute


Correct Option: A

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

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

What IBM utility is used to rename a dataset?

  1. IEBCOPY

  2. IEBGENER

  3. IEHPROGM

  4. IEBCOMPR


Correct Option: C

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 is the maximum number of DD stmt a step can have?

  1. 100

  2. 15

  3. 300

  4. 255


Correct Option: D

Which one of the following keyword a PROC cannot have?

  1. EXEC

  2. SYSABEND

  3. JOBLIB

  4. SYSPRINT


Correct Option: C

Which keyword allocates the largest available volume for the dataset?

  1. CONTIG

  2. MXIG

  3. ROUND

  4. RLSE


Correct Option: B

If DISP=(,CATLG) which is the correct one?

  1. DISP=NEW,CATLG,CATLG

  2. DISP=OLD,DELETE,CATLG

  3. DISP=NEW,CATLG,DELETE

  4. DISP=OLD,CATLG,CATLG


Correct Option: A
+ View questions