Explain commit, rollback and savepoint.

0 Answers  

---

What is sql architecture?

0 Answers  

---

What is normalization? dec 2009

3 Answers   Cognizant,

---

What is sql keyword?

0 Answers  

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

---

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

Give an example of Full Outer Join?

1 Answers   IBM,

---

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

---

What are Lexical Parameters.How They are used in Reports 6i

2 Answers   eicc,

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---