Answer / Deepesh Singh Chauhan

A data architect designs, constructs, and manages an organization's information resources. Advantages of a good data architecture include improving the quality and consistency of data, promoting better decision making through data-driven insights, enabling scalability and adaptability to future needs, and minimizing redundancy and data silos.

Is natural join and equi join same?

1 Answers  

---

What is the difference between Procedure and Function

4 Answers   Accenture, Nagarro, TCS,

---

Other than truncate statement, which other command can by-pass the trigger on the tables?

1 Answers  

---

Which sql server table is used to hold the stored procedure scripts?

1 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

What are acid properties of transaction?

1 Answers  

---

How do I save a stored procedure in sql server?

1 Answers  

---

When is the use of update_statistics command?

1 Answers  

---

How to automatically create a log when an exception is being received into SQL Server?

1 Answers   Cap Gemini,

---

What is a group function explain with an example?

1 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  

---

Is null in sql server?

1 Answers  

---