More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
How large a database can you have in this edition of SQL Server 2005? ...
You are considering using the SQL Server Everywhere (SQL Server Compact Edition) in your application that will run on Smartphones and PDAs. However you are concerned that it will not hold all the data that people will store in it over the next few years. How large a database can you have in this edition of SQL Server 2005?
Answer: 4GB
Explanation: The database limit is 4GB, which at the current time, greatly exceeds the capacity for most small devices.
(Continued on next question...)