Answer Posted / hari

Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers

What is save transaction and save point?

1256

---

Mention the different types of triggers?

1202

---

What are dml triggers and types of dml triggers?

1028

---

What is resource governor?

1031

---

How to define and use table alias names in ms sql server?

1208

---

How do I view a script in sql server?

1087

---

How do I make a resultset scrollable?

1013

---

Can we hide the definition of a stored procedure from a use?

1296

---

What do you mean by an execution plan? Why is it used?

1077

---

What are functions in the sql server?

1293

---

How to list all login names on the ms sql server?

1184

---

Can multiple columns be used in sql group by clause in ms sql server?

1116

---

What are Spatial data types in SQL Server 2008

1072

---

Can you create a logon trigger in sql server 2005 express edition?

1120

---

Which autogrowth database setting is good?

1096

---