News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

MCPD- Exam 70-516: Accessing Data with Microsoft .NET Framework 4

  1. http: //contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName, Address

  2. http: //contoso.com/Northwind.svc/Customers?City=Seattle & Level gt 200 & $orderby=ContactName and Address

  3. http: //contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName,Address

  4. http: //contoso.com/Northwind.svc/Customers?$filter=City eq 'Seattle' and Level gt 200 & $orderby=ContactName and Address

Answer: Answer is c

  1. PUT /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }

  2. PUT /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

  3. MERGE /Northwind.svc/Customers(123) Host: contoso.com Content-Type: application/json { City: 'Seattle' }

  4. MERGE /Northwind.svc/Customers(123) Host: contoso.com Accept: application/json { City: 'Seattle' }

Answer: Answer is c

  1. Override the Delete operation of the DataContext object.

  2. Override the Update operation of the DataContext object.

  3. Modify the SELECT SQL statement provided to the DataContext object to use an INNER JOIN between the Customer and Orders tables.

  4. Add new entities to the DataContext object for the Customers and Orders tables.

Answer: Answer is a

  1. Override the Delete operation of the customer entity.

  2. Remove the foreign key between the Customers and Orders tables.

  3. Use the ExecuteDynamicDelete method of the DataContext object.

  4. Modify the foreign key between the Customers and Orders tables to enable the ON DELETE CASCADE option.

Answer: Answer is d

  1. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch SqlExceptions.

  2. Add a try/catch statement around calls to the SubmitChanges method of the DataContext object and catch ChangeConflictExceptions.

  3. Override the Update operation of the DataContext object. Call the ExecuteDynamicUpdate method to generate the update SQL

  4. Call the SubmitChanges method of the DataContext object. Pass System.Data.Linq.ConflictMode. ContinueOnConflict to the method.

Answer: Answer is d

  1. Re-attach the SalesOrderDetail entities.

  2. Set the MergeOption of SalesOrderDetail to MergeOptions.OverwriteChanges.

  3. Set the MergeOption of SalesOrderDetail to MergeOptions.NoTracking.

  4. Call ObjectContext.ApplyCurrentValue.

  5. Call ObjectContext.ApplyOriginalValue.

Answer: Answer is a, e

  1. Set the Value property of the EntityReference of the Order entity.

  2. Call the Add method on the EntityCollection of the Order entity.

  3. Use the AddObject method of the ObjectContext to add both Order and Customer entities.

  4. Use the Attach method of the ObjectContext to add both Order and Customer entities.

Answer: Answer is a

  1. DataSet

  2. DataAdapter

  3. DataReader

  4. Data Services

Answer: Answer is a

  1. "Set the ClearBeforeFill property of the TableAdapter to false. "Use the Fill method of the TableAdapter.

  2. "Set the ClearBeforeFill property of the TableAdapter to false. "Use the GetData method of the TableAdapter to create a new DataTable.

  3. "Set the ClearBeforeFill property of the TableAdapter to true. "Use the Fill method of the TableAdapter to load additional customers.

  4. "Set the ClearBeforeFill property of the TableAdapter to true. "Use the GetData method of the TableAdapter to create a new DataTable.

Answer: Answer is a

  1. Encrypt stored passwords by using the RC2CryptoServiceProvider class.

  2. Encrypt stored passwords by using the TripleDESCryptoServiceProvider class

  3. Append a random salt to the password by using the RNGCryptoServiceProvider class. Encrypt stored passwords by using the RijndaelManaged class.

  4. Append a random salt to the password by using the RNGCryptoServiceProvider class. Hash stored passwords by using the SHA1CryptoServiceProvider class.

Answer: Answer is d

Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;