1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers   CSC, IBM,

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

Which is faster statement or preparedstatement?

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,

---

How can u convert the Date to String?

6 Answers   Microsoft, TCS,

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

Can sql server 2016 run on windows 7?

0 Answers  

---

What are the factors you will check for the performane optimization for a database query?

7 Answers   CarrizalSoft Technologies, DELL, SoftSol,

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

What are the advantages of partitioning?

0 Answers  

---

What is the primary use of the model database?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---