ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> Microsoft Related >> ADO.NET
 
 


 

 
 Visual Basic interview questions  Visual Basic Interview Questions (615)
 C Sharp interview questions  C Sharp Interview Questions (722)
 ASP.NET interview questions  ASP.NET Interview Questions (1443)
 VB.NET interview questions  VB.NET Interview Questions (150)
 COM+ interview questions  COM+ Interview Questions (41)
 ADO.NET interview questions  ADO.NET Interview Questions (199)
 IIS interview questions  IIS Interview Questions (86)
 MTS interview questions  MTS Interview Questions (5)
 Crystal Reports interview questions  Crystal Reports Interview Questions (62)
 BizTalk interview questions  BizTalk Interview Questions (33)
 Dot Net interview questions  Dot Net Interview Questions (861)
 Exchange Server interview questions  Exchange Server Interview Questions (103)
 SharePoint interview questions  SharePoint Interview Questions (25)
 WCF interview questions  WCF Interview Questions (8)
 Microsoft Related AllOther interview questions  Microsoft Related AllOther Interview Questions (193)
Question
What are the differences between RAW, AUTO and Explicit
modes in retrieving data from SQL Server in XML format?
 Question Submitted By :: ADO.NET
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
RAW

The RAW mode takes the query result and transforms each row
in the result set into an XML element with a generic
identifier row as the element tag and the columns in the
SELECT as attributes.

AUTO

The AUTO mode returns query results in a simple, nested XML
tree. Each table in the FROM clause for which at least one
column is listed in the SELECT clause is represented as an
XML element. The columns listed in the SELECT clause are
mapped to the appropriate element's attributes. The columns
can be optionally mapped to subelements. The nesting of the
elements or hierarchy in the result set is based on the
order of tables identified by the columns specified in the
SELECT clause. The leftmost table will be the top element.
The second leftmost table (identified by columns in the
SELECT statement) will be nested within the top element, and
so on.

EXPLICIT

In EXPLICIT mode, you can explicitly define the shape of the
resulting XML tree. Using this mode requires that the
queries be written in a specific way, so that additional
information about the desired nesting is specified
explicitly as part of the query.
 
Is This Answer Correct ?    4 Yes 1 No
Shobana
 

 
 
 
Other ADO.NET Interview Questions
 
  Question Asked @ Answers
 
describe about the ado.net object model TCS 4
I am fresh graduate, trained in C# .net. How do i answer when interview ask me , Where do you see yourself within 5 years from now?   2
i want 2 pass values(enterd in textbox)to table in sql server without using stored procedure in c#.plz tell me code with an example. Softcon 5
How do we invoke queries from the application ? Microsoft 2
How to insert multiple records in asp .net from Gridview to Sql Database with out using loop condition ?   2
What is main five diffrent between Connected And Disconnected environment Wipro 14
How to call the SQL commands asynchronously in ADO.NET version 2.0 DELL 4
What is Debug.write does?   1
What are the attirbutes of DataSet? IBM 5
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, How do you check whether all the 10 records were present while updating the data(Which event and steps) and throw the exception. Fulcrum-Logic 2
suppose we using gridview contrl,with sqldatasource.in that for birth date how can we take validation contrl for dd/mm/yy formator how we assign regular expression for same TCS 9
What is the use of parameter object? Ksb 4
 
For more ADO.NET Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com