How do you load data from XML file to a ORACLE table?

Correct Answer: An XSL sheet or a document may have duplicate elements and attributes Therefore, the XML namespaces define a way to distinguish between duplicate element types and attribute names An XML namespace is a collection of element type and attribute names It is a URI due to which any element type or attribute name in an XML namespace can be uniquely identified It consists of two parts : the name of the XML namespace and the local name eg: xmlns: h=?https://wwwabccom? After this, you can write ?? to associate the table with the declared namespace

Correct Answer: CDATA - (Unparsed) Character Data The term CDATA is used when you dont want some text data to be parsed by the XML parser A CDATA section starts with "":

Correct Answer: XML, Extensible Markup Language, is an open, text based markup language that provides structural and semantic information to data XML is a metalanguage that can be used to create other language It is used to structure and describe data that can be understood by other applications Using XML, we can separate the user interface from data Features of XML : - XML is a generalized markup language that means one can define his/her own tag sets - A valid XML document contains rules and is self-describing - The rules that are found in DTD allow the documents to be validated

Correct Answer: Web server handles client side and server side validations and helps to deliver web content that can be accessed through the Internet protocols Examples: Microsoft IIS (Internet Information Service) Apache web server from Apache Java web server Pramathi web server etc

Correct Answer: Web browser is a software application used to locate,retrieve and display content on the World Wide Web, including Web pages, images, videos and other files Examples : Microsoft Internet Expiorer , Mozilla Firefox , Google Chrome, Opers , Safari etc

Correct Answer: Parsing the XML document is the only way to validate the XML file Validation is done by either DOM parser or the SAX parser

Correct Answer: XML templates are XML files such as XHTML files XML templates includes the processing directives which affect how the template is rendered, and the template expressions which are substituted dynamically by various data

Correct Answer: XPath specifies the path in the XML document which has hierarchical elements XPath is used with XPointer and XSLT and parser

Correct Answer: SQL Server is having a fantastic feature to retrieve data persisted in the form of XML format The data in the XML format can be retrieved using FOR XML clause appending to the SELECT statement It offers 3 modes - ?FOR XML AUTO": Returns XML elements that are nested, based on which tables are listed in the "from" part of the query, and which fields are listed in the "select" part - "FOR XML RAW": Returns XML elements with the "row" prefix (ex: "") Each column in a table is represented as an attribute and null column values aren't included - "FOR XML EXPLICIT": Explicit mode is the most complex shaping method used in SQL Server 2000 It allows users to query a data source in such a way that the names and values of the returned XML are specified before the query batch is executed

Correct Answer: XAML is a markup language used to define dynamic or static UIs for NET applications Though Windows Vista would be used to design XAML UIs, they can be applied to Windows XP or Windows 2003 too XAML is similar to MVC in terms of the separation of the UI code from application logic XAML is bound to Windows Presentation foundation to build a UI in NET 30 and Windows Vista XAML Features: - XAML inherits all XML definitions and rules - It also contains HTML, XHTML and other markup languages for UI - Every XAML element represents a NET CLR class due to which working with XAML becomes simple - The application logic can be put in a separate file or be embedded in XAML file itself as XAML in conjunction with Windows Presentation Foundation model to provide the developers design a good UI in ASPNET - XAML files get compiled to BAML files which are smaller than XAML and easier to read which make them faster to load