Answer / Varun Misra

This implementation can be considered suboptimal as it introduces additional complexity, scalability issues, and potential performance problems due to COM overhead. A more efficient approach could involve using stored procedures or SQL CLR instead, which are natively integrated with SQL Server.

How is data stored in dbms?

1 Answers  

---

What is the database development process?

1 Answers  

---

What is an application role and explain a scenario when you would use one?

1 Answers  

---

I have a few records all are same structures data, I want to store data in multiple targets how

1 Answers   CTR, Infosys, Polaris,

---

What are defaults? Is there a column to which a default can't be bound?

2 Answers  

---

Who are naive users?

1 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  

---

How to generate OIDS

1 Answers  

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

1 Answers  

---

What are the types of database model?

1 Answers  

---

What is a self join? Explain it with an example?

16 Answers   TCS,

---

What are the three basic rules which are to be followed for the relational model of the database?

1 Answers  

---