Can delete statement be rollbacked?

0 Answers  

---

Differentiate between % rowtype and type record.

0 Answers  

---

Can we use update in sql function?

0 Answers  

---

How does a covering index work?

0 Answers  

---

What is substitution variable?

0 Answers  

---

What is the difference between DELETE and TRUNCATE?

15 Answers   Johns Hopkins University, Tech Mahindra,

---

hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification

1 Answers  

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

0 Answers   Virtusa,

---

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,

---

Can a primary key be a foreign key?

0 Answers  

---