Answer Posted / anil mishra

xp stand for xperimental program

what information is maintained within the msdb database? : Sql server administration

511

---

Does an index slow down updates on indexed columns?

582

---

Differentiate between delete and truncate.

579

---

Differentiate between a primary key and a unique key.

602

---

What is the difference between a primary key and a unique key? Are they the same?

548

---

---

What are the database objects? : SQL Server Architecture

555

---

What are parameterized reports? What are cascading parameters in ssrs reports?

100

---

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

540

---

What are various aggregate functions that are available?

508

---

What is identity?

557

---

What stored by the msdb? : sql server database administration

560

---

What is ms sql server reporting services?

510

---

What are four major operators that can be used to combine conditions on a where clause?

597

---

What are the different types of replication are there in sql server 2000?

565

---

What is open database communication (odbc)?

573

---