Answer Posted / praveenkumar

collection is set of ordered group of elements, all of the
same type.

Is primary key always clustered index?

1101

---

Does group by remove duplicates?

1120

---

If a cursor is open, how can we find in a pl/sql block?

1252

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

what are aggregate and scalar functions? : Sql dba

1142

---

what is sql server agent? : Sql dba

1189

---

what is schema? : Sql dba

1163

---

Can we rollback truncate?

1083

---

what are all the common sql function? : Sql dba

1141

---

Is inner join faster than left join?

1287

---

how many tables will create when we create table, what are they? : Sql dba

1156

---

Do we need to rebuild index after truncate?

1154

---

What is your daily office routine?

2353

---

define sql insert statement ? : Sql dba

1110

---

Is primary key clustered index?

1028

---