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.

What is the default schema of your login session in ms sql server?

740

---

can you instantiate a com object by using t-sql? : Sql server database administration

710

---

Explain system views?

786

---

What is the return type of executeupdate ()?

690

---

Explain datetime2 data type in sal server 2008?

702

---

---

When would you use it?

756

---

How to create function without parameter in sql server?

734

---

What is page in sql server?

683

---

List some major differences between triggers and stored procedures?

684

---

How to test values returned by a subquery with the in operator?

876

---

What are exact numeric data types in ms sql server?

681

---

How do you know if sql server is running on your local system?

722

---

What is the cartesian product of table?

722

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

746

---

Is port 1433 secure?

732

---