Answer Posted / mruganandam(guru) mca saranath

The some features of sql server 2005 are,

1.Database Mirroring
2.Online Restore
3.Online Indexing Operation
4.Fast Recovery
5.Standards based Information Access
6.Sql Server Information Access
7.Dedicated Administrator Connection
8.Snapshot Isolation(SI)
9.Data Partitioning
10.Replication Enhancements.
which are the top ten features of Database Administration
in Sql Server 2005.

Explain syntax for viewing, dropping and disabling triggers?

896

---

What is checkpoint in sql server?

1056

---

What are relationships and mention different types of relationships in the dbms

910

---

Do you know how to implement service broker?

885

---

How to test odbc dsn connection settings?

964

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1964

---

How to remove duplicate rows from table except one?

938

---

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1905

---

What command would you use to create an index?

981

---

How to convert numeric values to integers in ms sql server?

1004

---

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

866

---

What is the standby server?

908

---

Which sql server table is used to hold the stored procedure script?

881

---

Write an SQL query to obtain the 2nd highest salary.

1018

---

What is transaction server auto commit?

983

---