Tag: databases

Questions Related to databases

select version from dual ;
technology databases

  1. Error: "VERSION": invalid identifier

  2. Error: "VERSION": invalid character

  3. Error: invalid SQL statement

  4. shows oracle database version

  5. Null

Show answer
Correct Option: A

select expr(1/0) from dual; The o/p would be ..
technology databases

  1. 0

  2. Error: divisor is equal to zero

  3. Error: Invalid Identifier

  4. NULL

Show answer
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;

technology databases

  1. True

  2. False

Show answer
Correct Option: A

The o/p of the below query would be.. select nvl('abc','a') from dual union all select nvl('abc',0) from dual minus select replace('abc','a','a') from dual
technology databases

  1. No rows returned

  2. abc

  3. Two rows of value 'abc'

  4. Error: Syntax error

Show answer
Correct Option: A

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

  1. Error: Syntax error

  2. 0

  3. 5

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

Show answer
Correct Option: D

select instr('Hi Partha Sarathi Ojha','a',5) from dual; The o/p would be...
technology databases

  1. 5

  2. 9

  3. 22

  4. 0

Show answer
Correct Option: A

Want to search character 'a' from last in the string 'Hi Partha Sarathi Ojha'. So what would be the query...

technology databases

  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

Show answer
Correct Option: B

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

  1. efcda

  2. efcde

  3. ef

  4. ab

  5. 1

Show answer
Correct Option: B

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

technology databases

  1. efcda

  2. efcde

  3. ef

  4. ab

  5. 1

Show answer
Correct Option: A

The o/p of the below two queries will be same ? 1.select translate('abcd','a','d') from dual; 2.select replace('abcd','a','d') from dual;

technology databases

  1. True

  2. False

Show answer
Correct Option: A