logo

CuriousTab

CuriousTab

Discussion


Home Database XML and ADO.NET Comments

  • Question
  • With XML:


  • Options
  • A. views are not limited to one multi-valued path only.
  • B. documents can automatically be generated from database data only.
  • C. database data can automatically be extracted from XML documents only.
  • D. With XML, all of the above are true.

  • Correct Answer
  • With XML, all of the above are true. 


  • XML and ADO.NET problems


    Search Results


    • 1. An XML component that defines the structure of a document is known as a(n):

    • Options
    • A. DOCTYPE.
    • B. DTD.
    • C. #PCDATA.
    • D. HTML Stylesheet.
    • Discuss
    • 2. The expression FOR XML RAW tells SQL Server to:

    • Options
    • A. place the values of the columns as attributes in the resulting XML document.
    • B. place the values of the columns into elements rather than attributes.
    • C. place some columns into elements and others into attributes.
    • D. None of the above is correct.
    • Discuss
    • 3. The XSLT processor copies the elements of the stylesheet until it finds a command in the format:

    • Options
    • A. SELECT ... FROM ... WHERE.
    • B. {item, action}.
    • C. {for-each select}.
    • D. <HTML>...<\HTML>.
    • Discuss
    • 4. The DTD begins with the word:

    • Options
    • A. #PCDATA.
    • B. XML.
    • C. DOCTYPE.
    • D. HTTPS.
    • Discuss
    • 5. Which of the following statements is not true about XML Schemas:

    • Options
    • A. They are used to define the content and structure of data.
    • B. They define a set of symbols and the relationships of those symbols.
    • C. They are themselves XML documents.
    • D. They have their own syntax.
    • Discuss
    • 6. Business Intelligence (BI) systems do not obtain their data by which of the following means?

    • Options
    • A. Read and process data from an operational database
    • B. Process transactions
    • C. Process extracts from operational databases
    • D. Process data purchased from data vendors
    • Discuss
    • 7. We have Market Basket data for 1,000 rental transactions at a Video Store. There are four videos for rent -- Video A, Video B, Video C and Video D. The probability that Video D will be rented given that Video C has been rented is known as ________ .

    • Options
    • A. the basic probability
    • B. support
    • C. lift
    • D. confidence
    • Discuss
    • 8. The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

    • Options
    • A. Dirty data
    • B. Inconsistent data
    • C. Too much data
    • D. Non-integrated data
    • Discuss
    • 9. Which of the following is not a component of a data warehouse?

    • Options
    • A. Data extraction/cleaning/preparation programs
    • B. Data warehouse data
    • C. Data metadata
    • D. None of the above are data warehouse components.
    • Discuss
    • 10. We have been given access to the company's operational data, and have been asked to produce a report. We discover that some of the data we need are in an SQL server database while other needed data are in a separate Oracle database. This is an example of ________ .

    • Options
    • A. dirty data
    • B. inconsistent data
    • C. non-integrated data
    • D. a "wrong format" problem
    • Discuss


    Comments

    There are no comments.

Enter a new Comment