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.

Define inner join? Explain with an example?

0 Answers  

---

How many types of keys are there?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

---

What is indexing and its types?

0 Answers  

---

What are joins in sql and what are the different types of joins?

0 Answers  

---

What is table value parameters (tvp)?

0 Answers  

---

What is cursors?

0 Answers   NA,

---

Mention the command used to rename the database.

0 Answers  

---

What is the difference between grant and with grant while giving permissions to the user?

0 Answers  

---

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

---

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

---