when is the use of update_statistics command? : Sql dba

0 Answers  

---

Does a join table need a primary key?

0 Answers  

---

What is cte?

0 Answers  

---

four procedures is are there should i write their in a package

2 Answers  

---

What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

what is SCALAR Queries?

2 Answers   ITC Infotech,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

---

Does asenumerable execute the query?

0 Answers  

---

What is clustered and nonclustered index in sql?

0 Answers  

---

What is a table in a database?

0 Answers  

---

- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

0 Answers   CTS,

---