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

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 storing custom Car objects in a data table whose DataView property displays a filtered list of Car objects, filtered on Make Of The Cars.If you change the make of one of the Car objects, you want to ensure that the filter will dynamically update. What must you do to be assured that the filter will detect the change done to your custom Car object?

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

You are storing custom Car objects in a data table that will be serialized to a file. After serializing to a binary file called cars.bin, you open the file with a binary editor and notice that XML is in the file.Which setting can you use to ensure that you will create a binary file without embedded XML?

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

You are calling a stored procedure in SQL Server 2008 that returns a UDT as an output parameter. This UDT, called MyCompanyType, was created by your company. The UDT has a method called GetDetails that you want to execute in your client application. What must you do to execute the method? (Each correct answer presents part of the solution. Choose three.)

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

Given an XML file, you want to run several queries for data in the file based on filter criteria the user will be entering for a particular purpose. Which class would be more appropriate for these queries on the file?

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

Every day, you receive hundreds of XML files. You are responsible for reading the file to retrieve sales data from the file and store it into a SQL database. Which class would be more appropriate for these queries on the file?

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

You have a service that receives a very large XML-based history file once a month. These files can be up to 20GB in size, and you need to retrieve the header information that contains the history date range and the customer information on which this file is based.Which class would be more appropriate to retrieve the data in these files?

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

Given an XML file, you want to run several queries for data using LINQ to XML. Which class would be most appropriate for these queries on the file?

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

In your code, you have a string variable that contains XML. Which method can you use to convert this into an XDocument class so you can run LINQ to XML queries?

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

The URI to your WCF data service is http://www.northwind.com/DataServices.svc. What can you add to the end of the URI to retrieve only a list of Order entities for the Customer entity whose CustomerID is 'BONAP'?

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

When working with the Entity Framework, which method do you execute to send changes back to the database?

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

You have just set up the Entity Framework cascading delete, and you are now trying to use it, but you keep getting an UpdateException. What is the most logical cause of this exception?

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

n ADO.NET, which class can start an explicit transaction to update a SQL Server database?

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

In the System.Transaction namespace, which class can start an explicit promotable transaction to update a SQL Server database?

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

You are working with an ObjectContext object that targets the mainframe and another ObjectContext object that targets SQL Server. When it's time to save the changes, you want all changes to be sent to the mainframe and to SQL Server as one transaction. How can you accomplish this?

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

You want to set up a primary key on a column. Which properties on the data column must be set?

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

When working with a data set that has data in it, you decide you want to store the schema, but not the data, of the data set to a file so you can share the schema with other users.Which method must you execute to store the schema?

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

You want to execute a SQL insert statement from your client application, so you set the CommandText property of the command object and open the connection.Which method will you execute on the command?

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

You ran a LINQ to SQL query to retrieve the products that you are going to mark as discontinued. After running the query, you looped through the returned products and set their Discontinued property to true. What must you do to ensure that the changes go back to the database?

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

You are using VS 2010 to develop a data-centric application. You need to start the workflow to create the following items: * Classes that provide a conceptual data model implementation * A mapping between these classes and a specific database implementation What should you do?

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

You are implementing an Entity Data Model . You need to add a definition to designate that a set can contain an Employee entity type and subtypes Manager and SalesPerson. Which type of definition should you add?

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

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
...
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