Answer Posted / roopesh kumar

(1) Inner or Equei join
(2) Outer or no - equei join
(a) left outer
(b) right outer
(c) full outer
(3) Cartision or cross join
(4) Self join
(5) Natural join

Can 2 queries be executed simultaneously in a distributed database system?

1142

---

Do ddl statements need commit?

973

---

How do I view stored procedures?

975

---

Does pl/sql support create command?

1110

---

What is the difference between truncate and drop statements?

1190

---

What are the various restrictions imposed on view in terms of dml?

965

---

How many types of cursors are available in pl/sql?

1109

---

Why use triggers in sql?

957

---

how to escape special characters in sql statements? : Sql dba

1035

---

what is the stuff function and how does it differ from the replace function? : Sql dba

1058

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7349

---

what are the drivers in mysql? : Sql dba

1021

---

When do we use triggers?

1080

---

Is sql a microsoft product?

953

---

Does a user_objects view have an entry for a trigger?

1012

---