Answer Posted / sruthi

Index created on view is called as indexed view or
materialised view.
To create index on a view we should create a view
with "schemabinding"
eg:
create view v1 with schemabinding as
select empno,ename from dbo.emp
---
while creating view with schema binding refer to table by
default owner
---
now create index on that view
--
create clustered index i1 on v1(empno)
--
now this is called as indexed view

What are types of storage modes? : sql server analysis services, ssas

1078

---

what are the new features in SSRS?

145

---

Explain the properties of sub-query in sql server?

1066

---

Explain cross join or cartesian product in sql?

923

---

How many databases can we create in a single server?

209

---

How to get the definition of a user defined function back?

1084

---

What are the differences between DDL, DML and DCL in SQL?

1277

---

How to create a view on an existing table in ms sql server?

1186

---

What are different types of replication in sql server?

1141

---

In what three ways is the return statement used in a stored procedure?

1060

---

Explain user defined views?

1008

---

How do you manipulate data?

948

---

What are the restrictions while creating batches in sql server?

1111

---

Explain for xml explicit mode?

1024

---

What do you mean by cardinality?

938

---