POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 201-210

EnsurepassQUESTION 201 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. You load records from the Customers table into a DataSet object named dataset. You need to retrieve the value of the City field from the first and last records in the Customers table. Which code segment should you use?   DataTable dt = dataset.Tables[“Customers”]; string first = dt.Rows[0][“City”].ToString(); string Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 191-200

EnsurepassQUESTION 191 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. SQLConnection conn = new SQLConnection(connectionString); conn.Open(); SqlTransaction tran = db.BeginTransaction(IsolationLevel. …); …   You must retrieve not commited records originate from various transactions. Which method should you use?   ReadUncommited ReadCommited RepeatableRead Serializable Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 181-190

EnsurepassQUESTION 181 You use Microsoft Visual Studio 2010 and Microsoft. NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server database. You use Entity SQL of the ADO.NET Entity Framework to retrieve data from the database. You need to define a custom function in the conceptual model. You also need to ensure that the function calculates a value based on properties of the object. Which two XML element types should you use? (Each correct answer presents part Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 171-180

EnsurepassQUESTION 171 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to develop an application. You use the Entity Framework Designer to create an Entity Data Model (EDM). You need to create a database creation script for the EDM. What should you do?   Use a new Self-Tracking Entities template. Drag entities to Server Explorer. Run the Generate Database command. Select Run Custom Tool from the solution menu.   Correct Answer: C     QUESTION 172 You Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 161-170

EnsurepassQUESTION 161 The database contains orphaned Color records that are no longer connected to Part records. You need to clean up the orphaned records. You have an existing ContosoEntities context object named context. Which code segment should you use?   var unusedColors = context.Colors.Where(c => !c.Parts.Any()).ToList(); foreach (var unused in unusedColors){ context.DeleteObject(unused) } context.SaveChanges();   context.Colors.TakeWhile(c => !c.Parts.Any()); context.SaveChanges(); Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 151-160

EnsurepassQUESTION 151 You are working with an ObjectContext object that targets the mainframe and another ObjectContext object that targets SQL Server. When it’s time to save the changes, you want all changes to be sent to the mainframe and to SQL Server as one transaction. How can you accomplish this?   Just save both ObjectContext objects because they automatically join the same transaction. Save to the mainframe and use an if statement to verify that the changes were successful. If successful, Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 141-150

EnsurepassQUESTION 141 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application connects to a Microsoft SQL Server 2008 database. The application uses a Microsoft ADO. NET SQL Server managed provider. When a connection fails, the application logs connection information, including the full connection string. The information is stored as plain text in a .config file. You need to ensure that the database credentials are secure. Which connection Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 131-140

EnsurepassQUESTION 131 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. You use the ADO.NET Entity Framework to model your entities. You use Plain Old CLR Objects (POCO) entities along with snapshot-based change tracking. The code accesses the POCO entities directly. You need to ensure that the state manager synchronizes when changes are made to the object graph. Which ObjectContext method should you call?   Refresh SaveChanges DetectChanges Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 121-130

EnsurepassQUESTION 121 You want to execute a SQL insert statement from your client application, so you set the CommandText property of the command object and open the connection. Which method will you execute on the command?   ExecuteScalar ExecuteXmlReader ExecuteReader ExecuteNonQuery   Correct Answer: D     QUESTION 122 In ADO.NET, which class can start an explicit transaction to update a SQL Server database?   SqlCommand SqlConnection SqlParameter SqlException Read more […]

POST

New Updated Microsoft MCTS 70-516 Real Exam Questions and Answers Download 111-120

EnsurepassQUESTION 111 You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4.0 to create an application. The application uses the ADO.NET Entity Framework to model entities. You define a Category class by writing the following code segment. (Line numbers are included for reference only.)   01 public class Category 02 { 03 public int CategoryID { get; set; } 04 public string CategoryName { get; set; } 05 public string Description { get; set; } 06 public byte[] Picture { get; set; Read more […]