Database

Database

XML and ADO.NET has 40 Questions

SOAP uses HTTP as its only transport mechanism.

True
False
The XSLT processor copies the elements of the stylesheet until it finds a command in the format:

SELECT ... FROM ... WHERE.
{item, action}.
{for-each select}.
<HTML>...<HTML>.
The DTD defines the structure of XML documents.

True
False
What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?

SOAP
SGML
SQL
ADO
If a document does not conform to the DTD, it is a bad XML document.

True
False
Which of the following statements is not true about XML Schemas:

They are used to define the content and structure of data.
They define a set of symbols and the relationships of those symbols.
They are themselves XML documents.
They have their own syntax.
XSLT processors are context-oriented; each statement is evaluated in the context of the match that has been made.

True
False
The most popular way to materialize XML documents is to use:

DTD.
XSLT.
HTML.
SOAP.
With XML:

views are not limited to one multi-valued path only.
documents can automatically be generated from database data only.
database data can automatically be extracted from XML documents only.
With XML, all of the above are true.
Web page display is the most important application of XML.

True
False
To eliminate definition duplication, XML Schemas define:

an intersection table.
global elements.
a normalized definition table.
None of the above is correct.
It took the popularity of the Internet to realize that database processing and document processing need each other.

True
False
What is not true about SOAP?

SOAP originally meant Simple Object Access Protocol.
SOAP was defined as an XML-based standard for providing remote procedure calls over the Internet.
SOAP now is just a name, not an acronym
SOAP was an early form of XML.
You can validate an XML Schema document against its schema, just as you would any other XML document.

True
False
XML Schemas consist of:

properties and methods.
elements and attributes.
structure and data.
tables and relationships.
XML technology is a hybrid of document processing and database processing.

True
False
The expression FOR XML RAW tells SQL Server to:

place the values of the columns as attributes in the resulting XML document.
place the values of the columns into elements rather than attributes.
place some columns into elements and others into attributes.
None of the above is correct.
The most popular way to materialize XML documents is to use XSLT.

True
False
ADO.NET provides the ability to create and process in-memory databases called:

views.
relations.
tables.
datasets.
SOAP is now just a name, not an acronym.

True
False
An XML component that defines the structure of a document is known as a(n):

DOCTYPE.
DTD.
#PCDATA.
HTML Stylesheet.
Documents that have no DTD are by definition not-type-valid.

True
False
HTML is an application of a more robust document markup language called:

XHTML.
XML.
SGML.
None of the above is correct.
FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document.

True
False
XSLT processors evaluate each statement in the context of the match that has been made. That is, XSLT processors are:

context oriented.
procedural oriented.
object oriented.
relational oriented.
With XSLT, you specify a procedure for materializing document elements.

True
False
The DTD begins with the word:

#PCDATA.
XML.
DOCTYPE.
HTTPS.
XML Schema is used to define the content, structure and format of documents.

True
False
What is not true about XML?

Web page display is the most important application of XML.
With XML, there is a clear separation between document structure, content and materialization.
XML is more powerful than HTML.
XML documents have two sections.
Schemas consist of properties and methods

True
False
What is not true about XSLT?

XSLT is a declarative transformation language.
XSLT uses a set of rules that govern how a document is to be materialized is created.
XSLT uses a set of procedures that specify how a document is to be programmed.
XSLT is used to transform the input document into another document.
Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.

True
False
If the XML data instance conforms to the DTD, the document is said to be:

type-invalid.
type-valid.
not-type-valid.
an HTML document.
With XML, document structure, content and format are all defined within one document.

True
False
XML is:

a subset of SGML only.
a hybrid of document processing and database processing only.
a standardized yet customizable way to describe the content of documents only.
XML is all of the above.
XML Schemas are XML documents.

True
False
The document that is used by XSLT to indicate how to transform the elements of the XML document to another format is a(n):

HTML page.
DOCTYPE procedure.
stylesheet.
stored procedure.
XML uses the same terms with the same meanings as terms in the database world.

True
False
If an XML document does not have a DTD, then by definition it is:

not-type-valid.
type-valid.
an HTML document.
None of the above is correct.
Stylesheets are used by XSLT to indicate how to transform the elements of the XML document into another format.

True
False