as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  

---

What are views used for?

0 Answers  

---

Which virtual table does a trigger use?

3 Answers  

---

What according to you is the difference between mysql and sql server performance?

0 Answers  

---

If a stored procedure is taking a table data type, how it looks?

1 Answers  

---

What are the properties of the transactions?

0 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---

Can anybody explain me cold backup and hot backup?

3 Answers   TCS,

---

What are the differences between UNION and JOINS?

3 Answers   CarrizalSoft Technologies,

---

Difference between Inner vs outer joins?

0 Answers  

---

How do database indexes work?

0 Answers  

---