How are SQL Server databases physically stored under
Windows 2000?



How are SQL Server databases physically stored under Windows 2000?..

Answer / laxman

stored as mdf & ldf files

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Why should we go for stored procedures? Why not direct queries?

0 Answers  


What is user-defined function?

0 Answers  


Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  


One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  


we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  






Mention the command used to rename the database.

0 Answers  


What is a transactions?

0 Answers  


What are the types of database schema? : sql server analysis services, ssas

0 Answers  


Is sql server is free?

0 Answers  


Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,


What is difference between sql and sql server?

0 Answers  


What are key, name and value columns of an attribute? : sql server analysis services, ssas

0 Answers  


Categories