Difference between views and materialized views?

5 Answers   BirlaSoft,

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---

Explain the types of joins in sql?

0 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---

What is a sql driver?

0 Answers  

---

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678

2 Answers  

---

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

---

Which one is better subquery or joins?

0 Answers  

---

What is composite primary key in sql?

0 Answers  

---

What is difference between inner join and cross join?

0 Answers  

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---