Answer / Vaneet Parkash

Rollup and Cube are aggregate functions in T-SQL used for grouping and summarizing data. Rollup generates a summary row for each group, including the total of all groups. Cube generates a pivot table that displays cross-tabulated group results.

What is normalization sql?

1 Answers  

---

what is the bond code in materialized view?

1 Answers  

---

What is the usage of when clause in trigger?

1 Answers  

---

What is the purpose of primary key?

1 Answers  

---

What is cursor explain with example?

1 Answers  

---

check whether all the emp numbers are indeed unique.

6 Answers  

---

What is clustered, non-clustured and unique index. How many indexes can be created on a table ?

3 Answers   TCS,

---

Are sql views compiled?

1 Answers  

---

How many sql statements are used?

1 Answers  

---

What is equi join in sql?

1 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

Can we create non-clustured index on a clustered index ?

4 Answers   TCS,

---