Answer Posted / guest

4 key default dbs :-
Master db : Holds info of all dbs located on SQL Server
insytance. Main db (else SQL Server won't work !)
MSdb : Stores info regarding Backups, SQL Agent info, DTS
packages, SQL Server jobs, replication info for log
shipping.
Tempdb : To hold temp objects like global & local temp
tables, sps
Model db: Used in creation of any new database within the
SQL Server instance of which it(model) is a part.

Define Wed Edition in SQL Azure?

100

---

What is meant by dirty read?

947

---

What is the difference between varchar and nvarchar datatypes?

1032

---

Do you know how to make remote connection in database?

897

---

What are sql dirty pages?

968

---

What is conditional split?

986

---

Explain about sql server login?

1021

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

938

---

What is meant by referential integrity?

956

---

What is a trigger and its types?

926

---

What does man by sql wildcard characters in sql server?

991

---

What does it mean if @@cursor_row returns a negative number?

939

---

Why use sub query in sql server and list out types of sub queries?

935

---

Define full outer join in sql server joins?

909

---

If a stored procedure is taking a table data type, how it looks?

6348

---