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.

Who are end users in dbms?

0 Answers  

---

How to replace not in with not exist?

0 Answers  

---

What is the system function to get the current user's user id?

4 Answers  

---

How to use online Backups?

0 Answers  

---

Explain the process of the user request and data generating?

0 Answers  

---

---

What is a join and explain different types of joins?

2 Answers  

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

What is normalization? Explain different levels of normalization?

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

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

Explain the cube operator?

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  

---

How can you log an error to the server event log from a stored procedure?

0 Answers  

---