Explain database normalization?

0 Answers  

---

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

How to genrate automaticlly empid like gt001

4 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---

How many primary keys are possible in a table?

0 Answers  

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

how do we find every fifth record in a table

14 Answers   Aspire, HCL,

---

How column data types are determined in a view?

0 Answers  

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

How to create a user name in a database?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---