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 38118

find out the third highest salary?

92 91540

What are the composite date types in oracle?

6 12356

diff between DELETE and TRUNCATE?.

14 12046

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

2 9087





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

5 12388

ABOUT IDENTITY?

831

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

7 7561

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

9 8955

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

2 2325

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

2 2421

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 4865

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 2625

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

5 5737

Write query to fetch second maximum salary from employee table.

4 3614

Post New HCL Oracle General Interview Questions



Un-Answered Questions

What is Binary operations?

350


Which is the best field foundation bus. ( FF ) Yokogawa, Honeywell or others ?

593


difference between Ac and Dc mcb ????

217


In General please do read newspapers.And be thorough with 10th history and Geography.Biology also

869


could anyone send me model question papers or outline of graduate trainee(chemical engg) post?

2058






I am student pursuing B.E/B.tech in Computers 8'th sem.What should i do for a better carrier.Plz suggest other than programming languages.Is the ERP a better one to do?plz help...

878


A ii kv 1200 A Breaker combination fixed in a cubicle. How many ampere Fuse is required? If fuse is not using, Why?

769


If one tertiary phase i.e. R,Y or B is earthed of a loaded type tertiary delta connected (Without load)of a power auto transformer, what is its advantage/disadvantage?

870


hey guys ... since i have just started my career i need to know whether testing has a good career or not .. ?

774


Can I know about SAP for Insurance.

1045


a cc. has balance Rs. 8,40,000 at the credit of profit and loss a/c this balance is used for redemption of debentures what will be the entry

797


How can we connect additional batteries to three phase ups? What are parameters we have to check when connecting?

762


code for quick sort?

894


What are the regulatory commitments in markets like USA, Canada, Europe, Brazil, South Africa and Japan

1192


what are the types of design? which type of method is used at what type of design & why?

1089






HCL Oracle General Interview Questions
  • C (112)
  • STL (1)
  • OOPS (28)
  • C++ General (21)
  • MFC (19)
  • ATL (2)
  • COM DCOM (2)
  • Win32API (3)
  • VC++ AllOther (2)
  • Delphi (2)
  • PHP (24)
  • Programming Languages AllOther (23)
  • ASP (8)
  • CGI Perl (2)
  • JavaScript (6)
  • VB Script (3)
  • JSP (7)
  • Tcl (5)
  • Scripts AllOther (2)
  • SNMP (4)
  • TCP IP (18)
  • Protocols AllOther (7)
  • Networking Administration (56)
  • Networking Security (6)
  • Networking AllOther (16)
  • Visual Basic (10)
  • C Sharp (39)
  • ASP.NET (42)
  • VB.NET (4)
  • ADO.NET (8)
  • IIS (4)
  • Crystal Reports (2)
  • BizTalk (1)
  • Dot Net Framework (4)
  • Dot Net Remoting (2)
  • Dot Net WindowsForms (2)
  • Dot Net General (2)
  • Dot Net AllOther (5)
  • Exchange Server (9)
  • Microsoft Related AllOther (7)
  • Oracle General (16)
  • Architecture (3)
  • Database Management (11)
  • Forms Reports (4)
  • Oracle AllOther (9)
  • SQL Server (63)
  • MySQL (4)
  • Sybase (2)
  • SQL PLSQL (24)
  • Databases AllOther (1)
  • SDK (2)
  • Windows Threads (3)
  • Windows General (7)
  • Windows AllOther (11)
  • Linux Commands (16)
  • Linux Socket Programming (1)
  • Linux System Calls (2)
  • Linux General (4)
  • Linux AllOther (2)
  • Unix Commands (13)
  • Unix IPC (4)
  • Unix AllOther (5)
  • Solaris Commands (5)
  • Solaris System Calls (1)
  • Solaris General (4)
  • Solaris AllOther (14)
  • Operating Systems General Concepts (16)
  • Operating Systems AllOther (2)
  • WinRunner (4)
  • Load Runner (6)
  • QTP (39)
  • Test Director (3)
  • Rational TestSuite (2)
  • Silk Test (1)
  • Selenium (15)
  • Automation Testing AllOther (4)
  • Manual Testing (156)
  • QA Concepts (10)
  • Mobile Testing (3)
  • Test Cases (13)
  • Test Documents Reporting (1)
  • Testing AllOther (12)
  • Tomcat (1)
  • Apache (2)
  • Servers AllOther (1)
  • COBOL (28)
  • JCL (11)
  • CICS (5)
  • DB2 (7)
  • ADABAS (1)
  • Assembler (6)
  • MVS (2)
  • VSAM (4)
  • IBM MainFrame AllOther (2)
  • RPG400 (13)
  • COBOL400 (1)
  • DB400 (3)
  • IBM AS400 AllOther (9)
  • Core Java (62)
  • Advanced Java (26)
  • Swing (1)
  • EJB (9)
  • Servlets (13)
  • Struts (14)
  • JDBC (8)
  • J2EE (5)
  • Weblogic (26)
  • Java J2EE AllOther (13)
  • Java Related AllOther (10)
  • CORBA (1)
  • MQSeries (1)
  • XML XSLT RSS (3)
  • Teradata (3)
  • Business Objects (18)
  • Cognos (67)
  • Informatica (47)
  • Actuate (1)
  • Ab Initio (7)
  • Data Stage (26)
  • SAS (9)
  • ETL (4)
  • Data Warehouse General (6)
  • HR Questions (18)
  • UML (1)
  • OOAD (1)
  • Requirements Management (1)
  • Project Planning (6)
  • Project Management (1)
  • CTC (1)
  • Theoritical (1)
  • Visual Studio IDE (2)
  • Telecom Routers Switches (1)
  • VoIP IP Telephony (1)
  • GSM (1)
  • BlueTooth (1)
  • Telecom General (3)
  • Telecom AllOther (1)
  • SAP Basis (28)
  • SAP ABAP (67)
  • SAPScript (4)
  • SAP SD (39)
  • SAP MM (10)
  • SAP PP (4)
  • SAP FI CO (46)
  • SAP HR (7)
  • SAP CRM (2)
  • SAP SRM (1)
  • SAP Business Warehouse (9)
  • SAP Security (6)
  • SAP Netweaver (2)
  • SAP ALE IDocs (4)
  • SAP B1 (3)
  • PeopleSoft HRMS (2)
  • PeopleSoft Tools (1)
  • ERP General (1)
  • Oracle Apps Technical (7)
  • Oracle Apps Financial (32)
  • 86 Family (3)
  • VLSI (1)
  • Client Server General (1)
  • AI Neural Networks (1)
  • Digital Certificates (1)
  • Ciphers (2)
  • WebMethods (3)
  • TIBCO (2)
  • JCAPS (1)
  • Software Integration & Release (5)
  • Program Management (3)
  • Image Processing AllOther (2)
  • Zoology (2)
  • Geo Physics (1)
  • Organic Chemistry (1)
  • General Science (5)
  • Sciences AllOther (1)
  • Civil Engineering (7)
  • Mechanical Engineering (17)
  • Electrical Engineering (90)
  • Electronics Communications (56)
  • Chemical Engineering (3)
  • Industrial Engineering (1)
  • Instrumentation (9)
  • Engineering AllOther (31)
  • Business Administration (1)
  • Marketing Sales (10)
  • Banking Finance (4)
  • Human Resources (9)
  • Industrial Management (1)
  • Infrastructure Management (1)
  • IT Management (1)
  • Non Technical (1)
  • Business Management AllOther (2)
  • Audit (2)
  • Taxation (10)
  • Accounting General (23)
  • Accounting AllOther (27)
  • Architecture Design AllOther (1)
  • Call Centre AllOther (204)
  • UPSC AllOther (1)
  • SSC History (1)
  • SSC General Studies (1)
  • SSC AllOther (3)
  • RRB (7)
  • CDS (1)
  • NDA (2)
  • POs (4)
  • BSRB Clerical (3)
  • Group I (2)
  • APPSC AllOther (5)
  • General Knowledge_Current Affairs (29)
  • Government AllOther (3)
  • Law AllOther (1)
  • Tourism Hotel AllOther (1)
  • Funny Interview Questions (3)
  • Everything Else AllOther (14)
  • English (19)
  • General Aptitude (52)
  • Puzzles (11)
  • Placement Papers (26)
  • CCNA (70)
  • CCDA (1)
  • Microsoft Certifications (6)
  • Sun Certifications (1)
  • CISA Certification (1)
  • Oracle Certifications (2)
  • ISTQB Certification (1)
  • Certifications AllOther (8)
  • H1B Visa (2)
  • USA Student Visa F1 Visa (1)
  • L1 Visa (9)
  • USA Business Visa B1 Visa (1)
  • USA Dependent Visa H4 Visa (3)
  • UK Visa (1)
  • Australia Visa (2)
  • Canada Visa (4)
  • C Code (49)
  • C++ Code (4)
  • J2SE Code (2)
  • ASP.NET Code (1)
  • VB.NET Code (1)
  • C Sharp Code (1)
  • ADO.NET Code (1)
  • PHP Code (1)
  • JavaScript Code (2)
  • WinRunner Code (1)
  • GATE (2)
  • OPENMAT (1)
  • ICET (3)
  • C C++ Errors (9)
  • Oracle Errors (5)
  • SQLServer Errors (1)
  • Scripts Errors (1)