0

databases Online Quiz - 84

Description: databases Online Quiz - 84
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. 2

  2. 1+1

  3. Error: invalid number

  4. Error: invalid Character

  5. Error: invalid identifier


Correct Option: A

O/p of the below query ?? select 'a''a' from dual;

  1. aa

  2. a a

  3. a'a

  4. Error: invalid identifier

  5. Error: invalid character


Correct Option: C
  1. Error: "aa":invalid identifier

  2. aa

  3. "aa"

  4. Error: invalid character


Correct Option: A

select dummy from dual ?

  1. NULL

  2. Error: invalid identifier

  3. X

  4. Error: invalid SQL Statemet

  5. A


Correct Option: C
  1. A

  2. X

  3. NULL

  4. Error: Invalid SQL statement

  5. Error: Invalid Identifier


Correct Option: B
  1. No rows returned

  2. Error: invalid SQL statement

  3. Error: invalid identifier

  4. Error: syntax error

  5. 1 row


Correct Option: A

select version from dual ;

  1. Error: "VERSION": invalid identifier

  2. Error: "VERSION": invalid character

  3. Error: invalid SQL statement

  4. shows oracle database version

  5. Null


Correct Option: A
  1. 0

  2. Error: divisor is equal to zero

  3. Error: Invalid Identifier

  4. NULL


Correct Option: C

Output of the below two queries will be same.. 1.select nvl('abc','a') from dual; 2.select nvl('abc',0) from dual;

  1. True

  2. False


Correct Option: A

select instr('Hi Partha Sarathi Ojha','a',6,-1) from dual; The output would be..

  1. Error: Syntax error

  2. 0

  3. 5

  4. Error: Argument '-1' is out of range


Correct Option: D
  1. select instr('Hi Partha Sarathi Ojha',last,'a') from dual

  2. select instr('Hi Partha Sarathi Ojha','a',-1) from dual

  3. select instr('Hi Partha Sarathi Ojha',left,'a') from dual

  4. select instr('Hi Partha Sarathi Ojha',-1,'a') from dual

  5. select instr('Hi Partha Sarathi Ojha','-a') from dual


Correct Option: B

select replace('abcda','ab','ef') from dual ; The o/p would be..

  1. efcda

  2. efcde

  3. ef

  4. ab

  5. 1


Correct Option: A

The o/p of the below query.. select 1/0 from dual ;

  1. Error: Syntax error

  2. INFINITY

  3. NULL

  4. 0

  5. Error: divisor is equal to zero


Correct Option: E
  1. 0

  2. 1

  3. NULL

  4. Error: divisor is equal to zero

  5. Error: Not a GROUP BY clause


Correct Option: A
- Hide questions