After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

0 Answers   Cognizant,

---

1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?

3 Answers  

---

What are page splits?

0 Answers  

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

---

Is Sql non procedural query language?

1 Answers   Verifone,

---

how to use DTS package in 2000,2005,2008 in sql server

0 Answers   Microsoft,

---

What does the update command do?

0 Answers  

---

What is sql stored procedure?

0 Answers  

---

What are the types of indexing?

0 Answers  

---

What are the purposes and advantages stored procedure?

0 Answers  

---

What is normalization and what are the advantages of it?

0 Answers  

---

table:employee EID ENAME MID(manager ids) 101 rama null 102 sita 101 103 siva 101 104 ganesh 103 . . . . . . for 103 ID the manager ID is 101(RAMA) and for 104 manager is SIVA if i give employee id (EID) you have to tell the manager for that EID write query? eample:if i give 102 .The query output should be manager for 102 ID that it should print RAMA as output

7 Answers  

---