Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

select version from dual ;

Error: "VERSION": invalid identifier
Error: "VERSION": invalid character
Error: invalid SQL statement
shows oracle database version
Null

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

0
Error: divisor is equal to zero
Error: Invalid Identifier
NULL

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

No rows returned
abc
Two rows of value 'abc'
Error: Syntax error

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Error: Syntax error
0
5
Error: Argument '-1' is out of range

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

select instr('Hi Partha Sarathi Ojha',last,'a') from dual
select instr('Hi Partha Sarathi Ojha','a',-1) from dual
select instr('Hi Partha Sarathi Ojha',left,'a') from dual
select instr('Hi Partha Sarathi Ojha',-1,'a') from dual
select instr('Hi Partha Sarathi Ojha','-a') from dual

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

efcda
efcde
ef
ab
1

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

efcda
efcde
ef
ab
1

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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;

True
False

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases