Answer Posted / rajesh s. chandan

It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.

When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.

Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.

What are the results of running this script?

974

---

Where cross join is used?

1028

---

How is sql used in sql server?

1056

---

Mention the 3 ways to get a count of the number of records in a table.

1025

---

Explain sql server service broker?

1026

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

127

---

What is thr feature of change data capture?

1033

---

Explain about sql server login?

1134

---

What is sql server profiler?

1061

---

How do you use a subquery to find records that exist in one table and do not exist in another?

1087

---

What is trigger explain with program?

1015

---

Determine when an index is appropriate?

1129

---

System requirements for sql server 2005 express edition?

1069

---

Explain what is it unwise to create wide clustered index keys?

1023

---

Define the one-to-one relationship while designing tables.

939

---