Answer Posted / deeksha

4 types
1.equijoin
2.non-equijoin
3.self join
4.outer join

Explain how to use transactions efficiently : transact sql

986

---

Can we delete column in sql?

1103

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1040

---

What is multiple partition?

972

---

what are the t string functions available in tsql? : Transact sql

1009

---

What is a database trigger?

1072

---

How do I view a view in sql?

954

---

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1051

---

What will you get by the cursor attribute sql%found?

965

---

What can you do with pl sql?

1097

---

What is field delimiter?

1048

---

What is online transaction processing (oltp)?

1018

---

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2113

---

What is spool?

1058

---

How can you know that statistics should be updated?

1079

---