Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

What are the different dml commands in sql?

0 Answers  

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

What is pivot query?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

What is the full form of sql?

1 Answers  

---

What is the limitation on the block size of pl/sql?

0 Answers  

---

How can you create an empty table from an existing table?

0 Answers  

---

What is the difference between an inner join and an outer join?

0 Answers  

---

What is a dynamic query?

0 Answers  

---

How many sql statements are used? Define them.

0 Answers  

---

What is a left inner join?

0 Answers  

---