Answer / Md. Faizan Khan

[{"test_case":"Check if a locked table can be accessed","expected_result":"The system should not allow access to the locked table and display an error message"}, {"test_case":"Check if a locked table can be unlocked","expected_result":"The locked table should be successfully unlocked and become accessible

What is the difference between coalesce() & isnull()?

1 Answers  

---

Explain what are the authentication modes in sql server?

1 Answers  

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1 Answers   TCS,

---

What is plan freezing?

1 Answers  

---

How to create a user name in a database?

1 Answers  

---

explain different types of backups avaialabe in sql server? : Sql server database administration

1 Answers  

---

What is difference between join and natural join?

1 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---

Write the SQL query to drop, truncate and delete table.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

How to genrate automaticlly empid like gt001

4 Answers  

---

1 01 101 01010

1 Answers  

---

What are the difference between primary key and unique key? : sql server database administration

1 Answers  

---