Answer Posted / Somil Gupta

Truncate deletes all records in a table and reclaims storage space, while delete just removes the records but does not immediately free up space.

Is primary key always clustered index?

1099

---

What is the current version of sql?

1097

---

what are aggregate and scalar functions? : Sql dba

1132

---

what is sql server agent? : Sql dba

1185

---

how to escape special characters in sql statements? : Sql dba

1119

---

Does group by remove duplicates?

1115

---

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

1245

---

define sql insert statement ? : Sql dba

1102

---

what are all the common sql function? : Sql dba

1134

---

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

1117

---

How do I remove duplicates in two columns?

1194

---

Can we rollback truncate?

1078

---

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

1148

---

how to start mysql server? : Sql dba

1272

---

what is dbms? : Sql dba

1064

---