Answer Posted / anuadarsh

1)Inner Join
a)Equi join
b)Natural Join
c)Cross Join
2)Outer Join
a)Left join
b)Right join
c)Full join
3)Self Join

Why we use stored procedure instead of query?

538

---

What is difference between pls_integer and integer?

521

---

How can we debug in PL/SQL?

661

---

define sql update statement ? : Sql dba

577

---

What are the different dml commands in sql?

586

---

---

What is difference between ms sql and mysql?

476

---

What is faster join or subquery?

512

---

Does execute immediate commit?

700

---

Can cursors be part of a trigger body?

1121

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

617

---

What are all types of user defined functions?

532

---

what are dynamic queries in t-sql? : Transact sql

562

---

List the ways to get the count of records in a table?

512

---

Define select, insert, create, delete, update, drop keywords

600

---

what is text? : Sql dba

564

---