#1
March 25th, 2017, 06:07 PM
| |||
| |||
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?
|
#2
March 26th, 2017, 09:10 AM
| |||
| |||
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? |
|