You add a table to the database to track changes to part names. The table stores the following row values:
-the username of the user who made the change
-a part ID
-the new part name
-a DateTime value
You need to ensure detection of unauthorized changes to the row values.
You also need to ensure that database users can view the original row values.

• A. Add a column named hash. Use System.Security.Cryptography.MD5 to create an MD5 hash of the row values, and store in the hash column.
• B. Use System.Security.Cryptography.DES to encrypt all the row values using an encryption key held by the application.
• C. Add a column named signature. Use System.Security.Cryptography.RSA to create a signature for all of the row values. Store the signature in the signature column. Publish only the public key internally.
• D. Use System.Security.Cryptography.RSA to encrypt all the row values. Publish only the key internally.

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects
to a Microsoft SQL Server 2008 database. The application performs a database query within a transaction.
You need to ensure that the application can read data that has not yet beed commited by other
transactions.
Which IsolationLevel should you use?

• A. ReadUncommitted
• B. Unspecified
• C. ReadCommitted
• D. RepeatableRead

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create a Microsoft ASP.NET
application.
You want to connect the application to a Microsoft SQL Server Express 2008 database named
MyDatabase.
The primary database file is named MyDatabase.mdf and it is stored in the App_Data folder.
You need to define the connection string. Which connection string should you add to the Web.config file?

• A. Data Source=localhost; Initial Catalog=MyDataBase; Integrated Security=SSPI; User Instance=True
• B. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\App_Data\MyDatabase.mdf; Integrated Security=SSPI; User Instance=True
• C. Data Source=.\SQLEXPRESS; Initial Catalog=MyDataBase; Integrated Security=True; User Instance=True
• D. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\MyDatabase.mdf; Integrated Security=True; User Instance=True

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application that
connects to a Microsoft SQL Server 2008 database.
You use the ADO.NET Entity Framework Designer to model entities. You add the following stored
procedure to the database, and you add a function import to the model.
CREATE PROCEDURE [dbo].[InsertDepartment] @Name nvarchar(50), @ID int NULL OUTPUT
AS INSERT INTO Department (Name) VALUES (@Name) SELECT @ID = SCOPE_IDENTITY()
You need to insert a new department and display the generated ID. Which code segment should you use?

• A. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", typeof(int));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• B. using (SchoolEntities context = new SchoolEntities())
  {
  var id = context.InsertDepartment("Department 1", null);
  Console.WriteLine(id);
  }
• C. using (SchoolEntities context = new SchoolEntities())
  {
  ObjectParameter id = null;
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }
• D. using (SchoolEntities context = new SchoolEntities())
  {
  var id = new ObjectParameter("ID", null));
  context.InsertDepartment("Department 1", id);
  Console.WriteLine(id.Value);
  }