×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. The application uses DataContexts to query the database. You create a function that meets the following requirements: "Updates the Customer table on the database when a customer is marked as deleted. "Updates the related entries in other tables (CustomerAddress, CustomerContacts) by marking them as deleted. "Prevents consumer code from setting the Deleted column's value directly. You need to ensure that the function verifies that customers have no outstanding orders before they are marked as deleted. You also need to ensure that existing applications can use the update function without requiring changes in the code. What should you do?
2.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to a Microsoft SQL Server database. The application uses a DataTable named OrderDetailTable that has the following columns: "ID "OrderID "ProductID "Quantity "LineTotal Some records contain a null value in the LineTotal field and 0 in the Quantity field. You write the following code segment. (Line numbers are included for reference only.)
01DataColumn column = new DataColumn("UnitPrice", typeof(double));
02
03OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object. You also need to ensure that UnitPrice is set to 0 when it cannot be calculated. Which code segment should you insert at line 02?
01DataColumn column = new DataColumn("UnitPrice", typeof(double));
02
03OrderDetailTable.Columns.Add(column);
You need to add a calculated DataColumn named UnitPrice to the OrderDetailTable object. You also need to ensure that UnitPrice is set to 0 when it cannot be calculated. Which code segment should you insert at line 02?
3.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 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?
4.
You use Microsoft Visual Studio 2010, Microsoft Sync Framework, and Microsoft .NET Framework 4 to create an application. You have a ServerSyncProvider connected to a Microsoft SQL Server database. The database is hosted on a Web server. Users will use the Internet to access the Customer database through the ServerSyncProvider. You write the following code segment. (Line numbers are included for reference only.)
01SyncTable customerSyncTable = new SyncTable("Customer");
02customerSyncTable.CreationOption = TableCreationOption. UploadExistingOrCreateNewTable;
03
04customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements: "Users can modify data locally and receive changes from the server. "Only changed rows are transferred during synchronization. Which code segment should you insert at line 03?
01SyncTable customerSyncTable = new SyncTable("Customer");
02customerSyncTable.CreationOption = TableCreationOption. UploadExistingOrCreateNewTable;
03
04customerSyncTable.SyncGroup = customerSyncGroup;
05 this.Configuration.SyncTables.Add(customerSyncTable);
You need to ensure that the application meets the following requirements: "Users can modify data locally and receive changes from the server. "Only changed rows are transferred during synchronization. Which code segment should you insert at line 03?
5.
You use Microsoft Visual Studio 2010 and Microsoft ADO.NET Framework 4 to create an application. The application connects to a Microsoft SQL Server 2008 database. You use the ADO.NET LINQ to SQL model to retrieve data from the database. You use stored procedures to return multiple result sets. You need to ensure that the result sets are returned as strongly typed values. What should you do?
6.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. You use the ADO.NET Entity Framework to model entities. You write the following code segment. (Line numbers are included for reference only.)
01AdventureWorksEntities context = New AdventureWorksEntities (http://localhost:1234/
AdventureWorks.svc );
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;
You need to ensure that the application meets the following requirements: "Compares the current values of unmodified properties with values returned from the data source. "Marks the property as modified when the properties are not the same. Which code segment should you insert at line 02?
01AdventureWorksEntities context = New AdventureWorksEntities (http://localhost:1234/
AdventureWorks.svc );
02
03var q = from c in context.Customers
04where c.City == "London"
05orderby c.CompanyName
06select c;
You need to ensure that the application meets the following requirements: "Compares the current values of unmodified properties with values returned from the data source. "Marks the property as modified when the properties are not the same. Which code segment should you insert at line 02?
7.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Communication Foundation (WCF) Data Services service. The service connects to a Microsoft SQL Server 2008 database. The service is hosted by an Internet Information Services (IIS) 6.0 Web server. The application works correctly in the development environment. However, when you connect to the service on the production server, attempting to update or delete an entity results in an error. You need to ensure that you can update and delete entities on the production server. What should you do?
8.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application uses the ADO.NET Entity Framework to model entities. You need to create a database from your model. What should you do?
9.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application connects to several SQL Server databases. You create a function that modifies customer records that are stored in multiple databases. All updates for a given record are performed in a single transaction. You need to ensure that all transactions can be recovered. What should you do?
10.
You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create an application. The application updates several Microsoft SQL Server databases within a single transaction. You need to ensure that after a resource failure, you can manage unresolved transactions. What should you do?