ADO.NET Interview Questions and Answers (445) - Page 10

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

445 records found.

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

You are implementing an EDM. You need to add a definition to the data model that creates a logical relationship between a Product entity and a ProductCategory entity. Which type of definition should you add?

NOTE: This is objective type question, Please click question title for correct answer.

In your application course, information is stored in a Course table. Some courses are online and additional information about online courses is stored in an OnlineCourse table. You generate an ED Model from the database. In the resulting model the Course and OnlineCourse have a 1 to 0..1 relationship. You need to modify the model so that the OnlineCourse entity includes all the properties of the Course entity and can be used as a Course entity. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

In your application, information about all courses is stored in a Course table. Some courses are online and additional information about online courses is stored in an OnlineCourse table. All other courses are on campus and additional information about online courses is stored in an OnsiteCourse table. You generate an Entity Data Model from the database and then define inheritance relationships between the Course and OnlineCourse entities and the Course and OnsiteCourse entities. You need to ensure that application code is prevented from creating a Course entity directly. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your application database includes Person and OfficeAssignment tables. You need to add an entity named Instructor to an application Entity Data Model. The Instructor entity must include properties loaded from columns in both tables. Which type of mapping should you use?

NOTE: This is objective type question, Please click question title for correct answer.

Your application database includes a table named Person. You need to add an entity named Instructor to an application Entity Data Model. You need to map the Instructor entity to the Person table. However, only Person rows with a nonnull HireDate column should map.What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your application database includes Person and OfficeAssignment tables. You add an entity named Instructor to your Entity Data Model. You need to determine if you can map Instructor entity properties loaded from columns in both tables. Which conditions must be met to map columns from multiple tables to a single entity?

NOTE: This is objective type question, Please click question title for correct answer.

You generate an Entity Data Model from your application database. The resulting model includes an entity named Person. The Person entity type has two properties - HireDate and EnrollmentDate. You add entity types Instructor and Student. You need to modify the model to ensure the following: * All Person rows with a null EnrollmentDate and a nonnull HireDate must map to the Instructor type. * All Person rows with a nonnull EnrollmentDate and a null HireDate must map to the Instructor type. * Application code must be able to refer to both generated classes by using a common base class. What should you do? (Each correct answer presents part of the solution. Choose two.)

NOTE: This is objective type question, Please click question title for correct answer.

Your database includes the following stored procedure: CREATE PROCEDURE [dbo].[DeletePersonByID] @PersonIDint AS DELETE FROM Person WHERE PersonID = @PersonID; When you generate an Entity Data Model from the database, you import this stored procedure. You need to ensure that this stored procedure is called to delete a Person entity. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your database includes the following stored procedure: CREATE PROCEDURE dbo.GetNames AS SELECT CustomerID AS ID, RTRIM(LastName) + ', ' + FirstName AS Name FROM Customers When you generate an Entity Data Model from the database, you import this stored procedure. You need to modify the model to ensure that a method is added to the ObjectContext. The method must execute the stored procedure and return a type that represents the stored procedure result. What should you do

NOTE: This is objective type question, Please click question title for correct answer.

You are implementing an application that uses Entity Framework. The application database includes the following stored procedure: CREATE PROCEDURE [dbo].[DeletePersonByID] @PersonIDint AS DELETE FROM Person WHERE PersonID = @PersonID; You add a Function element to the storage model that references this stored procedure. You need to complete the Entity Data Model configuration to ensure that this stored procedure is called to delete a Person entity. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You need to use Microsoft Visual Studio 2010 to create LINQ to SQL entity classes and associations from an existing database. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your database includes a stored procedure named DeletePersonByID. You use the Entity Designer to add this stored procedure as a LINQ to SQL DataContext method. You need to ensure that the DataContext uses this stored procedure to delete a Person row when the SubmitChanges method is called after the corresponding Person entity is marked for deletion. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your database includes a stored procedure named GetStudentGrade. You use the Entity Designer to add this stored procedure as a LINQ to SQL data context method. You need to configure the data context to return an existing entity class named StudentGrade when the stored procedure method is called. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

Your LINQ to SQL data model includes Customer and Order entities. You add an association to relate these entities. You need to configure the association to enforce the following requirements: * Each Order must have a single Customer associated with it. * A Customer can have zero or more associated Orders entities. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use the Entity Data Model Wizard to generate an Entity Data Model from an application database. You need to add validation code to entity classes. The code must meet the following requirements: * Validation code should not be affected if you update the model from the database. * Using the validation code should require the least amount of developer effort. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use the Entity Data Model Wizard to generate an Entity Data Model from an application database. An entity type named Student includes a property named EnrollmentDate. You need to add code that will execute after the EnrollmentDate property is reset. The code should not be affected if you update the model from the database. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

You use the Entity Data Model Wizard to generate an Entity Data Model (EDM) from an application database. You need to write a debugging method that allows you to dump information about the current state of entity instances. The method should output all original property values and compare with current property values. Which class should you use?

NOTE: This is objective type question, Please click question title for correct answer.

You use the Entity Data Model Wizard to generate an Entity Data Model from an application database. You add a class named BaseEntity. You need to ensure that all entity classes extend BaseEntity and not ObjectEntity. You also need to ensure that your changes are not overwritten if you update the model from the database. Your effort should be minimal. What should you do?

NOTE: This is objective type question, Please click question title for correct answer.

you work as application developer in X info inc. the company uses .Net framework 4.0 which of the following modes will you use in Edmgen.exe command line tool to create a source code file that contains the view generated from the .csdl,.ssdl and .msl files?

NOTE: This is objective type question, Please click question title for correct answer.

you work as application developer in X info inc. the company uses .Net framework 4.0 which of the following EDM tool will you use to generate a conceptual model from existing database ?

NOTE: This is objective type question, Please click question title for correct answer.

1
...
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
...
23

More ADO.NET Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

GooglePlus

StumbleUpon

Delicious

Reddit

Email

Bookmark It

Interview Questions and Answers Categories

.NET Certifications

ASP.NET Web API

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

Interview Questions

Mobile Development

MSBI (SSIS, SSRS, SSAS)

News and Community

Product Reviews

Project Management

Regular Expressions

Web Services, Remoting