2023 2024 EduVark > Education Discussion > General Discussion


  #1  
March 25th, 2017, 06:07 PM
Unregistered
Guest User
 
HCL Oracle Interview Questions

Hello sir, here I’m looking for some previous year question for interview of HCL Technologies Ltd related to oracle? Is there any one can give me HCL Oracle Interview Questions?
Similar Threads
Thread
HCL AIX Interview Questions
HCL ASP.NET Interview Questions
RSM MBA Interview Questions
Questions For MBA Interview
Interview Questions for IAS
MTS Interview Questions
HCL WPF Interview Questions
WCF Interview Questions HCL
HCL VB.Net Interview Questions
Interview questions in asp.net
LG Interview questions for MBA
Oracle SOA Interview Questions
NDA SSB Interview Questions
KVS PRT Interview Questions
NDA Interview Questions

  #2  
March 26th, 2017, 09:10 AM
Super Moderator
 
Join Date: Mar 2012
Re: HCL Oracle Interview Questions

The HCL is the right place for you because the HCL is focus on building a culture of innovation and breakthrough thinking, which results in value creation.

The work environment and corporate culture ensures your personal and professional development along with the overall growth of the organization.

Technical interview is a golden opportunity for you to exhibit your technical skills. The question would range across disciplines and may include puzzle, problems and other out-of-the-box idea related questions

Some important questions of HCL Oracle Interview:

What is meant by procedures? What is mean by functions?
What is the difference between procedures and functions?
What is meant by packages?
What is meant by triggers?
What is meant by exception and what are the types of exceptions?
What is meant by cursor and how many types of cursors are there?
What is the physical and logical structure of oracle How can u open multiple files in Unix is it possible.
How can u connect from Unix to database is there any login or password.
What is the version u are using.
When u create a table tablespace is created
what is tablespace
What is the syntax of procedures.
What is overloading.
I created a procedure with 5 parameters if the same procedure is called with 3 parameters will it work?
What is the error will it give?
How many types of cursors are there.
What are the attributes of cursors in explicit & implicit.
How does u open loop for cursors?
How can u select data into variables using select command If where condition is not specified what error it will give how do u handle that error , what is the exception pre_defined exception u use.
What is %rowtype how do u declare it in plsql block write it.
What is the structure of plsql block

HCL question asked in interview:

1. Write a SQL query to find out the most recently hired employee in each table?
2. Explain the two methods by which SQL can be retrieved?
3. Differentiate between a "where" clause and a "having" clause?
4. Write a SQL statement to read data out of a table?
5. Explain different types of joins?
6. What types of index data structures are used in SQL?
7. What is a functional dependency?
8. Can you give some examples of it?


1. What is the use of versioning?
2. What will happen if application configuration and server configuration have different session state values?
3. Write a program to convert string to integer without using in built library?
4. What are override methods? Explain it with one example?
5. Is it possible to override private virtual methods?
6. What is virtual base class?
7. What is the difference between ASP.NET and VB.NET?

1. What are you core subjects?
2. What are your hobbies?
3. Do you know about the bond?
4. Where do you stay?
5. How many siblings do you have?
6. Are you comfortable working anywhere?


Quick Reply
Your Username: Click here to log in

Message:
Options



All times are GMT +5. The time now is 06:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.6.0

1 2 3 4 5 6 7 8