Answer Posted / mohsin mohammed abdul

Delete command deletes the data from the tables .. but can
get back on issue of roll back whereas when you issue
truncate deletes the records and oracle implicitly issues
commit command and even when you issue rollback you won't
get the data back

Can you explain important index characteristics?

988

---

State the difference between union and union all?

926

---

Explain having clause?

960

---

Can a table be moved to different filegroup?

972

---

What the different types of Replication and why are they used?

1069

---

How can we migrate from SQL server to SQL Azure?

113

---

What is identity?

1013

---

Write a SQL query to make a column as unique?

1030

---

What is the command used to recompile the stored procedure at run time?

1079

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

1036

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

1058

---

How to generate create function script on an existing function?

1109

---

How to declare and use cursor variables?

1165

---

Explain the difference between functions and stored procedures in sql server?

976

---

What is difference between views and tables?

1006

---