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

Can group by and orderby be used together?

972

---

Define constraints and give an example of their use?

997

---

What is the recursive stored procedure in sql server?

972

---

Explain what are the basic functions for master, msdb, model, tempdb databases?

922

---

How many levels of sp nesting is possible?

1004

---

Is resultset an interface?

914

---

What is SQL Azure Federations?

112

---

What are the recovery models in sql server 2000?

929

---

How to return the date part only from a sql server datetime datatype?

1036

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1039

---

How to create median function?

156

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

1010

---

Can we add an identity column to decimal datatype?

957

---

List out different types of normalizations in sql server and explain each of them?

895

---

Write query to return all rows sql?

1015

---