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

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 create an XmlReader to read the following XML fragment: <book genre="non-fiction" ISBN="0-735622-77-9"> <title>MCTS Self-Paced Training Kit (Exam 70-536): Microsoft .NET Framework 2.0 Application Development Foundation</title> <pages>930</pages> </book> You add code to position the XmlReader on the pages start tag. You need to read the value given by the pages element. Which XmlReader method should you use?

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

You are creating an application that performs contact management. You load customer information from the following XML to an XElement object named customersRootElement: <customers> <customer id="7" phone="555-555-1211"> <name firstName = "Thomas" lastName = "Jensen"/> <address street="12 Willow Way" city="Treeland" state="NJ" zip="14322" /> </customer> <customer id="8" phone="555-555-1213"> <name firstName = "Henrick" lastName = "Jensen"/> <address street="12 Willow Way" city="Treeland" state="NJ" zip="14322" /> </customer> </customers> You need to retrieve the customer element with the id 7. Which code segment do you use?

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

You are creating an application that performs contact management. You load customer information from the following XML to an XElement object named xElement: <customers> <customer id="7" phone="555-555-1211"> <name firstName = "Thomas" lastName = "Jensen"/> <address street="12 Willow Way" city="Treeland" state="NJ" zip="14322" /> </customer> <customer id="8" phone="555-555-1213"> <name firstName = "Henrick" lastName = "Jensen"/> <address street="12 Willow Way" city="Treeland" state="NJ" zip="14322" /> </customer> </customers> You need to use XPATH retrieve the customer element with the id 8. Which code segment do you use?

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

You create the following WCF Data Service: public class Northwind : DataService<NorthwindEntities> { public static void InitializeService(DataServiceConfiguration config) { config.SetEntitySetAccessRule("Orders", EntitySetRights.AllRead); } } You need to retrieve all Orders entities. Which URI should you use?

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

You create the following WCF Data Service: public class Northwind : DataService<NorthwindEntities> { public static void InitializeService(DataServiceConfiguration config) { config.SetEntitySetAccessRule("Customers", EntitySetRights.AllRead); } } You need to retrieve the Customer entity with the key ALFKI. Which URI should you use?

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

You create the following WCF Data Service: public class Northwind : DataService<NorthwindEntities> { public static void InitializeService(DataServiceConfiguration config) { config.SetEntitySetAccessRule("Customers", EntitySetRights.AllRead); config.SetEntitySetAccessRule("Order_Details", EntitySetRights.AllRead); config.SetEntitySetAccessRule("Orders", EntitySetRights.AllRead); } } The Customer entity includes a property named Orders that returns related Order entities. You need to retrieve all Orders entities associated with the Customer entity with the key ALFKI. Which URI should you use?

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

You create the following WCF Data Service: public class Northwind : DataService<NorthwindEntities> { ... [WebGet] public IQueryable<Order> GetOrdersByCity(string city) { ... } } You need to retrieve the entities returned by the GetOrdersByCity service operation for the city Redmond. Which URI should you use?

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

You are implementing a WCF Data Service client application. You want to query the data service using LINQ and strongly typed objects. What should you do?

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

You are implementing a WCF Data Service client application. You need to use Visual Studio to generate WCF Data Service client library classes. What should you do?

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

You are implementing a WCF Data Service client application. You generate WCF Data Service client library classes, including a class that extends DataServiceContext named NorthwindEntities. NorthwindEntities includes a property named Orders that gives Order entities. You need to retrieve the Order entity with OrderID 7. Which code segment should you use?

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

You are implementing a WCF Data Service client application. You generate WCF Data Service client library classes, including a class that extends DataServiceContext named NorthwindEntities. NorthwindEntities includes a property named Orders that gives Order entities. You need to retrieve Order entities and access the HTTP response code if the request fails. What should you do?

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

You use a SqlCommand command to execute the following stored procedure: CREATE PROCEDURE dbo.InsertCustomer ( @companyName NVARCHAR(40), @contactName NVARCHAR(30) ) AS INSERT INTO dbo.Customers (CompanyName, ContactName) VALUES (@companyName, @contactName) RETURN @@IDENTITY You must retrieve the return value of the stored procedure. What should you do?

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

You populate a DataSet with DbDataAdapter. After you update the DataSet, you must propagate these changes back to the data source. What should you do?

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

You must update a table by using a SqlCommand to execute a stored procedure named UpdateOrder. What should you do?

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

You must choose the most efficient method to copy many thousands of rows in a DataTable to a table in a Microsoft SQL Server database. What should you do?

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

Your application database includes the table Annotations. This table includes the following columns: * An automatically generated integer identity column named AnnotationID * A column of type varchar named AnnotationText * A column of type datetime named Date You must write a statement to insert a row into this table with parameter values @text and @date. Which statement should you use?

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

Your Microsoft SQL Server database includes the following stored procedure: CREATE PROCEDURE dbo.DeleteExpiredAnnotations AS DELETE FROM Annotations WHERE Date < DATEADD(month, -6, GETDATE()) GO You must add code to use a SqlConnection named connection to call this stored procedure and get the number of rows deleted. Which code segment should you use?

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

Your Microsoft SQL Server application database includes a table named Orders. This table includes a primary key column named OrderID and a column named Status. You must write a statement to set the Status column to the value of a parameter named @status for the row with the OrderID column matching the value of a parameter named @orderID. Which statement should you use?

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

Your application accesses a table named Orders from a Microsoft SQL Server database. The Orders table includes a primary key. You use DbDataAdapter to fill a DataTable with rows selected from the Orders table. You must configure the DbDataAdapter so that you can use it to update the Orders table with changes that your application makes to the DataTable. What should you do?

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

You use DataContext to execute a LINQ query against a database. You make changes to the values in the returned result set. You must propagate these changes to the database. What should you do?

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

1
...
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
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