Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

ADO .Net Online Quiz Test

Topics Covered

  • SQL Command
  • Paging
  • Data Binding
  • Ordered List
  • Entity Designer
  • LINQ
  • GridView

Useful for hiring

  • Senior .Net developer- Ado .Net
  • Developer- Ado .Net
  • WPF .Net Developer - ADO.Net

Start hiring job-fit candidates using this assessment

GET A DEMO

"Our recruiters no longer rely only on the telephonic interviews. We shortlist candidates based on assessment reports. The detailed test reports provide skill wise analysis of each candidate. This has helped our clients reduce their time to hire by 60%."

Vipin Sharma, Mobile Programming,
General Manager HR & Recruitement
Question

Which statements are true regarding entity data model - EDM?

Note: There can be multiple correct answers to this question.

Answer
    • Inheritance in the EDM is similar to inheritance for classes in object-oriented programming languages.

    • In a conceptual model, you can build inheritance hierarchies in which a derived type inherits from another derived type.

    • You can build inheritance hierarchies in which a derived type inherits from more than one type.

    • The EDM supports a set of abstract primitive data types (such as String, Boolean, Int32, and so on) that are used to define properties in a conceptual model.

    • The EDM supports collections of primitive data types.

Question

Which statement is true regarding sorting and filtering data in DataView?

Note: There can be multiple correct answers to this question.

Answer
    • You can use the ApplyDefaultSort property to automatically create a sort order, in descending order.

    • You can use the Sort property to specify single or multiple column sort orders and include ASC (ascending) and DESC (descending) parameters.

    • You can use the RowStateFilter property to specify which row versions to view.

    • ApplyDefaultSort only applies when the Sort property is not null

    • You can use the RowFilter property to specify subsets of rows based on their column values

Question

How to create a view that shows all the products where the number of units in stock is less than or equal to the reorder level, sorted first by supplier ID and then by product name?

Answer
    • DataView prodView = (DataView)(prodDS.Tables["Products"],
         "UnitsInStock <= ReorderLevel",
         "SupplierID, ProductName",
         DataViewRowState.Rows);

    • DataView prodView = new DataView(prodDS.Tables["Products"],
         "UnitsInStock <= ReorderLevel",
         "SupplierID, ProductName",
         DataViewRowState.CurrentRows);

    • DataView prodView = new DataView(prodDS.Tables["Products"],
         "UnitsInStock <= ReorderLevel",
         "SupplierID, ProductName",
         DataViewRowState.AllRows);

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at support@interviewmocha.com to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...
GET A DEMO

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates

GET A DEMO