Answer Posted / hari

Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc

How do we Backup SQL Azure Data?

108

---

Explain how many types of relationship?

1029

---

Explain about service Broker functions?

1032

---

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1009

---

What is default port number for sql server 2000?

1047

---

Define model database?

979

---

Is truncate autocommit?

938

---

Explain foreign key in sql server?

1030

---

Find columns used in stored procedure?

991

---

difference between Clustered index and non clustered index ?

993

---

What is the rdl file?

138

---

Which are the new data types introduced in sql server 2008?

880

---

What happens if you are trying to access a schema not owned by you?

968

---

Your table has a large character field there are queries that use this field in their search clause what should you do?

885

---

what is denormalization and when would you go for it? : Sql server database administration

1188

---