Answer / palanivel

First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling

Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

ONGC, 25 OCT. 2009

8 Answers   ONGC,

---

The recruitment process of consagous had three rounds. 1. Group discussion 2. Written test 3. Technical interview/ HR The first round was GD. I got the topic “should India break up the friendly ties with Pakistan”. The group had 20 students. After the discussion each student was given a chance to express his/her views on the topic. The second round was written test. The paper was purely technical. It had a total of 50 questions. Out of which 5 questions were subjective. Those questions were: 1. What is RTTI? 2. What is containership? 3. Describe the lifecycle of asp.net page. 4. Why an empty structure occupy 2 bytes memory? 5. What is the difference btw compilation of C++ and C#? The objective questions had some programming questions. Other than that some questions that I remember are: • What is the complexity of binary search algo? • The factor that affects the complexity of an algorithm is a. The maximum amount of memory needed by the algorithm b. The minimum amount of memory needed by the algorithm c. The avg amount of memory needed by the algorithm d. The maximum amount of disc space needed by the algorithm • The class which is used to perform basic console I/O? Ans. System • Which is the first phase of s/w development lifecycle? Ans. Analysis This is all I remember….. The last round was interview. 46 students were selected for the interview. HR questions: • Describe yourself. • Did u held some leadership position in your college (because I mentioned that I was captain in school) • Then they read two aptitude questions(easy ones) and I had to answer them but the condition was that they were not going to repeat the question. • What is your short term and long term goals? • Why your marks decreased in college? • At last they asked about their company. Technical question: • What is the difference between C and C++. • What are access specifiers? • What is a static variable? • How can we define a variable globally? • What is a namespace and assembly? • What is an intermediate language? • Describe your project. • What is the difference between cookies and sessions? And many more……. Finally I got selected after this.

0 Answers   Consagous,

---

Hcl Placement Paper - May 2006 Chennai

2 Answers   HCL, Wipro,

---

Caritor placement papers ----------- placement paper 1

2 Answers   Caritor,

---

NOVELL PLACEMENT PAPERS -------- Placement Paper 2

1 Answers   Novell,

---

LG Written test paper 2006

1 Answers   LG Soft,

---

HUGHES PLACEMENT PAPER -------- Placement Paper

1 Answers   Hughes,

---

RAMCO PLACEMENT PAPERS ---- Placement Paper 4

1 Answers   Ramco,

---

What are the frequently asked questions for interview in capital iq company ?

0 Answers   Capital IQ,

---

Tata Elxsi Written Test With Interview Rounds

1 Answers   Infosys, Tata Elxsi, TCS, Wipro,

---

An array of size k contains integers between 1 and n. Compress the original array by removing duplicates in it in O(k) time What if k << n?

1 Answers   HCL, Microsoft, Veritas,

---

Broadcom placement papers

2 Answers   Broadcom,

---