You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

How to generate OIDS

0 Answers  

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

0 Answers  

---

What is denormalization and when would you go for it?

9 Answers   NBP,

---

how to find the first two highest salaries in deptno in emp table

2 Answers  

---

---

How would you design a database for an online site, which would average a million hits a day?

0 Answers  

---

Explain about xml databases?

0 Answers  

---

Who are end users in dbms?

0 Answers  

---

Can you have a nested transaction?

1 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

what is the use of foreginkey

2 Answers  

---

Write short notes on manual refreshes.

0 Answers  

---