Answer Posted / mobin sathupally

When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.

Define views.

1068

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2544

---

What is the security model used in sql server 2005?

1066

---

What happens if date-only values are provided as date and time literals?

1073

---

Differentiate between delete and truncate.

1110

---

What is sql server 2000 work load governor?

1157

---

How to concatenate two binary strings together?

1174

---

How to find the list of fixed hard drive and free space on server?

1278

---

What are the steps to follow to configure SQL*Net?

1073

---

Describe the functionalities that views support.

1144

---

what is isolation level at dead lock?

2209

---

What is the log shipping?

1060

---

What is row_number () and partition by in sql server?

1131

---

Define ACID properties in a Database?

1102

---

Where to find ntwdblib.dll version 2000.80.194.0?

1007

---