You are building an application for a Smartphone

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You are building an application for a Smartphone and want to use SQL Server Compact Edition. However you do not want this to run as a service all the time because of power concerns. What can you do?

Answer: This edition does not run as a service, so there is nothing to worry about.

Explanation: SQL Server Compact Edition runs in process with an application, meaning it does not run as a service. Therefore it will only run when your application is running.

(Continued on next question...)

Other Job Interview Questions

• What is the difference between a return parameter and an OUTPUT parameter?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• What does the DEALLOCATE statement do in SQL Server 2005?
• How secure are encrypted stored procedures, triggers and views?
• Which is these is not necessary for a well-formed XML document?
• How can you ensure they do not change the underlying tables without also changing the view and not disrupt their workflow?
• How many of these servers can you consolidate?
• In configuring the thesaurus configuration file for SQL Server 2005 Full-Text Search, you set the diacritics_sensitive value to 1. What does this mean?
• What is an index? What types of indexes are available in SQL Server 2000?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• More...