0

programming languages Online Quiz - 48

Description: programming languages Online Quiz - 48
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

If the Oracle Engine for its internal processing has opened a cursor they are known as _________

  1. Explicit Cursor

  2. Implicit Cursor

  3. Active Data Set

  4. None of the above


Correct Option: B
  1. a) A stored procedure on the server

  2. b) A block of code in a PL/SQL library.

  3. e) A local subprogram defined within the program unit ORDERTOTAL

  4. d) A block of code in the body of the program unit ORDERTOTAL


Correct Option: C

Implicit cursors are declared for

  1. Some DML,PL/SQL statements

  2. All DML,PL/SQL statements

  3. Only PL/SQL statements

  4. None of the Above


Correct Option: C
  1. Using NEW keyword

  2. Using CREATEOBJECT keyword

  3. Using GETOBJECT keyword

  4. Both A & B


Correct Option: A
  1. Casting of variables

  2. Boxing/Unboxing

  3. Structure & Class conversion

  4. Stack & Heap Conversion


Correct Option: B
  1. Using Redim Keyword

  2. Using Preserve Keyword

  3. Using Reserve Keyword

  4. None of the above


Correct Option: B
  1. Assembly’s Identity

  2. Assembly’s Reference List

  3. Both A & B

  4. None of the above


Correct Option: C

How do you preserve the contents of an array from being cleared when the array is redimensioned?

  1. Using Redim Keyword

  2. Using Preserve Keyword

  3. Using Reserve Keyword

  4. None of the above


Correct Option: B
- Hide questions