Software Interview Questions
Questions Answers Views Company eMail

What is the difference between PC by order and PC by period?

HCL,

979

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

947

What is the STLC process in your company?

RealPage,

1 1724

today evening you need to release software to client.at that time you found a defect.How you convence him?

RealPage,

1201

What would be the possible test cases for following criteria You have a username filed which don't accept same name twice

839

write the test cases for facility module

1212

What is Lock table in SQL?

Wipro,

995

How to get maxsal , minsal, ename department wise in single query

1002

Why do we use Check Positive Pay ?

Doyensys,

1 2011

What is the Use of Grouping Rule in Receivables ? is it mandatory field ?

Doyensys,

1042

1. Which is an aggregate function? a. Union b. like c. max d. Rank

Fintellix,

1 2176

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

Fintellix,

2 7371

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

Fintellix,

1 2418

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

Fintellix,

1 1954

7. Where would you look for errors from the database design?

Fintellix,

1 2263


Un-Answered Questions { Software }

What is php and sql?

523


What is the difference between Clustered and Non-Clustered Index?

585


How do I fix an error in excel?

306


Why is Reading done in parallel and writing is not in HDFS?

24


What is xml and its features?

454






What is a generic method?

482


how will you add a new column to a list of values ( lov ) in oracle applications framework? Can this be done without customization?

681


How do I convert letters to word in excel?

291


How do you shrink a table to one page in word?

307


how will you backup dns server? : Windows server 2003

104


How can you test the security of a Web site,both manually and by using a tool?

1377


Explain about the commit method?

172


how the HTML data stored in web server?

1948


Explain how does arp response the request?

598


What does the RUN statement do?

843