Question 1

Which of the following is true about ODBC?

Accepted Answer

A) ODBC has experienced little practical success. 
B) ODBC requires developers to have a thorough knowledge of many DBMS native libraries. 
C) ODBC can be used to access data from spreadsheets. 
D) ODBC has an object-oriented interface. 
E) ODBC does not include facilities to return error messages. 
A) ODBC has experienced little practical success. 
B) ODBC requires developers to have a thorough knowledge of many DBMS native libraries. 
C) ODBC can be used to access data from spreadsheets. 
D) ODBC has an object-oriented interface. 
E) ODBC does not include facilities to return error messages.

Question 2

The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

Accepted Answer

A) True 
 B)False

Question 3

An OLE DB service provider accepts data from an OLE DB tabular data provider.

Accepted Answer

A) True 
 B)False

Question 4

The XML Schema statement xmlns:xsd indicates that ________.

Accepted Answer

A) this XML Schema uses a labeled namespace called xsd 
B) this XML Schema is validated at www.xsd.com 
C) this XML Schema is validated at www.xmlns.com using the xsd XML Schema located there 
D) this XML Schema is using a non-standard looping procedure,where xsd is the variable name of the loop increment 
E) the value of the variable xmnls is being set equal to the value of the variable xsd 
A) this XML Schema uses a labeled namespace called xsd 
B) this XML Schema is validated at www.xsd.com 
C) this XML Schema is validated at www.xmlns.com using the xsd XML Schema located there 
D) this XML Schema is using a non-standard looping procedure,where xsd is the variable name of the loop increment 
E) the value of the variable xmnls is being set equal to the value of the variable xsd

Question 5

An XSLT stylesheet is used by XSLT to indicate how to transform the elements of an XML document into another format.

Accepted Answer

A) True 
 B)False

Question 6

Type 2 JDBC drivers access ODBC data sources over a network.

Accepted Answer

A) True 
 B)False

Question 7

The default cardinality for elements in an XML Schema is ________.

Accepted Answer

A) 0)1 
B) 1)1 
C) 1)N 
D) N)1 
E) M)N 
A) 0)1 
B) 1)1 
C) 1)N 
D) N)1 
E) M)N

Question 8

The use of the XML Schema expression minOccurs="0" ________.

Accepted Answer

A) is an XML Schema default 
B) is required as there are no defaults in an XML Schema 
C) is similar to the SQL schema NULL constraint 
D) A and C 
E) B and C 
A) is an XML Schema default 
B) is required as there are no defaults in an XML Schema 
C) is similar to the SQL schema NULL constraint 
D) A and C 
E) B and C

Question 9

XML Schema is a synonym for Document Type Declaration (DTD).

Accepted Answer

A) True 
 B)False

Question 10

HTML is defined by the World Wide Web Consortium (W3C).

Accepted Answer

A) True 
 B)False

Question 11

Which standard interface in OLE DB is invoked to declare a forward-only cursor?

Accepted Answer

A) IRowSet 
B) IAccessor 
C) IColumnsInfo 
D) adXact 
E) ADODB 
A) IRowSet 
B) IAccessor 
C) IColumnsInfo 
D) adXact 
E) ADODB

Question 12

The SQL Server XML SELECT statements can be applied to ________.

Accepted Answer

A) single table SELECT statements 
B) multiple table SELECT statements 
C) XML Schema statements 
D) A and B 
E) A,B,and C 
A) single table SELECT statements 
B) multiple table SELECT statements 
C) XML Schema statements 
D) A and B 
E) A,B,and C

Question 13

The document type declaration for an XML document begins with the keyword ________.

Accepted Answer

A) XML 
B) DTD 
C) TYPE 
D) DOCTYPE 
E) TYPEDECL 
A) XML 
B) DTD 
C) TYPE 
D) DOCTYPE 
E) TYPEDECL

Question 14

Basic Web pages are created using Hypertext Markup Language (HTML).

Accepted Answer

A) True 
 B)False

Question 15

Setting the minimum cardinality to 0 is similar to using a NULL constraint in SQL.

Accepted Answer

A) True 
 B)False

Question 16

XML Schemas consist of ________.

Accepted Answer

A) elements 
B) attributes 
C) properties 
D) A and B 
E) A,B,and C 
A) elements 
B) attributes 
C) properties 
D) A and B 
E) A,B,and C

Question 17

XML Namespaces are used to define domains,support domains,and disambiguate terms.

Accepted Answer

A) True 
 B)False

Question 18

XML Schema is used to define ________.

Accepted Answer

A) document content and structure 
B) XQL queries 
C) DOM-compliant parsers 
D) DTDs 
E) XPath searches 
A) document content and structure 
B) XQL queries 
C) DOM-compliant parsers 
D) DTDs 
E) XPath searches

Question 19

To use JDBC,programs must be written in Java.

Accepted Answer

A) True 
 B)False

Question 20

A Java virtual machine is actually a ________.

Accepted Answer

A) program compiler 
B) JDBC data source 
C) bytecode interpreter 
D) JDBC driver 
E) servlet 
A) program compiler 
B) JDBC data source 
C) bytecode interpreter 
D) JDBC driver 
E) servlet

Exam 11: The Web Server Environment

Which of the following is true about ODBC?

The SQL Server statement SELECT ...FOR XML RAW tells SQL Server to place the data values from the columns in the table into XML elements.

An OLE DB service provider accepts data from an OLE DB tabular data provider.

The XML Schema statement xmlns:xsd indicates that ________.

An XSLT stylesheet is used by XSLT to indicate how to transform the elements of an XML document into another format.

Type 2 JDBC drivers access ODBC data sources over a network.

The default cardinality for elements in an XML Schema is ________.

The use of the XML Schema expression minOccurs="0" ________.

XML Schema is a synonym for Document Type Declaration (DTD).

HTML is defined by the World Wide Web Consortium (W3C).

Which standard interface in OLE DB is invoked to declare a forward-only cursor?

The SQL Server XML SELECT statements can be applied to ________.

The document type declaration for an XML document begins with the keyword ________.

Basic Web pages are created using Hypertext Markup Language (HTML).

Setting the minimum cardinality to 0 is similar to using a NULL constraint in SQL.

XML Schemas consist of ________.

XML Namespaces are used to define domains,support domains,and disambiguate terms.

XML Schema is used to define ________.

To use JDBC,programs must be written in Java.

A Java virtual machine is actually a ________.

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