ADO .Net Online Quiz Test

Topics covered

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

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

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.

This pre-employment test is useful for hiring:
  • Senior .Net developer- Ado .Net

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

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

Ado.Net Test

Question #1 of 3

Which statements are true regarding entity data model - EDM?

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

    • 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 #2 of 3

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

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

    • 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 #3 of 3

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?

    • 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);

SAMPLE REPORT
Candidate Name: David Messi Test Date: 28-May-2014
Test Name: Ado.Net Test Test Start Time: 13.30

Score: 18 Out Of 20

Percentage: 90

Result: PASS

passing score image
SECTION PERFORMANCE
Section Name FAIL PASS
ADO.NET with C#
Score: 18/20
STRENGTH AND WEAKNESS
Strength ADO.NET with C#
Weakness -
* Note: If score <= 40 then its a Weakness. If score >= 80 then its a Strength.
ONLINE PROCTORING
0%
10 20 30 40 50 60 70 80 90 100%
Tolerable Limit Not acceptable
Window Violation: 0 | Time Violation: 0 secs
CANDIDATE DETAILS
Gender : Male Phone Number : +1-541-754-3010
Total Experience (Years) : 3 Total Experience (Months) : 5
Skill Set : ADO.NET with C# Current Employer : Interview Mocha
Current Job Title : Solution Architect Current Salary : 600.00
Expected Salary : 1000000.00 Current Location : Chicago

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo

How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • hexaware
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.

SIGN UP FOR FREE

Schedule a Demo