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

What is 3nf normalization form?

1168

---

Do you know what are different types of replication in sql server?

1154

---

What methods do you follow to protect from sql injection attack?

1075

---

How do I find the port number for sql server?

1017

---

What are the methods used to protect against sql injection attack?

1118

---

How to display a past time in days, hours and minutes?

1059

---

What is 4nf in normalization form?

1061

---

What is difference between clustered index and non clustered index?

1123

---

Explain the dirty pages?

1050

---

How to create an identity column?

1301

---

What is the concept of optimization?

1110

---

What is the difference between functions and scalar functions?

1278

---

Do you know what guidelines should be followed to help minimize deadlocks?

1014

---

Explain error and transaction handling in sql server?

1062

---

What is the template in sql?

1029

---