Answer / samba shiva reddy . m

When we done operation on SQL SERVER that is not commited directly to the database example:we are deleting bulk records from server but in between power shut down or some thing happened then that transaction is not committed from our side if we create check point on that delete statement after deleting some records it will save as check point next no need to delete those records again if check point is not there means we have to start form scratch.All operation must be logged in to Transaction Log files after that they should be done on to the main database.CheckPoint are the point which alert Sql Server to save all the data to main database if no Check point is there then log files get full we can use Checkpoint command to commit all data in the SQL SERVER.When we stop the SQL Server it will take long time because Checkpoint is also fired.

Why is normalisation important?

0 Answers  

---

What is table level trigger?

0 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

How to create a store procedure with encryption?

0 Answers  

---

What are locks in sql?

0 Answers  

---

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

---

whats the maximum size of view state??

0 Answers  

---

Explain system views?

0 Answers  

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

---

What is primary key index?

0 Answers  

---

How to use old values to define new values in update statements in ms sql server?

0 Answers  

---

What is Extended user-defined?

0 Answers  

---