Answer Posted / nirmala.s

if u use delete to remove the data from the table,this will
delete the data.after using rollback the removed data can
be retrived.But in case of, truncate , it will delete the
data and that can't ever be retrived.even after using
rollback also. but the table structure of the table will
be there

if u are using drop command , this will delete entire
table.and its structure.

What is attribute relationships, why we need it? : sql server analysis services, ssas

955

---

Write a code to select distinct records without using the DISTINCT keyword.

1107

---

How to rebuild indexes with alter index ... Rebuild?

1114

---

What are the main sources of data?

1082

---

What is triggers and its types?

1005

---

What is policy based management (pbm)? : sql server database administration

970

---

How can you ensure that the database and sql server based application perform well?

1063

---

What is the use of builtinadministrators group in sql server? : sql server security

1034

---

How many replicas are maintained for each SQL Azure database?

142

---

Can primary key be null?

922

---

What is GUID in sql server?

1154

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

941

---

How many types of attribute relationships are there? : sql server analysis services, ssas

1061

---

Mention the command used to rename the database.

996

---

What are the purposes of floor and sign functions?

964

---