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

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

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

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

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

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

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

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

A. True
B. False
Answer» C.
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
8.

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

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

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

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

XML Schemas are XML documents.%!

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

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

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

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

A. True
B. False
Answer» B. False
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.
14.

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

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

The DTD defines the structure of XML documents.%!

A. True
B. False
Answer» B. False
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
17.

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

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

SOAP uses HTTP as its only transport mechanism.%!

A. True
B. False
Answer» C.
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
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.
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.
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.
24.

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

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

_ The DTD begins with the word:$?

A. #PCDATA
B. XML
C. DOCTYPE
D. HTTPS
Answer» D. HTTPS
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.
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.
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.
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.
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.
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
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.
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
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
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.