Answer / abinash

yes we can have nested transaction.

A transaction is nothing a set of sql statement which either executes at a time or nothing will happen and we specify the transaction using Begin and End.

And also we can have multiple begin end (nested transaction) inside a transaction.

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

1 Answers   Flextronics, Hexaware, SQL Star,

---

What is the physical representation for a many-to-many relationship?

0 Answers  

---

Write the fastest query to find out how many rows exist in a table?

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  

---

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  

---

What are the three types of database design?

0 Answers  

---

What are the main phases of database development?

0 Answers  

---

Explain about the database management systems.

0 Answers  

---

what is Normalization?

6 Answers   TCS,

---

What are the three basic rules which are to be followed for the relational model of the database?

0 Answers  

---

How is data stored in dbms?

0 Answers  

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

0 Answers  

---