You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
You have recently created a Windows service for ABC.com. You are then instructed to run a newly
created Windows service from the command-line.
What is the option you should take?

You are employed as a developer at ABC.com.
You have just completed the creation of a Windows service. You are now preparing to apply the

service by installing it.
What option should you use?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server in their
environment.
You are creating a new application for ABC.com. The new application should be configured to
ABC.coms client list in a .txt file.
You have been informed that your solution should allow for the file to be accessed by ordinary text
editors. You have also been informed that the file should take up as little space as possible.
What action should you take?

You are employed as a developer at ABC.com. You are using ASP.NET and C# to develop a new
Web site for ABC.com.
You have created a new application for ABC.com using C#. The new application must be able to
retrieve a single value from a ABC.com SQL Server database.

You want to make sure that this process takes as little time as possible.
What option should you make use of?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server in their
environment.
ABC.com has a database table, named ABCItems. You want to make sure that obsolete items are
expunged from ABCItems when you update it.
What action should you take?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
You have been instructed to create a new program for ABC.com. the program must be able to
return a list of data from a ABC.com database and allow you to view the returned data, regardless
of whether you are linked to the SQL server or not.

What action should you take?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
You have been instructed to create a new program for ABC.com. This new program must be able
to write information to a flat file.
You decide to include a BinaryWriter class in your code.
What is TRUE with regards to the BinaryWriter class?

You are employed as a developer at ABC.com.
You have received instructions to create a new application for ABC.com. The new application
must have the ability to duplicate information hosted by a ABC.com SQL server data table in a
Dataset.
What action should you take?

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
You are currently running a training exercise for potential developers. You are in the process of
discussing stored procedures.
What are options that suitably describe the advantages of making use of stored procedures in
SQL Server? (Choose all that apply.)

You are employed as a developer at ABC.com. ABC.com makes use of SQL Server databases in
their environment.
ABC.com has an application that contains a SqlDataAdapter object and an OleDbDataAdapter
object. You are required to link up to a SQL Server database table. ABC.coms application
contains a DataSet object for this specific table.
You want to make sure that data from the database is loaded into the DataSet object using a
strategy that provides the most efficient execution.
What method should be included in your code?