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. Apply the FunctionAttribute and ResultTypeAttribute to the stored procedure function. Use the GetResult <TElement> method to obtain an enumerator of the correct type.

  2. Apply the FunctionAttribute and ParameterAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

  3. Apply the ResultTypeAttribute to the stored procedure function and directly access the strongly typed object from the results collection.

  4. Apply the ParameterAttribute to the stored procedure function. Use the GetResult <TElement> method to obtain an enumerator of the correct type.

Answer: Answer is a

"CREATE procedure [dbo].[Product_Insert](@name varchar(50),@price float)
"CREATE procedure [dbo].[Product_Update](@id int, @name varchar(50), @price float)
"CREATE procedure [dbo].[Product_Delete](@id int)
"CREATE procedure [dbo].[Order_Insert](@productId int, @quantity int)
"CREATE procedure [dbo].[Order_Update](@id int, @quantity int,@originalTimestamp timestamp)
"CREATE procedure [dbo].[Order_Delete](@id int)

You create a Microsoft ADO.NET Entity Data Model (EDM) by using the Product and Order entities as shown in the exhibit. You need to map the Product and Order entities to the stored procedures. Which two procedures should you add to the @productId parameter? (Each correct answer presents part of the solution. Choose two.)

  1. Product_Delete

  2. Product_Update

  3. Order_Delete

  4. Order_Update

Answer: Answer is c, d

  1. Apply the virtual keyword to the entity properties.

  2. Apply the [Serializable] attribute to the entities.

  3. Apply the [DataContract(IsReference = true)] attribute to the entities.

  4. Apply the [DataContract(IsReference = false)] attribute to the entities.

Answer: Answer is c

  1. Run the edmgen.exe tool in FullGeneration mode.

  2. Run the edmgen.exe tool in FromSSDLGeneration mode.

  3. Use the Update Model Wizard in Visual Studio.

  4. Use the Generate Database Wizard in Visual Studio. Run the resulting script against a Microsoft SQL Server database.

Answer: Answer is d

  1. Function

  2. FunctionImport

  3. Dependent

  4. Association

  5. DefiningExpression

Answer: Answer is a, e

  1. Modify the application's Web.config file. Set the value for the customErrors element to Off.

  2. Modify the application's Web.config file. Set the value for the customErrors element to RemoteOnly

  3. Add the FaultContract attribute to the class that implements the data service.

  4. Add the ServiceBehavior attribute to the class that implements the data service.

Answer: Answer is d

  1. Data Source=localhost; Initial Catalog=MyDataBase; Integrated Security=SSPI; User Instance=True
  2. Data Source=.\SQLEXPRESS; Initial Catalog=MyDataBase; Integrated Security=True; User Instance=True
  3. Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\MyDatabase.mdf; Integrated Security=True; User Instance=True
  4. Data Source=SQLEXPRESS; AttachDbFilename=|DataDirectory|\App_Data\MyDatabase.mdf; Integrated Security=SSPI; User Instance=True
Answer: Answer is c

  1. Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI; Persist Security Info=false;
  2. Data Source=myServerAddress; Initial Catalog=myDataBase; Integrated Security=SSPI; Persist Security Info=true;
  3. Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword; Persist Security Info=false;
  4. Data Source=myServerAddress; Initial Catalog=myDataBase; User Id=myUsername; Password=myPassword; Persist Security Info=true;
Answer: Answer is a

  1. Attach

  2. AttachTo

  3. AddObject

  4. ApplyCurrentValues

Answer: Answer is c

  1. Translate

  2. ExecuteFunction

  3. ExecuteStoreQuery

  4. ExecuteStoreCommand

Answer: Answer is b

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.

;