Xml And Ado.net(Engineering > Computer Science And Engineering > Database System ) Questions and Answers

Question 1. The XSLT processor copies the elements of the stylesheet until it finds a command in the format:
  1.    {for-each select}
  2.    SELECT ... FROM ... WHERE
  3.    < HTML >...< / HTML >
  4.    {item, action}
Explanation:-
Answer: Option D. -> {item, action}

Question 2. Which of the following statements is not true about XML Schemas:
  1.    They define a set of symbols and the relationships of those symbols.
  2.    They have their own syntax.
  3.    They are used to define the content and structure of data.
  4.    They are themselves XML documents.
Explanation:-
Answer: Option B. -> They have their own syntax.

Question 3. What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?
  1.    SOAP
  2.    ADO
  3.    SGML
  4.    SQL
Explanation:-
Answer: Option A. -> SOAP

Question 4. The most popular way to materialize XML documents is to use:
  1.    XSLT
  2.    SOAP
  3.    DTD
  4.    HTML
Explanation:-
Answer: Option A. -> XSLT

Question 5. With XML:
  1.    database data can automatically be extracted from XML documents only.
  2.    documents can automatically be generated from database data only.
  3.    views are not limited to one multi-valued path only.
  4.    All of these
Explanation:-
Answer: Option D. -> All of these

Question 6. What is not true about SOAP?
  1.    SOAP now is just a name, not an acronym
  2.    SOAP was an early form of XML.
  3.    SOAP originally meant Simple Object Access Protocol.
  4.    SOAP was defined as an XML-based standard for providing remote procedure calls over the Internet.
Explanation:-
Answer: Option B. -> SOAP was an early form of XML.

Question 7. To eliminate definition duplication, XML Schemas define:
  1.    A normalized definition table.
  2.    An intersection table.
  3.    Global elements.
  4.    None of these
Explanation:-
Answer: Option C. -> Global elements.

Question 8. The expression FOR XML RAW tells SQL Server to:
  1.    Place the values of the columns as attributes in the resulting XML document.
  2.    None of these
  3.    Place the values of the columns into elements rather than attributes.
  4.    Place some columns into elements and others into attributes.
Explanation:-
Answer: Option A. -> Place the values of the columns as attributes in the resulting XML document.

Question 9. ADO.NET provides the ability to create and process in-memory databases called:
  1.    Views
  2.    Datasets
  3.    Relations
  4.    Tables
Explanation:-
Answer: Option B. -> Datasets

Question 10. XML Schemas consist of:
  1.    Properties and methods.
  2.    Tables and relationships.
  3.    Structure and data.
  4.    Elements and attributes.
Explanation:-
Answer: Option D. -> Elements and attributes.