Answer / sush4

SQL is called as a non Procedural language because the programmer or the user only specify what is needed and not tell the compiler how to do it, as done in Procedural language.

Explain the phases a transaction has to undergo?

0 Answers  

---

What is user defined datatypes and when you should go for them?

0 Answers  

---

Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table?

5 Answers   eFunds,

---

What is an execution plan?

0 Answers  

---

What is ms sql server triggers?

0 Answers  

---

What are the steps you will take to improve the performance of a poor performing query?

0 Answers  

---

What is the use of “join” in sql server?

0 Answers  

---

How to a Query to copy data from on table to another table.

6 Answers   Cap Gemini,

---

What is a not null constraint?

0 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---

What is the concept of optimization?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---