Answer Posted / manoj kumar

Contraint is a provision to limit or enforce the data in
the sql tables. It is of five types:-
1 Primary Key Constraint
2 Foreign Key Constraint
3 Unique Constraint
4 Not Null Constraint
5 Check Constraint

Write a SQL command to insert and update only a particular field?

807

---

How to execute function in stored procedure sql server?

758

---

What are four major operators that can be used to combine conditions on a where clause?

764

---

Can group by be used without aggregate functions?

690

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

747

---

Explain the relational database management system (rdbms)?

775

---

Explain about temporary stored procedure?

686

---

What is encryption key?

98

---

What are the diifferences between the ms sql server vs mysql?

896

---

How to backup encryption key ?

144

---

What is the difference between locking and multi-versioning?

730

---

How to enforce security in sql server? : sql server security

808

---

Sql server reporting services vs. Crystal reports.

112

---

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

2256

---

Why do we use non clustered index?

740

---