Answer Posted / j.jyothy

Filegroup is a logical container for the collection of
datafiles.(.mdf or .ndf that is primary file group or
secondary file group)
Every database contain 2 file groups
1.Primary file group, which Contains all the primary data
files any other Secondary datafile which is not
specifically allocated to anyother file groups
2.User defined file group:It is created by the user to
group the datafiles

3.transaction log file:Does not belong to any file group.A
database can have maximaum of 32,767 file groups

Example:
Create database student
on Primary ***Primary
(
name='student_pri_data1.mdf',
filename='g:\student_primary_data1.mdf',(Location of this
file group)
size=2mb
maxsize=10mb
filegrowth=1mb
),
filegroup student_group1 ***Secondary
(
name='student_Sec_data1.mdf',
filename='g:\student_sec_data1.mdf',(Location of this file
group)
size=10mb
maxsize=12mb
filegrowth=2mb
)
log on ***log file
(
name='student_log_data1.mdf',
filename='g:\student_sec_data1.mdf',(Location of this file
group)
size=12mb
maxsize=10mb
filegrowth=1mb
)

Do you know what is a linked server in sql server?

1024

---

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

1073

---

Explain comment on transactions?

977

---

What is database replication? What are the different types of replication you can set up in sql server?

956

---

What are alternate keys?

976

---

What is after dml trigger?

1011

---

Why would you call update statistics?

1012

---

What is the recovery model? List the types of recovery model available in sql server?

900

---

Can you tell me about the concept of ER diagrams?

1063

---

What is an active database?

1009

---

What is difference between temp table and cte?

1013

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1017

---

Data table as parameter in sql server?

1041

---

What is SQL Azure Federations?

112

---

Where views are stored in sql server?

982

---