Answer / Deepak Kumar Pathak

In SQL Server, there are several types of indexes: Clustered Indexes (which determine the physical order of data in a table), Non-Clustered Indexes (which have a separate structure that stores the indexed columns and a pointer to the actual data), Composite Indexes (which are created using multiple columns), Primary Key Indexes (which are a type of clustered index used to uniquely identify each row), Unique Indexes (which ensure that no two rows have duplicate values for the specified columns), and Full-Text Indexes (which are used for text search queries).

What are ddl (data definition language) statements for tables in ms sql server?

1 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

Describe the functionalities that views support.

1 Answers  

---

What is the difference between grant and with grant while giving permissions to the user?

1 Answers  

---

what is trigger

1 Answers   CarrizalSoft Technologies, NIIT,

---

how many type of subquery?

2 Answers  

---

Explain error handling in ssis?

1 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---

Explain what is the difference between union and union all?

1 Answers  

---

What is molap and its advantage? : sql server analysis services, ssas

1 Answers  

---

What is difference between inner join and full join?

1 Answers  

---

What is transact-sql language?

1 Answers  

---