Answer / Bhasker Nimi

It is impossible to determine the exact index type without seeing the SQL statement in question. The type of index created depends on the column(s) involved, index name, and other options specified in the CREATE INDEX statement.

How to create a large table with random data for index testing in ms sql server?

1 Answers  

---

What is a covering index?

1 Answers  

---

How column data types are determined in a view?

1 Answers  

---

Define outer join in sql server joins?

1 Answers  

---

What is simple indexing method?

1 Answers  

---

What structure can you implement for the database to speed up table reads?

1 Answers  

---

A trigger can reference objects outside the current database? State true or false.

1 Answers  

---

What is transact-sql ddl trigger?

1 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

What is a view?

6 Answers  

---

What are the different types of columns types constraints in the sql server?

1 Answers  

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1 Answers  

---