Explore topic-wise MCQs in Database.

This section includes 35 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

With XSLT, you specify a procedure for materializing document elements.

A. 1
B.
Answer» C.
Discussion
2.

XML Schemas are XML documents.

A. 1
B.
Answer» B.
Discussion
3.

Schemas consist of properties and methods

A. 1
B.
Answer» C.
Discussion
4.

The most popular way to materialize XML documents is to use XSLT.

A. 1
B.
Answer» B.
Discussion
5.

XML Schema is used to define the content, structure and format of documents.

A. 1
B.
Answer» C.
Discussion
6.

SOAP is now just a name, not an acronym.

A. 1
B.
Answer» B.
Discussion
7.

XML uses the same terms with the same meanings as terms in the database world.

A. 1
B.
Answer» C.
Discussion
8.

With XML, document structure, content and format are all defined within one document.

A. 1
B.
Answer» C.
Discussion
9.

Stylesheets are used by XSLT to indicate how to transform the elements of the XML document into another format.

A. 1
B.
Answer» B.
Discussion
10.

XML technology is a hybrid of document processing and database processing.

A. 1
B.
Answer» B.
Discussion
11.

You can validate an XML Schema document against its schema, just as you would any other XML document.

A. 1
B.
Answer» B.
Discussion
12.

FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document.

A. 1
B.
Answer» C.
Discussion
13.

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

A. context oriented.
B. procedural oriented.
C. object oriented.
D. relational oriented.
Answer» B. procedural oriented.
Discussion
14.

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

A. not-type-valid.
B. type-valid.
C. an HTML document.
D. None of the above is correct.
Answer» B. type-valid.
Discussion
15.

Documents that have no DTD are by definition not-type-valid.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
16.

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

A. type-invalid.
B. type-valid.
C. not-type-valid.
D. an HTML document.
Answer» C. not-type-valid.
Discussion
17.

It took the popularity of the Internet to realize that database processing and document processing need each other.

A. 1
B.
C. 1
D.
Answer» B.
Discussion
18.

XML is:

A. a subset of SGML only.
B. a hybrid of document processing and database processing only.
C. a standardized yet customizable way to describe the content of documents only.
D. XML is all of the above.
Answer» E.
Discussion
19.

XML Schemas consist of:

A. properties and methods.
B. elements and attributes.
C. structure and data.
D. tables and relationships.
Answer» C. structure and data.
Discussion
20.

What is not true about XML?

A. Web page display is the most important application of XML.
B. With XML, there is a clear separation between document structure, content and materialization.
C. XML is more powerful than HTML.
D. XML documents have two sections.
Answer» B. With XML, there is a clear separation between document structure, content and materialization.
Discussion
21.

XSLT processors are context-oriented; each statement is evaluated in the context of the match that has been made.

A. 1
B.
Answer» B.
Discussion
22.

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

A. XHTML.
B. XML.
C. SGML.
D. None of the above is correct.
Answer» D. None of the above is correct.
Discussion
23.

If a document does not conform to the DTD, it is a bad XML document.

A. 1
B.
Answer» C.
Discussion
24.

What is not true about SOAP?

A. SOAP originally meant Simple Object Access Protocol.
B. SOAP was defined as an XML-based standard for providing remote procedure calls over the Internet.
C. SOAP now is just a name, not an acronym
D. SOAP was an early form of XML.
Answer» E.
Discussion
25.

Web page display is the most important application of XML.

A. 1
B.
Answer» C.
Discussion
26.

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.

A. 1
B.
C. 1
D.
Answer» C. 1
Discussion
27.

The DTD defines the structure of XML documents.

A. 1
B.
Answer» B.
Discussion
28.

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

A. SOAP
B. SGML
C. SQL
D. ADO
Answer» B. SGML
Discussion
29.

With XML:

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.
Answer» E.
Discussion
30.

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

A. DOCTYPE.
B. DTD.
C. #PCDATA.
D. HTML Stylesheet.
Answer» C. #PCDATA.
Discussion
31.

SOAP uses HTTP as its only transport mechanism.

A. 1
B.
C. 1
D.
Answer» C. 1
Discussion
32.

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

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.
Answer» E.
Discussion
33.

To eliminate definition duplication, XML Schemas define:

A. an intersection table.
B. global elements.
C. a normalized definition table.
D. None of the above is correct.
Answer» C. a normalized definition table.
Discussion
34.

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

A. DTD.
B. XSLT.
C. HTML.
D. SOAP.
Answer» C. HTML.
Discussion
35.

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

A. SELECT ... FROM ... WHERE.
B. {item, action}.
C. {for-each select}.
D. <HTML>...<\HTML>.
Answer» C. {for-each select}.
Discussion