santosh


{ City } hyderabad
< Country > india
* Profession *
User No # 72563
Total Questions Posted # 0
Total Answers Posted # 38

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 235
Users Marked my Answers as Wrong # 168
Answers / { santosh }

Question { Four soft, 9054 }

what is the intractive job? what is the batch job ?
how to change the batch job to interactive job?


Answer

When you are signing on a system,the jobs you are dealing
with are called interactive jobs.the jobs which are
presubmitted are called batch job.TFRJOB

Is This Answer Correct ?    5 Yes 4 No

Question { TCS, 5868 }

My source table look like
ID Name Location Salary
0000001 ran tpty 1000
0000002 ram DELHI 2000
hju-hji raj hyd 1000

my target table should be
ID Name Location Salary
1 ran tpty 1000
2 ram DELHI 2000
hju-hji raj hyd 1000


Answer

in expression t/r use replace(id,'000000','')

Is This Answer Correct ?    5 Yes 4 No


Question { HP, 5270 }

write sql query to filter the null value data following
table?
name age
john 30
smith null
null 34
sharp 24
i want the output following are

name age
john 30
sharp 24


Answer

select * from table name where name is not null and
age is not null

Is This Answer Correct ?    17 Yes 2 No

Question { Wipro, 7792 }

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.


Answer

declare
cursor mycursor is
select dname,ename from emp ,dept where emp.deptno=dept.deptno and dept.deptno=30;
v_dname dept.dname%type;
v_ename emp.ename%type;
begin
open mycursor;
loop
exit when mycursor%notfound;
fetch mycursor into v_dname,v_ename;
exception
when no_data_found then
dbms_output.put_line(v_dname||' '||v_ename);
end loop;
close mycursor;
end;

Is This Answer Correct ?    2 Yes 6 No

Question { 5389 }

can we access the method of class without creating the
object of the class


Answer

yes. we can access the static methods of that class without
creating the object that class

Is This Answer Correct ?    27 Yes 1 No

Question { BARC, 6051 }

interviewr asked about sampling theorem and i said the
common def.(i.e ...sam freq must >=s max freq in the signal
for a sampled signal to recover without alising).he asked
that i have a sin signal of freq 1hz and i sampled at two
zero amplitude points can it be recoverable without
aliasing????


Answer

i suppose there will be no aliasing since sampling is done
at twice the source frequency but seems signal can not be
recovered because mapping done between the samples (using
any order) can go any amplitude.

Is This Answer Correct ?    1 Yes 7 No

Question { 4689 }

In scott connected transformer number of turns in the
primary winding of teaser transformer is % of number
of primary turns of main transformer

A 86.6 B 57.7
C 14.4 D 33.3


Answer

86.6

Is This Answer Correct ?    3 Yes 0 No

Question { 4671 }

If length is 20 m ,width is 20 m & thickness is 80 mm then how many brass it is?


Answer

11.29

Is This Answer Correct ?    5 Yes 1 No

Prev    1   2    [3]