Answer / tushar pramod patil

It depends on your stream of certification.
That is there are two ways in that you can complete oca that as 1)OCA under deveolper track And 2) OCA under DBA track
If you interested in developer track then i must want to tell there is no any certification in 10G for OCA , It is under 9i
Program in pl/sql is nothing bus OCA in developer track.
Now about oca under DBA track it available in9i and 10G also
in 10G for OCA u must complete sql exam and then workshop I.

Why use truncate instead of delete?

0 Answers  

---

How can you fetch common records from two tables?

0 Answers  

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

0 Answers  

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

---

Why sql query is slow?

0 Answers  

---

can i give user defined exception in a package

2 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

what is subquery? : Sql dba

0 Answers  

---

Explain what is sql*plus?

0 Answers  

---

What is a full join sql?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---