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

<EntityType Name="ProductCategory">
<Key>
<PropertyRef Name="ProductCategoryID" />
</Key>
<Property Name="ProductCategoryID" Type="int" Nullable="false" StoreGeneraedPattern="Identity" />
<Property Name="ParentProductCategoryID" Type="int" />
<Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
...
</EntityType>

You need to provide two entity-tracking fields: "rowguid that is automatically generated when the entity is
created "ModifiedDate that is automatically set whenever the entity is updated Which code fragment should you
add to the .edmx file?

  1. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/>
    <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>
  2. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/>
    <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/>
  3. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Identity"/>
    <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Computed"/>
  4. <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" StoreGeneratedPattern="Computed"/>
    <Property Name="ModifiedDate" Type="timestamp" Nullable="false" StoreGeneratedPattern="Identity"/>
Answer: Answer is c

  1. Configure IIS to require basic authentication.

  2. Configure IIS to allow anonymous access.

  3. Configure IIS to require Windows authentication.

  4. Enable the WCF Authentication Service.

  5. Modify the Data Services service to use a Microsoft ASP.NET membership provider.

Answer: Answer is b, e

  1. an X-HTTP-Method header as part of a POST request

  2. an X-HTTP-Method header as part of a GET request

  3. an HTTP ContentType header as part of a POST request

  4. an HTTP ContentType header as part of a GET request

Answer: Answer is a

  1. from details in dataContext.Order_Details
    group details by details.OrderID into g join order in dataContext.Orders on g.Key equals order.OrderID
    select new { OrderID = order.OrderID, CustomerID = order.CustomerID, TotalAmount = g.Sum(od => od.
    UnitPrice * od.Quantity) }
  2. dataContext.Order_Details.GroupJoin(dataContext.Orders, d => d.OrderID, o => o.OrderID, (dts, ord) =>
    new { OrderID = dts.OrderID, CustomerID = dts.Order.CustomerID, TotalAmount = dts.UnitPrice * dts.
    Quantity } )
  3. from order in dataContext.Orders
    group order by order.OrderID into g join details in dataContext.Order_Details on g.Key equals details.
    OrderID
    select new { OrderID = details.OrderID, CustomerID = details.Order.CustomerID, TotalAmount = details.
    UnitPrice * details.Quantity }
  4. dataContext.Orders.GroupJoin(dataContext.Order_Details, o => o.OrderID, d => d.OrderID, (ord, dts) =>
    new { OrderID = ord.OrderID, CustomerID = ord.CustomerID, TotalAmount = dts.Sum(od => od.UnitPrice *
    od.Quantity) } )
Answer: Answer is a, d

  1. from row in ds.Tables[0].AsEnumerable()
    where (string)row["ContactName"] != null
    select row;
  2. from row in ds.Tables[0].AsEnumerable()
    where row.Field <string>("ContactName") != null
    select row;
  3. from row in ds.Tables[0].AsEnumerable()
    where !row.IsNull((string)row["ContactName"])
    select row;
  4. from row in ds.Tables[0].AsEnumerable()
    where !Convert.IsDBNull(row.Field <string>("Region"))
    select row;
Answer: Answer is b

  1. ANYELEMENT

  2. EXCEPT

  3. EXISTS

  4. IN

Answer: Answer is c

  1. EntityCommand

  2. EntityConnection

  3. EntityTransaction

  4. EntityDataReader

Answer: Answer is a

  1. Set the SqlDbType of SqlParameter to Udt.

  2. Set the SqlDbType of SqlParameter to Variant.

  3. Set the ParameterDirection of SqlParameter to Output.

  4. Set the SqlDbType of SqlParameter to Structured. Set the TypeName of SqlParameter to Udt.

Answer: Answer is d

  1. Set the parameter's SqlDbType to Binary.

  2. Set the parameter's SqlDbType to Variant.

  3. Set the parameter's SqlDbType to Udt. Set the parameter's UdtTypeName to GEOMETRY.

  4. Set the parameter's SqlDbType to Structured. Set the parameter's TypeName to GEOMETRY.

Answer: Answer is c

<ApplicationMenu>
<MenuItem name="File">
<MenuItem name="New">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Open">
<MenuItem name="Project" />
<MenuItem name="Web Site" />
</MenuItem>
<MenuItem name="Save" />
</MenuItem>
<MenuItem name="Edit">
<MenuItem name="Cut" />
<MenuItem name="Copy" />
<MenuItem name="Paste" />
</MenuItem>
<MenuItem name="Help">
<MenuItem name="Help" />
<MenuItem name="About" />
</MenuItem>
</ApplicationMenu>

The application queries the XML fragment by using the XmlDocument class. You need to select all the descendant elements of the MenuItem element that has its name attribute as File. Which XPath expression should you use?

  1. //*[@name='File'][name()='MenuItem']

  2. /ApplicationMenu/MenuItem['File']//MenuItem

  3. /ApplicationMenu/MenuItem/descendant::MenuItem['File']

  4. /ApplicationMenu/MenuItem[@name='File']/descendant::MenuItem

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.

;