Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c

8 Answers   Oracle,

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What is a scalar value in sql?

0 Answers  

---

What is sql stand for?

0 Answers  

---

What does pl sql developer do?

0 Answers  

---

Give the structure of the function ?

2 Answers  

---

How to call DDL statements from pl/sql?

5 Answers  

---

What is asqueryable?

0 Answers  

---

What data types does pl/SQL have?

3 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---