Answer / partha

There are two types of join inner join and outer join.

(1)Inner join will return all the common records in both the
table
Ex: Select e.ename from Employee e,Dept d where e.did=d.did;

(2)Outer join is of 3 types Left Outer,Right Outer and full
outer.
Left outer retrieves common records from both the table and
all the record from the left table.
Similarly Right Outer all the records from right table and
Full outer from both the tables

Answer / n

Inner and outer joins

What is rank in database?

0 Answers  

---

Define scalar functions.

0 Answers  

---

Explain the concepts of a primary key and foreign key.

0 Answers  

---

RDBMS file system can be defined as

0 Answers   3i Infotech,

---

What is Database testing and What are ways of writing test cases for database testing?

0 Answers   Ittiam Systems,

---

---

What is the maximum size of the page ?

2 Answers  

---

Explain the different types of languages that are available in the dbms?

0 Answers  

---

How many database systems are there?

0 Answers  

---

What is the best database software?

0 Answers  

---

user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?

1 Answers   HCL,

---

Explain 3nf?

0 Answers  

---

What are the steps in creating a database?

0 Answers  

---