0

databases Online Quiz - 9

Description: databases Online Quiz - 9
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which ITERATIVE control construct in PL/SQL is also called as INFINITE LOOP?

  1. Cursor For Loop

  2. Numeric For Loop

  3. While Loop

  4. Simple Loop


Correct Option: D
  1. All INSERT statements

  2. All DELETE statements

  3. All UPDATE statements

  4. Single row SELECT statements

  5. Multiple row SELECT statements

  6. Zero row SELECT statements


Correct Option: A,B,C,D

Explicit cursors are used to process multiple row SELECT statements

  1. True

  2. False


Correct Option: A

Index of numeric for loop always increments by one

  1. True

  2. False


Correct Option: A
  1. SAP

  2. Peoplesoft

  3. Oracle 11g

  4. JD Edwards


Correct Option: C
  1. Drupal

  2. Joomla

  3. PHP

  4. Wordpress


Correct Option: A,B,D
  1. DD-MM-YYYY

  2. DD-Mon-RR

  3. DD-Mon-YY

  4. DD-MON-RR


Correct Option: D

Which operator is equivalent to concat function?

  1. &

  2. ||

  3. &&


Correct Option: C

OTHERS is super set of all predefined internal exceptions

  1. True

  2. False


Correct Option: A
- Hide questions