What is referential integrity ?

3 Answers   BirlaSoft,

---

What is rank function in sql?

0 Answers  

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---

What is difference between inner join and cross join?

0 Answers  

---

Explain the uses of a database trigger?

0 Answers  

---

Can we create table inside stored procedure?

0 Answers  

---

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

---

List out the acid properties and explain?

0 Answers  

---

What are the most important ddl statements in sql?

0 Answers  

---

Does truncate table reset auto increment?

0 Answers  

---

What does over partition by mean in sql?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---