Answer Posted / thangamadasamy

A join selects columns from 2 or more tables. A union
selects rows

What is rowtype?

1021

---

What is the purpose of the primary key?

1063

---

What is trigger types in sql?

993

---

What does over partition by mean in sql?

979

---

What is benefit of creating memory optimized table?

973

---

What does fetching a cursor do?

1090

---

How does join work in sql?

1012

---

what is the difference between where clause and having clause? : Sql dba

1000

---

What is blind sql injection?

1074

---

What is the difference between cluster and non-cluster index?

1108

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

1004

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

---

Is keyword pl sql?

1003

---

What is the current version of sql?

1023

---

What is record variable?

993

---