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

Implicit cursors, process ... Choose all that apply

  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

Index of numeric for loop always increments by one

  1. True

  2. False


Correct Option: A

When dealing with Cursor For Loops, which steps are taken care of implicitly? Choose all that apply

  1. DECLARE

  2. OPEN

  3. FETCH

  4. CLOSE

  5. PROCESS


Correct Option: B,C,D

Identify the CURSOR attribute that returns the number of rows fetched so far by the cursor?

  1. %FOUND

  2. %NOTFOUND

  3. %ROWCOUNT

  4. %ISOPEN


Correct Option: C

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

Which from the following is not an ERP package?

  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
  1. DD-MM-YYYY

  2. DD-Mon-RR

  3. DD-Mon-YY

  4. DD-MON-RR


Correct Option: D

what will be the output of: select rpad('*$*',3,'*') from dual;

  1. $***

  2. $

  3. ***$



Correct Option: B

what is the output: select substr('Oracle Basics',-5,3) from dual

  1. 'asi'

  2. 'isa'

  3. 'le '

  4. 'acl'


Correct Option: A

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 operator is equivalent to concat function?

  1. &

  2. ||

  3. &&


Correct Option: C
- Hide questions