Answer Posted / vikas

1)select
2)insert
3)update
4)delete

what are different types of backups available in sql server? : Sql server database administration

932

---

How to create an index on an existing table in ms sql server?

979

---

What is user-defined function?

966

---

What are the types of sql server?

1048

---

How to find out what is the default collation in a database?

1117

---

What is server-level principal?

122

---

Difference between connected and disconnected database in .net with sql server?

1094

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1137

---

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?

1033

---

What is a rownum?

970

---

What do you mean by an execution plan? How would you view it?

912

---

How do you rebuild an identity column?

945

---

What are system databases into sql server (2005/2008)?

997

---

What are the results of running this script?

920

---

What are the new features are introduced in sql server 2012 reporting services?

149

---