Answer Posted / pradeepreddy

differential backup backups only changes made in the
database on to backup media since the last full backup

what is dbcc? : Sql server database administration

1077

---

Define left outer join?

1027

---

Why do we use trigger?

1024

---

what are different types of raid configurations? : Sql server database administration

1099

---

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

995

---

How to download and install sql server 2005 books online?

1276

---

What the class forname () does?

1140

---

How much space does sql server 2016 take?

1033

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1254

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1211

---

Will sql server 2005 allow you to reduce the size of a column?

1054

---

What is subquery explain with example?

1123

---

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1120

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1107

---

What is multi-statement table-value user-defined function?

1053

---