HCL Oracle General Interview Questions Answers, HCL Placement Papers, HCL Technical, HR Interview Questions, HCL Aptitude Test Questions, HCL Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

HCL Oracle General Interview Questions

Questions Answers Views Company eMail

What is schema?

41 64500

find out the third highest salary?

92 154030

What are the composite date types in oracle?

6 18230

diff between DELETE and TRUNCATE?.

14 23136

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

2 12700

can we insert any row to dual table if i got the permission from DBA

5 17477

ABOUT IDENTITY?

2112

i deleted 4 records form the table.after i have applied commit .now i want to get back those records.how?

7 13171

How to Remove the 3rd highest salary person record from table?

9 19404

Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this

3 5585

2 5387

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 8879

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 5284

what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .

5 19727

Write query to fetch second maximum salary from employee table.

4 7645

Post New HCL Oracle General Interview Questions

HCL Oracle General Interview Questions

HCL Oracle General Interview Questions (19)

Un-Answered Questions

Name some important interfaces of Hibernate framework?

386

What does this line do? @Hostbinding(‘[class.valid]’) is valid?

863

Why javascript is called lightweight language?

951

What is mean by working capital?

1243

What are the Alerts & Subscriptions?

464

How is data send by ip layer?

1165

Which css framework is best?

803

In column, the table view is sap bw sid concept moving to erp?

600

why do u choose MBA after B.Sc.

4675

How do I remove win32 trojan virus?

877

Hello, My project requirement is like I need to create a web page using MVC pattern. I hava a bean class, jsp page, servlet, service and dao. My jsp has two fields. One is dropdown list. The option values has to get populated from the database table. The other one is a text box and its value has to come from database table. As of now I have defined the fields in bean class, got the values from database using arraylists in dao class and I called this from service class. Can anyone please tell me the workflow of how the servlet will get this arraylist and populate the arraylist values as dropdown options in jsp page? Also I would like to know the role of bean class in MVC pattern? Thanks in advance!

2456

What is the difference between Outsourced Testing and Crowdsourced Testing

897

How to reaname table name without using sp_Rename in sql server..?

1042

What is report server project?

155

Why hashmap is faster than hashset?

1068