ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
what are file groups?
 Question Submitted By :: Dinesh Gupta
I also faced this Question!!     Rank Answer Posted By  
 
  Re: what are file groups?
Answer
# 1
Filegroups are named collections of files and are used to 
help with data placement and administrative tasks such as 
backup and restore operations.
 
Is This Answer Correct ?    3 Yes 1 No
Priyanka
 
  Re: what are file groups?
Answer
# 2
Filegroups are group or collection of Files that is used to 
maintauined the transaction of Data and Restore Operations.
 
Is This Answer Correct ?    1 Yes 2 No
Anuj
 
 
 
  Re: what are file groups?
Answer
# 3
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
)
 
Is This Answer Correct ?    4 Yes 0 No
J.jyothy
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
The Difference between 'Count' and 'Count(*)'  12
What is blocking and how would you troubleshoot it?  1
how to change column into row in sql ESS2
What is the use of MOVE keyword in restore command IBM2
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
What is database replicaion? What are the different types of replication you can set up in SQL Server? HCL4
What's the maximum size of a row?  4
What's the difference between a primary key and a unique key?  4
Which data type can be used only on OUTPUT parameters of the stored proceduer?  2
What are the different types of replication? How are they used?  3
What is a view?  4
what are batch in sql server? Satyam2
to explain sql server 2000 architecture & authentication  1
What is the difference between login and a user? TCS7
How do SQL server 2000 and XML linked?  2
CLR Integration ? what is Notification services ? Satyam1
Different Types of Functions ? Satyam2
How can u convert the Date to String? TCS4
What are the two types of concurrency?  2
From where can you change the default port?  3
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com