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

How many types of cursor type are there?

1090

---

what are user defined datatypes and when you should go for them? : Sql server database administration

1019

---

Mention the different types of replication in sql server.

1026

---

What is a dataset and what are the different types of datasets?

136

---

How to change a login name in ms sql server?

1089

---

What is compound operators?

1058

---

What is partition index in sql server?

1120

---

what data regions are and what are the different data regions?

141

---

Indexes are updated automatically is the full-text index also updated automatically?

1029

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1111

---

How do I view a procedure in sql server?

991

---

Explain about SQL server 2005?

975

---

What are the new features of sql server 2012 reporting service?

133

---

What are the built in functions in sql server?

985

---

Tell me about normalization in DBMS.

995

---