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

Identify the CURSOR attribute that evaluates to FALSE if cursor returns at least 1 row?

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN


Correct Option: B
  1. SAP

  2. Peoplesoft

  3. Oracle 11g

  4. JD Edwards


Correct Option: C

From below list which are the open source CMSs.

  1. Drupal

  2. Joomla

  3. PHP

  4. Wordpress


Correct Option: A,B,D

which of the following is the default format for date display

  1. DD-MM-YYYY

  2. DD-Mon-RR

  3. DD-Mon-YY

  4. DD-MON-RR


Correct Option: D

what is the output: select mod(1600,300) from dual;

  1. 300

  2. 100

  3. 500

  4. 000


Correct Option: B

Which of the folowing is not a oracle function?

  1. round

  2. trunc

  3. maximum

  4. initcap


Correct Option: C

Which method returns the number of rows in a set.

  1. sum

  2. num_rows

  3. count

  4. total


Correct Option: C

OTHERS is super set of all predefined internal exceptions

  1. True

  2. False


Correct Option: A
- Hide questions