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  

---

Explain about network model?

0 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

1 Answers   Flextronics, Hexaware, SQL Star,

---

The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?

0 Answers  

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

0 Answers  

---

---

What are the disadvantages of cursors? How can you avoid cursors?

2 Answers  

---

How is data stored in dbms?

0 Answers  

---

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What is an extended stored procedure?

1 Answers  

---

What is the database development process?

0 Answers  

---

What are the constraints on severity level in raiseerror?

0 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---