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.

Define candidate key, alternate key, composite key?

30 Answers   IAS, IBM,

---

What are the constraints on severity level in raiseerror?

0 Answers  

---

How can you fix a poorly performing query?

0 Answers  

---

Can an extended stored procedure be called from inside a user-defined function?

0 Answers  

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

---

What are the key features of dbms?

0 Answers  

---

Explain about normal forms?

0 Answers  

---

explain detail about ftp in datastage?

0 Answers   IBM,

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---

What are the three types of database design?

0 Answers  

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---