Answer / guest

Describe Java and Database performance technique for UI and
database and mid-tier

Answer / kexcaliber

Build most of the services for the application in the backend so that this reduces the data transactions and computation is much faster also write service that are service specific i.e Data Encapsulation
Implement OOPS based concepts

What is before trigger?

0 Answers  

---

How can I delete duplicate rows?

0 Answers  

---

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

---

A table has 150 records. How do you retrieve 100th row to 120th row from that table ?

21 Answers   IBM,

---

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

---

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

How many joins can you have in sql?

0 Answers  

---

How do you define a foreign key?

0 Answers  

---

Is subquery faster than join?

0 Answers  

---

can i write pl/sql code in a package

2 Answers  

---

Difference between global and parameter variables?

0 Answers   TCS,

---