Answer / 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
)

Answer / priyanka

Filegroups are named collections of files and are used to
help with data placement and administrative tasks such as
backup and restore operations.

Answer / anuj

Filegroups are group or collection of Files that is used to
maintauined the transaction of Data and Restore Operations.

We create an index to fast the search. How it fast the query? Do we write any special keyword with query?

3 Answers  

---

How to view existing indexes on an given table using sp_help?

0 Answers  

---

What do you mean by data manipulation language?

0 Answers  

---

How do I completely remove sql server instance?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

How do I shrink an ldf file?

0 Answers  

---

State a few properties of relational databases?

0 Answers  

---

Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,

---

What is the difference between executequery () and executeupdate ()?

0 Answers  

---

What are entities and relationships?

0 Answers  

---

please differentiate between delete and truncate?

0 Answers  

---