Answer Posted / talha

1 yes
2 no
3 no
4 no
5 no
6 no

What is the difference between stored procedure and user defined functions?

1229

---

How do we know if any query is retrieving a large amount of data or very little data?

1031

---

How can I know what locks are running on which resource?

992

---

What is the optimization being performed in oracle and SQL Server?

1093

---

What stored by the msdb? : sql server database administration

1049

---

How to apply cascading referential integrity in place of triggers?

1085

---

What is compound operators?

1113

---

What is the significance of null value and why should we avoid permitting null values?

1029

---

How to insert multiple rows with one insert statement in ms sql server?

1172

---

How to check if a table is being used in sql server?

1006

---

How many types of functions are there in sql server?

984

---

What are the types of containers in ssis?

1229

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1447

---

What is difference between primary key and foreign key?

950

---

What are the basic functions for master, msdb, model, tempdb and resource databases?

1031

---