databases Online Quiz - 84
Description: databases Online Quiz - 84 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
How many rows records the following query will display.. select * from TEMP where rownum in (1,3,3,2) N.R. Temp table has 30 records
select '1'+'1' from dual ; The o/p would be..
The o/p of the below two queries would be same.. 1.select '1'+1 from dual; 2.select 1+1 from dual;
O/p of the below query ?? select 'a''a' from dual;
select "aa" from dual ?
select dummy from dual ?
select * from dual ?
select dummy from dual minus select * from dual what would be output ?
select expr(1/0) from dual; The o/p would be ..
Output of the below two queries will be same.. 1.select nvl('abc','a') from dual; 2.select nvl('abc',0) from dual;
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
select instr('Hi Partha Sarathi Ojha','a',6,-1) from dual; The output would be..
select instr('Hi Partha Sarathi Ojha','a',5) from dual; The o/p would be...
Want to search character 'a' from last in the string 'Hi Partha Sarathi Ojha'. So what would be the query...
select translate('abcda','ab','ef') from dual; The o/p would be...
select replace('abcda','ab','ef') from dual ; The o/p would be..
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;
The o/p of the below query.. select 1/0 from dual ;
The o/p of the below query.. select 0/1 from dual group by dummy;