Answer / muhammad usman(lahore)

An extended stored procedure is simply a procedure that is
implemented in a dynamic link library (DLL) — a library
that is called by an application at runtime. Extended
stored procedures can be used in much the same way as
database stored procedures, except that extended stored
procedures normally perform tasks related to the
interaction of SQL Server with its operating environment

Can you have a nested transaction?

1 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---

What is normalization? Explain different levels of normalization?

8 Answers   CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro,

---

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?

0 Answers  

---

fact table and dimension table containg one to many relationship or many to one relastionship

0 Answers  

---

Explain what a database is?

0 Answers  

---

Explain about the relational database?

0 Answers  

---

what is Normalization?

6 Answers   TCS,

---

You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?

0 Answers  

---

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

16 Answers   TCS,

---

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).

0 Answers  

---

What are the types of database model?

0 Answers  

---