Can anyone give me information about oracle certification

1 Answers  

---

25. Display the client number and the value of the highest value order placed by that client.

2 Answers   Wipro,

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

what are stored procedures?

7 Answers   TCS, Wells Fargo,

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

how to find find & delete duplicate rows from two different tables?

3 Answers   Accenture, TCS,

---

Query to retrieve record for a many to many relationship ?

0 Answers   Keane India Ltd,

---

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

How to run create database statement again?

0 Answers  

---

How to add a new column to an existing table in oracle?

0 Answers  

---

Explain about achiever in sql?

0 Answers  

---