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.

Schemas consist of properties and methods%!

A. True
B. False
Answer» C.
Discussion
2.

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

A. True
B. False
Answer» B. False
Discussion
3.

Web page display is the most important application of XML.%!

A. True
B. False
Answer» C.
Discussion
4.

SOAP is now just a name, not an acronym.%!

A. True
B. False
Answer» B. False
Discussion
5.

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

A. True
B. False
Answer» C.
Discussion
6.

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

A. True
B. False
Answer» C.
Discussion
7.

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

A. True
B. False
Answer» B. False
Discussion
8.

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

A. True
B. False
Answer» B. False
Discussion
9.

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

A. True
B. False
Answer» C.
Discussion
10.

XML Schemas are XML documents.%!

A. True
B. False
Answer» B. False
Discussion
11.

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

A. True
B. False
Answer» C.
Discussion
12.

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

A. True
B. False
Answer» B. False
Discussion
13.

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

A. True
B. False
Answer» C.
Discussion
14.

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

A. True
B. False
Answer» C.
Discussion
15.

The DTD defines the structure of XML documents.%!

A. True
B. False
Answer» B. False
Discussion
16.

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

A. True
B. False
Answer» B. False
Discussion
17.

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

A. True
B. False
Answer» B. False
Discussion
18.

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. True
B. False
Answer» C.
Discussion
19.

SOAP uses HTTP as its only transport mechanism.%!

A. True
B. False
Answer» C.
Discussion
20.

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

A. True
B. False
Answer» B. False
Discussion
21.

*$_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
22.

*$_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
23.

*$_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
24.

%_The most popular way to materialize XML documents is to use:_%

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

_ The DTD begins with the word:$?

A. #PCDATA
B. XML
C. DOCTYPE
D. HTTPS
Answer» D. HTTPS
Discussion
26.

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

A. HTML page.
B. DOCTYPE procedure.
C. Stylesheet.
D. Stored procedure.
Answer» D. Stored procedure.
Discussion
27.

__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
28.

_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
29.

_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
30.

_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
31.

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
32.

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
33.

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
34.

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
35.

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