Answer Posted / s.munna

Normalisation is basically avoid redundent data in database
for saving memory space and faster manipulation of data
keep and insert ,update , delete anamollies.....

tell us something about heap tables. : Sql dba

605

---

What is the usage of the distinct keyword?

692

---

what is sql profiler? : Sql dba

592

---

What is a primary key? Explain

546

---

what are the advantages and disadvantages of views in a database? : Sql dba

535

---

---

What version is sql?

555

---

Explain the update statement in sql

565

---

what are the types of subquery? : Sql dba

592

---

how to convert character strings to numeric values? : Sql dba

578

---

Can we change the table name in sql?

535

---

how to extract a unit value from a date and time? : Sql dba

558

---

What is the difference between partition and index?

485

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

545

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

558

---

what are the difference between clustered and a non-clustered index? : Sql dba

529

---