How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to list all tables in the database using odbc_tables()?

0 Answers  


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,


What command would you use to create an index?

0 Answers  


How to use the inserted and deleted pseudo tables?

0 Answers  






Relational calculus is what type of language?

0 Answers   HCL,


in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

0 Answers  


Which data type columns are the best candidates for full-text indexing?

0 Answers  


SQL Server Architecture ?

0 Answers   IBM, Sapient,


Do you know what is difference between index seek vs. Index scan?

0 Answers  


What is named query? : sql server analysis services, ssas

0 Answers  


Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  


Categories