How large a database can you have in this editio

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...)

Other Job Interview Questions

• How does a differential backup know which extents have changed so that it can be very quickly run?
• Which index rebuild operation in SQL Server 2005 can be performed online?
• What does HAS_DBACCESS() do?
• When you use the sp_xml_preparedocument stored procedure in SQL Server 2000, what is returned?
• If you use the EXECUTE AS clause to impersonate a user at a database-scoped level...
• On which platforms can you use Instant File Initialization to improve database growth performance in SQL Server 2005?
• You are writing a new stored procedure to perform maintenance on your SQL Server 2005 databases that defragments the indexes in an online manner. What command should you use?
• What does HAS_DBACCESS() do?
• What is row versioning in SQL Server 2005?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• More...