Discussion
Home ‣ Database ‣ XML and ADO.NET Comments
- Question
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.
- Correct Answer
- DTD.
- 1. 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
- 2. 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
- 3. The DTD begins with the word:
Options- A. #PCDATA.
- B. XML.
- C. DOCTYPE.
- D. HTTPS. Discuss
- 4. 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
- 5. XSLT processors evaluate each statement in the context of the match that has been made. That is, XSLT processors are:
Options- A. context oriented.
- B. procedural oriented.
- C. object oriented.
- D. relational oriented. Discuss
- 6. 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. Discuss
- 7. 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
- 8. 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
- 9. 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
- 10. 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
XML and ADO.NET problems
Search Results
Correct Answer: place the values of the columns as attributes in the resulting XML document.
Correct Answer: {item, action}.
Correct Answer: DOCTYPE.
Correct Answer: They have their own syntax.
Correct Answer: context oriented.
Correct Answer: With XML, all of the above are true.
Correct Answer: Process transactions
Correct Answer: confidence
Correct Answer: Too much data
Correct Answer: Data metadata
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.