Tag: programming languages

Questions Related to programming languages

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

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

  1. True

  2. False


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

How many types of triggers are there?

  1. 4

  2. 8

  3. 12

  4. 16


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
  1. user defined

  2. implied

  3. implicit and explicit

  4. Implied and user defined


Correct Option: C