What is a mixed extent?

0 Answers  

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is difference between delete and truncate commands?

0 Answers  

---

in how many ways we can use count()

2 Answers  

---

What is 3nf normalization?

0 Answers  

---

Name the different type of indexes in sql?

0 Answers  

---

How sql server executes a statement with nested subqueries?

0 Answers  

---

What is the difference between seek predicate and predicate?

0 Answers  

---

How to recompile stored procedure at run time?

0 Answers  

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

What are the different ways you can create databases in sql server?

0 Answers  

---