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

"We are impressed by the caliber, depth, and breadth of the assessments provided by Interview Mocha. With Interview Mocha's online proctoring & powerful reports, we are able to hire quality candidates overcoming geographical barriers."

Megan Akhras, J'Excelle,Canada,
Co-founder & director
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);

Test details:

This ADO.Net online quiz test enables employers and recruiters to identify potential hires by evaluating their working skills and job readiness. For this reason, the emphasis is laid upon evaluating the knowledge of applied skills gained through real work experience, rather than theoretical knowledge.

Test Details: 20 minutes 

15 Application Questions

05 Theory Questions 


The combination o Application and Theory questions help to evaluate Technical as well as practical Skills of Candidates

Test description:

ADO .Net Online Test helps recruiters and hiring managers to validate the knowledge of applicant about the Ado.Net- Data Access Technology before an interview. Ado.Net is a set of classes which comes along with the Microsoft .Net Framework. It helps applications to access various types of data using same methodologies. ADO.Net provides a complete and comprehensive set of libraries for data access. It provides a bridge between front end controls and back-end database. This ADO .Net quiz is specially designed to check application, practical skills of an ADO.Net Expert – as per Industry Standards.

The ADO .Net assessment test contains questions on following Topics: 
 

  • SQL Command

  • Paging

  • Data Binding

  • Ordered List

  • Entity Designer

  • LINQ

  • GridView 

 
This ADO .Net skills test has been developed and reviewed by our experienced Subject Matter Experts (SME)s. Using powerful reporting, you can have a detailed analysis of the test results to help you make a better hiring decision and predict the candidate’s performance.

The test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, True or False.

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