Do we need to create index on primary key?

0 Answers  

---

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  

---

write a query to delete similar records in same table

13 Answers   TCS,

---

i have some prob lem to tell me about my self in interview first round ...

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What is scope and visibility in PL/SQL?

0 Answers  

---

What is user defined functions?

0 Answers  

---

why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---