Question 1

XML is important because XML processing provides a standardized facility to ________ any database view.

Accepted Answer

A) describe 
B) validate 
C) materialize 
D) A and B 
E) A,B,and C 
A) describe 
B) validate 
C) materialize 
D) A and B 
E) A,B,and C E

Question 2

If a server is using a Microsoft Windows operating system,it is usually running Internet Information Server (IIS)as its Web server.

Accepted Answer

A) True 
 B)False  True

Question 3

The SQL Server statement SELECT...FOR XML EXPLICIT is used to control placement of column data as either elements or attributes in an XML document.

Accepted Answer

A) True 
 B)False  True

Question 4

An important improvement of XML Schema over DTDs is that ________.

Accepted Answer

A) XML Schema can be stored external to the document 
B) XML Schema support XQL queries 
C) XML Schema are XML documents 
D) XML Schema are not required 
E) XML Schema can validate XML documents 
A) XML Schema can be stored external to the document 
B) XML Schema support XQL queries 
C) XML Schema are XML documents 
D) XML Schema are not required 
E) XML Schema can validate XML documents

Question 5

In PHP,any programming language statements that are to be processed on the server must be enclosed in:

Accepted Answer

A) . B) [php and php]. C) (php and php). D) . E) and . A) . B) [php and php]. C) (php and php). D) . E) and .

Question 6

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.

Accepted Answer

A) driver manager 
B) ADO 
C) driver 
D) source converter 
E) ODBC translator 
A) driver manager 
B) ADO 
C) driver 
D) source converter 
E) ODBC translator

Question 7

XML documents that are not-type-valid can still be ________.

Accepted Answer

A) DTD-valid 
B) XML-valid 
C) DTD-compliant 
D) XML-compliant 
E) proper XML documents 
A) DTD-valid 
B) XML-valid 
C) DTD-compliant 
D) XML-compliant 
E) proper XML documents

Question 8

An ADO.NET Data Provider is a(n)________ that provides ADO.NET services.

Accepted Answer

A) class library 
B) windows application 
C) Web application 
D) XML service 
E) DND service 
A) class library 
B) windows application 
C) Web application 
D) XML service 
E) DND service

Question 9

OLE DB breaks the features and functions of a DBMS into what type of objects?

Accepted Answer

A) COM 
B) DBMS 
C) MTS 
D) ODBC 
E) ASP 
A) COM 
B) DBMS 
C) MTS 
D) ODBC 
E) ASP

Question 10

Oracle requires the use of Java for generating XML documents from database data.

Accepted Answer

A) True 
 B)False

Question 11

XML stands for ________.

Accepted Answer

A) Experimental Markup Language 
B) Extendable Markup Language 
C) Extensible Markup Language 
D) Active X-control Markup Language 
E) Active X-control Management Language 
A) Experimental Markup Language 
B) Extendable Markup Language 
C) Extensible Markup Language 
D) Active X-control Markup Language 
E) Active X-control Management Language

Question 12

HTML is an application of a document markup language called Standard Generalized Markup Language (SGML).

Accepted Answer

A) True 
 B)False

Question 13

Most of today's Web browsers still lack a built-in XSLT processor.

Accepted Answer

A) True 
 B)False

Question 14

The SQL Server statement SELECT *
FROM Table01
FOR XML EXPLICIT
Tells SQL Server to place the data values from the columns in the table into XML ________.

Accepted Answer

A) elements 
B) attributes 
C) either elements or attributes,as chosen by SQL Server 
D) either elements or attributes,as designated by the developer 
E) either elements or attributes,as designated by the XML Schema 
A) elements 
B) attributes 
C) either elements or attributes,as chosen by SQL Server 
D) either elements or attributes,as designated by the developer 
E) either elements or attributes,as designated by the XML Schema

Question 15

XML designers created a system that allows document structure,data content,and materialization to be mixed.

Accepted Answer

A) True 
 B)False

Question 16

XML documents that conform to their DTD are said to be ________.

Accepted Answer

A) DTD-valid 
B) XML-valid 
C) DTD-compliant 
D) not-type-valid 
E) type-valid 
A) DTD-valid 
B) XML-valid 
C) DTD-compliant 
D) not-type-valid 
E) type-valid

Question 17

Once an ADO.NET dataset is constructed,its contents can be formatted as an XML document with a single command.

Accepted Answer

A) True 
 B)False

Question 18

A data source that is local to a single computer and can be used by the operating system and any user on that computer is called a ________ data source.

Accepted Answer

A) file 
B) common 
C) shared 
D) system 
E) user 
A) file 
B) common 
C) shared 
D) system 
E) user

Question 19

Which of the following is not true about document type declarations for XML documents?

Accepted Answer

A) They are not required. 
B) They are required for type-valid documents. 
C) They cannot be contained inside the XML document. 
D) Storing the DTD externally allows many documents to be validated against the same DTD. 
E) The DTD can be extended by the developer with any elements he or she wants to include. 
A) They are not required. 
B) They are required for type-valid documents. 
C) They cannot be contained inside the XML document. 
D) Storing the DTD externally allows many documents to be validated against the same DTD. 
E) The DTD can be extended by the developer with any elements he or she wants to include.

Question 20

What is an XML Schema?

Accepted Answer

An XML schema defines the structure and

Exam 11: The Web Server Environment

XML is important because XML processing provides a standardized facility to ________ any database view.

If a server is using a Microsoft Windows operating system,it is usually running Internet Information Server (IIS)as its Web server.

The SQL Server statement SELECT...FOR XML EXPLICIT is used to control placement of column data as either elements or attributes in an XML document.

An important improvement of XML Schema over DTDs is that ________.

In PHP,any programming language statements that are to be processed on the server must be enclosed in:

The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.

XML documents that are not-type-valid can still be ________.

An ADO.NET Data Provider is a(n)________ that provides ADO.NET services.

OLE DB breaks the features and functions of a DBMS into what type of objects?

Oracle requires the use of Java for generating XML documents from database data.

XML stands for ________.

HTML is an application of a document markup language called Standard Generalized Markup Language (SGML).

Most of today's Web browsers still lack a built-in XSLT processor.

The SQL Server statement SELECT * FROM Table01 FOR XML EXPLICIT Tells SQL Server to place the data values from the columns in the table into XML ________.

XML designers created a system that allows document structure,data content,and materialization to be mixed.

XML documents that conform to their DTD are said to be ________.

Once an ADO.NET dataset is constructed,its contents can be formatted as an XML document with a single command.

A data source that is local to a single computer and can be used by the operating system and any user on that computer is called a ________ data source.

Which of the following is not true about document type declarations for XML documents?

What is an XML Schema?

Introduction

Introduction to Structured Query Language SQL

The Relational Model and Normalization

Database Design Using Normalization

Data Modeling With the Entity-Relationship Model

Transforming Data Models Into Database Designs

Sql for Database Construction and Application Processing

Database Redesign

Managing Multiuser Databases

A: Managing Databases With SQL Server 20012

B: Managing Databases With Oracle Database 11g Release 2

C: Managing Databases With MySQL

Big Data datawarehouse and Business Intelligence Systems

Microsoft Access 2013

Getting Started With Systems Analysis and Design

E-R Diagrams and the Idef1x Standard

E-R Diagrams and the UML Standard

Getting Started With MySQL Workbench Data Modeling Tools

Getting Started With Microsoft Visio 2013

Data Structures for Database Processing

the Semantic Object Model

Getting Started With Web Servers php and the Eclipse PDT

Business Intelligence Systems

Filters