HCL Campus Interview Questions
HCL campus interview questions
HCL Technologies
Hindustan Copper Limited
A collection fo student HCL Campus Interview Questions for year 2010 – 2011 -2012
Q. Tell me about yourself.
Q. Why do you want to leave your current job? (Why did you leave your last job?)
Q. What are your strengths?
Q. What are your weaknesses?
Q. What type of work environment do you like best?
Q. Why do you want this job?
Q. How do you handle pressure and stress?’
Q. Why do you want this job?
Q. Why should we hire you?
Q. What qualifies you for this job?
SQL RELATED QUESTIONS
HCL INTERVIEW QUESTIONS…ANSWER PLZ…
1.TO FIND THE 3rd HIGHEST SALARY FROM EMPLOYEES?
2.TO FIND THE Nth SMALLEST SALARY ?
3.HOW TO REMOVE DUPLICATE RECORDS FROM A TABLE?
4.HOW WILL YOU COPY THE STRUCTURE OF A TABLE WITHOUT COPYING THE DATA?
5.HOW TO FIND THE DEPENDENCY OF A TABLE ?
6.HOW TO FIND INDIRECT MANAGERS IN EMPLOYEES TABLE IN ORACLE ?
7.HOW TO COPY SQL TABLE?
8.DELETE DUPLICATE VALUE FROM A TABLE?
1.TO FIND THE 3rd HIGHEST SALARY FROM EMPLOYEES?
select sal from (select sal,rownum rk from (select distinct sal from emp order by sal desc))where rk=3
2.TO FIND THE Nth SMALLEST SALARY ?
select sal from (select sal,rownum rk from (select distinct sal from emp order by sal asc))where rk=&n
Put the value of n what u want…
3.HOW TO REMOVE DUPLICATE RECORDS FROM A TABLE?
suppose ename and salary are th columns based upon which records are duplicate in table…
delete from emp where rowid in (select rd from (select rowid rd,ename,salary, row_number() over (partition by ename,salary order by empno) rnk from emp) where rnk<>1)
4.HOW WILL YOU COPY THE STRUCTURE OF A TABLE WITHOUT COPYING THE DATA?
create table table_1 as select * from table_2 where 1=2
5.HOW TO FIND THE DEPENDENCY OF A TABLE ?
There is some view for ths..u cn check on google…
All New Updates
