How can a database be repaired?

925

---

What are the differences between triggers and stored procedures?

992

---

Where are full-text indexes stored?

948

---

Write a sql query to delete duplicate records from a table called table1

977

---

Which data type columns are the best candidates for full-text indexing?

919

---

What stored procedure can you use to display the current processes?

839

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

983

---

What is database replication?

1080

---

Can you force a query to use a specific index?

889

---

How you can get a list of all the table constraints in a database?

909

---

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

889

---

Write a sql query to sort on different column name according to the parameters passed in the function?

855

---

What will happen if a column containing char type data is changed to the nchar data type?

1047

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1072

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

951

---