Chapter 11

Front 1

1) Every DBMS product has an application programming interface (API).

Back 1

Answer: TRUE

Front 2

2) Every DBMS product uses the same API.

Back 2

Answer: FALSE

Front 3

3) ODBC stands for Open Database Connectivity.

Back 3

Answer: TRUE

Front 4

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

Back 4

Answer: TRUE

Front 5

5) The most commonly used Web server on servers running the Unix or Linux operating system is Internet Information Server (IIS).

Back 5

Answer: FALSE

Front 6

6) If the Web server and the DBMS are running on the same server, the system has a three-tier architecture.

Back 6

Answer: FALSE

Front 7

7) ODBC has not had practical success, but has shown great potential for future development.

Back 7

Answer: FALSE

Front 8

8) ODBC works with table-like data sources such as relational databases and spreadsheets.

Back 8

Answer: TRUE

Front 9

9) ODBC acts as a wrapper for OLE DB.

Back 9

Answer: FALSE

Front 10

10) With ODBC, a database and the DBMS that processes it are identified by the data source.

Back 10

Answer: TRUE

Front 11

11) With ODBC, the driver manager serves as an intermediary between the application and the DBMS drivers.

Back 11

Answer: TRUE

Front 12

12) With ODBC, only a single driver is needed to handle all data source types, such as Oracle, DB2, and Access.

Back 12

Answer: FALSE

Front 13

13) In ODBC, the amount of work that the driver must do is largely determined by the degree of SQL-compliance of the data source.

Back 13

Answer: TRUE

Front 14

14) A multiple-tier ODBC driver may reformat an SQL request, but it does not actually process the SQL statement.

Back 14

Answer: TRUE

Front 15

15) With ODBC, a file data source is available only to the user that created it.

Back 15

Answer: FALSE

Front 16

16) In general, the best type of ODBC data source to define for a Web application is a system data source.

Back 16

Answer: TRUE

Front 17

17) OLE DB objects are COM objects.

Back 17

Answer: TRUE

Front 18

18) OLE DB can be used to access ODBC data sources.

Back 18

Answer: TRUE

Front 19

19) OLE DB is an object-oriented interface.

Back 19

Answer: TRUE

Front 20

20) In OLE DB, a RecordSet is a more abstract representation of a rowset.

Back 20

Answer: FALSE

Front 21

21) Object classes have properties that represent characteristics of the objects in the class.

Back 21

Answer: TRUE

Front 22

22) One of the properties of all collections is Count, which is the number of objects in the collection.

Back 22

Answer: TRUE

Front 23

23) In OLE DB, all of an object's properties must be exposed in all interfaces, but not all methods have to be exposed.

Back 23

Answer: FALSE

Front 24

24) One important result of OLE DB is that data does not have to be moved or converted from one form to another.

Back 24

Answer: TRUE

Front 25

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

Back 25

Answer: TRUE

Front 26

26) ADO provides access to ODBC functionality to programming languages that ordinarily could not access ODBC functions.

Back 26

Answer: FALSE

Front 27

27) ADO is accessible from languages such as C++ and C#, but not Visual Basic or scripting languages.

Back 27

Answer: FALSE

Front 28

28) ADO was (and still is) frequently used for database applications.

Back 28

Answer: TRUE

Front 29

29) ADO.NET is a completely new product, with no connection to ADO except the similar name.

Back 29

Answer: FALSE

Front 30

30) ADO.NET provides the capability to create and process in-memory databases called DataSets.

Back 30

Answer: TRUE

Front 31

31) An ADO.NET DataSet has all the characteristics, features, and functions of a regular database.

Back 31

Answer: TRUE

Front 32

32) An ADO.NET DataSet is connected to databases.

Back 32

Answer: FALSE

Front 33

33) An ADO.NET dataset can have primary and foreign keys, but ADO.NET does not support referential integrity.

Back 33

Answer: FALSE

Front 34

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

Back 34

Answer: TRUE

Front 35

35) An ADO.NET dataset can only be used with optimistic locking.

Back 35

Answer: TRUE

Front 36

36) Only open source products may be used in conjunction with JDBC.

Back 36

Answer: FALSE

Front 37

37) To use JDBC, programs must be written in Java.

Back 37

Answer: TRUE

Front 38

38) JDBC drivers only exist for a limited number of DBMS products at this time.

Back 38

Answer: FALSE

Front 39

39) JDBC-ODBC bridge drivers resolve inconsistencies between Java and C/C++ to allow Java access to ODBC data sources.

Back 39

Answer: TRUE

Front 40

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

Back 40

Answer: FALSE

Front 41

41) Type 4 JDBC drivers translate JDBC calls into a DBMS-independent network protocol.

Back 41

Answer: FALSE

Front 42

42) Java programs are compiled into machine-independent bytecode.

Back 42

Answer: TRUE

Front 43

43) Java programs tend to execute faster than programs compiled into machine-dependent code because the Java virtual machine only has to interpret the bytecode.

Back 43

Answer: FALSE

Front 44

44) An applet is a Java bytecode program that executes on the Web server.

Back 44

Answer: FALSE

Front 45

45) Applet bytecode is sent to the user's computer and is invoked using the HTTP protocol.

Back 45

Answer: TRUE

Front 46

46) Java programs that access a database from an applet must use a Type 2 JDBC driver.

Back 46

Answer: FALSE

Front 47

47) The first step in using a JDBC driver is to establish a connection.

Back 47

Answer: FALSE

Front 48

48) JSP can be coded only in Java and JavaScript.

Back 48

Answer: FALSE

Front 49

49) JSP pages are automatically re-compiled if the uncompiled JSP page is newer than the compiled version of the page.

Back 49

Answer: TRUE

Front 50

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

Back 50

Answer: TRUE

Front 51

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

Back 51

Answer: TRUE

Front 52

52) A common default Web page name recognized by most Web servers is FirstPage.html.

Back 52

Answer: FALSE

Front 53

53) Database processing and document processing are unrelated to one another.

Back 53

Answer: FALSE

Front 54

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

Back 54

Answer: TRUE

Front 55

55) In the 1990s the database community and the document processing community created a standard called Expandable Markup Language (XML).

Back 55

Answer: FALSE

Front 56

56) XML provides a standardized, non-customizable way to describe the content of a document.

Back 56

Answer: FALSE

Front 57

57) Unlike SQL views, XML views are not limited to one multivalued path.

Back 57

Answer: TRUE

Front 58

58) SOAP was originally an XML-based standard for providing remote procedure calls over the Internet.

Back 58

Answer: TRUE

Front 59

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

Back 59

Answer: FALSE

Front 60

60) DTD stands for Document Type Declaration.

Back 60

Answer: TRUE

Front 61

61) Possible uses of XML go far beyond using it to display Web pages.

Back 61

Answer: TRUE

Front 62

62) All type-valid XML documents are required to have a DTD.

Back 62

Answer: TRUE

Front 63

63) XSLT is a declarative transformation language.

Back 63

Answer: TRUE

Front 64

64) XML documents that conform to their DTD are said to be type-valid XML documents.

Back 64

Answer: TRUE

Front 65

65) XML documents that do not conform to their DTD are said to be non-type-valid XML documents.

Back 65

Answer: TRUE

Front 66

66) XSLT is a robust and powerful transformation language that can be used to materialize XML documents into HTML.

Back 66

Answer: TRUE

Front 67

67) XSLT is a non-declarative transformation language.

Back 67

Answer: FALSE

Front 68

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

Back 68

Answer: TRUE

Front 69

69) An XSLT command embedded in the structure of an XSLT stylesheet is of the form {loop, action}.

Back 69

Answer: FALSE

Front 70

70) When XSLT actions are indicated in a loop, the loop ends with .

Back 70

Answer: TRUE

Front 71

71) XSLT processors are context oriented; that is, each statement is evaluated within the context of the match that has already been made.

Back 71

Answer: TRUE

Front 72

72) After an XSLT processor transforms an XML document into an HTML document, the HTML document is materialized using a browser.

Back 72

Answer: TRUE

Front 73

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

Back 73

Answer: FALSE

Front 74

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

Back 74

Answer: FALSE

Front 75

75) XML documents that conform to an XML Schema are validated against that schema.

Back 75

Answer: TRUE

Front 76

76) XML documents and XML Schemas are created in different languages.

Back 76

Answer: FALSE

Front 77

77) An important improvement of XML Schema over DTDs is that XML Schemas are themselves XML documents.

Back 77

Answer: TRUE

Front 78

78) The first statement of an XML document indicates the schema that will be used to validate the document.

Back 78

Answer: FALSE

Front 79

79) XML Schemas consist of elements, attributes, and properties.

Back 79

Answer: FALSE

Front 80

80) In XML Schema, there are two types of elements, simple and composite.

Back 80

Answer: FALSE

Front 81

81) Elements of complexType must have more than one simple element.

Back 81

Answer: FALSE

Front 82

82) For database/XML applications, a good rule to follow is that elements are used to carry data and attributes are used to carry metadata.

Back 82

Answer: TRUE

Front 83

83) In XML Schema, the default cardinality of elements is 0.1.

Back 83

Answer: FALSE

Front 84

84) In XML Schema, the default minimum cardinality can be overridden using the minOccurs attributes.

Back 84

Answer: TRUE

Front 85

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

Back 85

Answer: TRUE

Front 86

86) An XML Schema where all the elements occur at the same level is called a structured schema.

Back 86

Answer: FALSE

Front 87

87) To eliminate definition duplication, XML Schema elements can be declared globally.

Back 87

Answer: TRUE

Front 88

88) SQL Server has facilities for generating XML documents from database data.

Back 88

Answer: TRUE

Front 89

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

Back 89

Answer: TRUE

Front 90

90) MySQL Server does not have facilities for generating XML documents from database data.

Back 90

Answer: FALSE

Front 91

91) The SQL Server statement SELECT...FOR XML is used to place column data as elements in an XML document.

Back 91

Answer: FALSE

Front 92

92) 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.

Back 92

Answer: TRUE

Front 93

93) 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.

Back 93

Answer: TRUE

Front 94

94) The SQL Server statement SELECT...FOR XML can only be used with a single table.

Back 94

Answer: FALSE

Front 95

95) XML processing provides a standardized facility to describe, validate, and materialize any database view.

Back 95

Answer: TRUE

Front 96

96) Few industries have shown an interest in developing XML industry standards.

Back 96

Answer: FALSE

Front 97

97) XML industry standards have been published for the Accounting industry.

Back 97

Answer: TRUE

Front 98

98) Xquery is a standard for expressing generalized queries on XML documents.

Back 98

Answer: TRUE

Front 99

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

Back 99

Answer: TRUE

Front 100

100) Which of the following can only interact with relational database and table-like data structures?
A) OLE DB
B) ODBC
C) ASP
D) ADO
E) All of the above

Back 100

Answer: B

Front 101

101) Which of the following is true about ODBC?
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.

Back 101

Answer: C

Front 102

102) According to the ODBC standard, which of the following is not part of the specification of a data source?
A) The associated DBMS
B) The database
C) The driver
D) The operating system
E) The network platform

Back 102

Answer: C

Front 103

103) The ODBC standard defines a means of doing which of the following?
A) Start transactions
B) Rollback transactions
C) Create a connection
D) Issue SQL commands
E) All of the above

Back 103

Answer: E

Front 104

104) Which of the following is a function performed by the driver manager in ODBC?
A) Submit SQL statements to the data source
B) Determine the type of DBMS that processes a given ODBC data source
C) Load the appropriate ODBC driver into memory
D) Convert data source error codes into ODBC error codes
E) B and C

Back 104

Answer: E

Front 105

105) The intermediary between the application and the DBMS drivers in the ODBC architecture is the ________.
A) driver manager
B) OLE DB interface
C) ODBC driver
D) data source
E) database connector

Back 105

Answer: A

Front 106

106) Which of the following is a task performed by the driver according to the ODBC standard?
A) Determines the appropriate DBMS
B) Validates the format of the ODBC command received from the application
C) Converts data source error codes into ODBC standard error codes
D) Verifies the application to the data source
E) Converts the data source into an SQL-compliant data structure

Back 106

Answer: C

Front 107

107) The ________ processes ODBC requests and submits specific SQL statements to a given type of data source.
A) driver manager
B) ADO
C) driver
D) source converter
E) ODBC translator

Back 107

Answer: C

Front 108

108) A data source that is fully SQL-compliant would use what type of DBMS driver?
A) Single-tier
B) Multiple-tier
C) SQL transform
D) Text-based
E) Conformance

Back 108

Answer: B

Front 109

109) How does an application determine the level of ODBC conformance available from a driver?
A) The application makes a call to the driver manager.
B) The application makes a call to the data source.
C) The application makes a call to the driver.
D) The developer must determine the level of conformance before the application is written.
E) It does not have to determine ODBC conformance since all ODBC drivers have the same functionality by definition.

Back 109

Answer: C

Front 110

110) Support for a scrollable cursor is a sign of what type of conformance in a DBMS driver?
A) Level 1 API
B) Extended SQL Grammar
C) Core API
D) Level 2 API
E) Core SQL Grammar

Back 110

Answer: D

Front 111

111) Support for subqueries and creating indexes is a sign of what type of SQL conformance in a DBMS driver?
A) Level 2 API
B) Minimum SQL Grammar
C) Core API
D) Extended SQL Grammar
E) Core SQL Grammar

Back 111

Answer: E

Front 112

112) A ________ data source can be shared among database users as long as they have the same DBMS driver and privilege to access the database.
A) file
B) common
C) shared
D) system
E) user

Back 112

Answer: A

Front 113

113) 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.
A) file
B) common
C) shared
D) system
E) user

Back 113

Answer: D

Front 114

114) In general, for Web applications it is best to create what type of data source on the Web server?
A) File
B) Common
C) Shared
D) System
E) User

Back 114

Answer: D

Front 115

115) OLE DB breaks the features and functions of a DBMS into what type of objects?
A) COM
B) DBMS
C) MTS
D) ODBC
E) ASP

Back 115

Answer: A

Front 116

116) Which of the following is not true about OLE DB?
A) Scripting languages cannot access OLE DB.
B) OLE DB is object-oriented.
C) OLE DB can access ODBC data sources.
D) OLE DB can access non-relational data sources.
E) OLE DB is used as a wrapper for ADO objects.

Back 116

Answer: E

Front 117

117) The characteristics of an object are called ________.
A) classes
B) collections
C) methods
D) properties
E) procedures

Back 117

Answer: D

Front 118

118) The actions that an object can perform are called ________.
A) classes
B) collections
C) methods
D) properties
E) procedures

Back 118

Answer: C

Front 119

119) An important method of a collection is a(n) ________, which can be used to pass through or otherwise identify the items in the collection.
A) iterator
B) identifier
C) converter
D) transformer
E) signal

Back 119

Answer: A

Front 120

120) A set of objects and the properties and methods that they expose are known as a(n) ________.
A) provider
B) data consumer
C) implementation
D) instantiation
E) interface

Back 120

Answer: E

Front 121

121) Which of the following is a type of OLE DB data provider?
A) relational data provider
B) method provider
C) sequential data provider
D) tabular data provider
E) implementation provider

Back 121

Answer: D

Front 122

122) Which standard interface in OLE DB is invoked to declare a forward-only cursor?
A) IRowSet
B) IAccessor
C) IColumnsInfo
D) adXact
E) ADODB

Back 122

Answer: A

Front 123

123) Which of the following is not true of ADO?
A) ADO is a simple object model for OLE DB data consumers.
B) ADO can be used from VBScript and JavaScript.
C) ADO is harder to understand than OLE DB.
D) ADO can be called from languages such as Visual Basic.NET, Java and C#.
E) All of the above are true of ADO.

Back 123

Answer: C

Front 124

124) Which of the following is true about ADO.NET?
A) It is an improved and expanded version of ADO.
B) It facilitates the transformation of XML documents to and from relational database constructs.
C) It provides the ability to create and process in-memory databases.
D) A and B
E) A, B, and C

Back 124

Answer: E

Front 125

125) ADO.NET in-memory databases are called ________.
A) adoBases
B) adoDatabases
C) dotNetBases
D) dotNetDatabases
E) DataSets

Back 125

Answer: E

Front 126

126) An ADO.NET Data Provider is a(n) ________ that provides ADO.NET services.
A) class library
B) windows application
C) Web application
D) XML service
E) DND service

Back 126

Answer: A

Front 127

127) Which of the following is true about ADO.NET DataSets?
A) They can have multiple tables and relationships.
B) They can have foreign keys and surrogate keys.
C) They can support referential integrity actions.
D) A and B
E) A, B, and C

Back 127

Answer: E

Front 128

128) Which of the following is true of JDBC?
A) Programs must be written in Java.
B) JDBC only works with open-source products.
C) JDBC is only available for Unix-like operating systems, such as Linux.
D) JDBC is actually a DBMS.
E) B and C

Back 128

Answer: A

Front 129

129) What type of JDBC driver is known as a JDBC-ODBC bridge?
A) Type J-O driver
B) Type 1 driver
C) Type 2 driver
D) Type 3 driver
E) Type 4 driver

Back 129

Answer: B

Front 130

130) What type of JDBC driver connects to the native API of the DBMS?
A) Type J-O driver
B) Type 1 driver
C) Type 2 driver
D) Type 3 driver
E) Type 4 driver

Back 130

Answer: C

Front 131

131) What type of JDBC driver translates JDBC calls into DBMS-independent network protocols?
A) Type J-O driver
B) Type 1 driver
C) Type 2 driver
D) Type 3 driver
E) Type 4 driver

Back 131

Answer: D

Front 132

132) What type of JDBC driver translates JDBC calls into DBMS-specific network protocols?
A) Type J-O driver
B) Type 1 driver
C) Type 2 driver
D) Type 3 driver
E) Type 4 driver

Back 132

Answer: E

Front 133

133) A Java virtual machine is actually a ________.
A) program compiler
B) JDBC data source
C) bytecode interpreter
D) JDBC driver
E) servlet

Back 133

Answer: C

Front 134

134) Which of the following is true about bytecode interpretation?
A) It may be performed on the client.
B) It may be performed on the server.
C) It is slower than running a program compiled into machine code.
D) It increases portability.
E) All of the above.

Back 134

Answer: E

Front 135

135) Applet bytecode is transmitted to the user's computer via ________.
A) the JDBC driver
B) the Java virtual machine
C) HTTP
D) SQL
E) the bytecode interpreter

Back 135

Answer: C

Front 136

136) A(n) ________ is a Java program that is interpreted and executed by a bytecode interpreter on the Web server.
A) applet
B) Java virtual machine
C) servlet
D) HTTP
E) JDBC translator

Back 136

Answer: C

Front 137

137) In a three-tier or n-tier architecture, which type of JDBC driver can be used if the DBMS and the Web server are running on the same computer?
A) Type 1 driver
B) Type 2 driver
C) Type 3 driver
D) Type 4 driver
E) All of the above.

Back 137

Answer: E

Front 138

138) The first step in using a JDBC driver is to ________.
A) establish a connection to the database
B) load the driver
C) create a statement
D) call the DriverManager object
E) invoke the executeQuery method

Back 138

Answer: B

Front 139

139) The coding for Java Server Pages must be written in ________.
A) Java
B) JavaScript
C) C++
D) Visual Basic
E) Any of the above

Back 139

Answer: A

Front 140

140) Which of the following is true about JSP code?
A) It must be written in Java or JavaScript.
B) It does not have access to HTTP functionality.
C) It must be coded as complete Java classes and methods.
D) It is automatically converted into Java servlets.
E) All of the above.

Back 140

Answer: D

Front 141

141) Which of the following is not true about Tomcat?
A) It is a servlet processor.
B) it can be used as a standalone Web server.
C) It is often used in conjunction with Apache.
D) It is an applet processor.
E) It has limited Web server facilities.

Back 141

Answer: D

Front 142

142) JSP pages are ________.
A) automatically compiled by the servlet processor as needed
B) required to be compiled by the developer before being made public
C) automatically checked for syntax errors by the servlet as they are written
D) slower to execute but more memory efficient than CGI files
E) A and D

Back 142

Answer: A

Front 143

143) As compared to CGI files, JSP pages ________.
A) are less memory efficient
B) require more processor time
C) execute faster
D) keep more copies of a given page in memory
E) None of the above

Back 143

Answer: C

Front 144

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

Back 144

Answer: D

Front 145

145) The first PHP element to be created is the:
A) Command object.
B) Connection object.
C) Errors collection.
D) Parameters collection.
E) RecordSet object.

Back 145

Answer: B

Front 146

146) The final step of using a PHP connection to a DBMS is to:
A) open the connection.
B) test the connection.
C) query the database.
D) process the query results.
E) close the connection.

Back 146

Answer: E

Front 147

147) PDO stands for:
A) PHP Data Objects.
B) PHP Design Objects.
C) Personal Data Objects.
D) Personal Design Objects.
E) None of the above.

Back 147

Answer: A

Front 148

148) HTML is an application of ________.
A) SGML
B) XML
C) SOAP
D) XSLT
E) ADO.NET

Back 148

Answer: A

Front 149

149) XML stands for ________.
A) Experimental Markup Language
B) Extendable Markup Language
C) Extensible Markup Language
D) Active X-control Markup Language
E) Active X-control Management Language

Back 149

Answer: C

Front 150

150) Which of the following is true about XML?
A) It is a subset of SGML.
B) Additional standards and capabilities have been added to XML processing.
C) It is a hybrid of document processing and database processing.
D) A and B
E) A, B, and C

Back 150

Answer: E

Front 151

151) SOAP originally stood for ________.
A) Simple Operational Application Protocol
B) Standard Operational Application Protocol
C) Simple Object Application Protocol
D) Simple Object Access Protocol
E) Standard Object Access Protocol

Back 151

Answer: D

Front 152

152) SOAP has become ________.
A) just a name, not an acronym
B) a standard protocol for sending any type of message
C) an old technology replaced by XML
D) A and B
E) A, B, and C

Back 152

Answer: D

Front 153

153) Which of the following is true about XML?
A) It allows the confounding of document structure, content, and format.
B) It is non-standardized to allow for extension by developers.
C) The structure of documents is formally defined.
D) XML tags, like some HTML tags, are vague and arbitrary.
E) None of the above.

Back 153

Answer: C

Front 154

154) The first section of an XML document might be a ________.
A) Document Definition Section (DDS)
B) Document Type Declaration (DTD)
C) Data Type (DTYPE)
D) Document Type (DOCTYPE)
E) Type Declaration (TYPEDECL)

Back 154

Answer: B

Front 155

155) The document type declaration for an XML document begins with the keyword ________.
A) XML
B) DTD
C) TYPE
D) DOCTYPE
E) TYPEDECL

Back 155

Answer: D

Front 156

156) XML documents that conform to their DTD are said to be ________.
A) DTD-valid
B) XML-valid
C) DTD-compliant
D) not-type-valid
E) type-valid

Back 156

Answer: E

Front 157

157) XML documents that are not-type-valid can still be ________.
A) DTD-valid
B) XML-valid
C) DTD-compliant
D) XML-compliant
E) proper XML documents

Back 157

Answer: E

Front 158

158) Which of the following is not true about document type declarations for XML documents?
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.

Back 158

Answer: C

Front 159

159) Which of the following is not true about XSLT?
A) It is a declarative language.
B) It is a transformation language.
C) It can materialize XML documents into HTML.
D) It can transform an XML document into another XML document with a different structure.
E) It requires the use of CSS.

Back 159

Answer: E

Front 160

160) Which of the following is true about XSLT?
A) It can be used to materialize XML documents into HTML.
B) XSLT processors are context oriented.
C) It is a non-declarative transformation language.
D) A and B
E) A, B, and C

Back 160

Answer: D

Front 161

161) XML Schema is used to define ________.
A) document content and structure
B) XQL queries
C) DOM-compliant parsers
D) DTDs
E) XPath searches

Back 161

Answer: A

Front 162

162) XML documents can be ________ against their XML Schema.
A) measured
B) grown
C) validated
D) browsed
E) All of the above

Back 162

Answer: C

Front 163

163) An important improvement of XML Schema over DTDs is that ________.
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

Back 163

Answer: C

Front 164

164) The XML Schema "mother of all schemas" is located at ________.
A) a user-defined Web server for each organization
B) www.w3.org
C) www.google.com
D) www.microsoft.com
E) www.xmlschema.net

Back 164

Answer: B

Front 165

165) The XML Schema statement xmlns:xsd indicates that ________.
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

Back 165

Answer: A

Front 166

166) XML Schemas consist of ________.
A) elements
B) attributes
C) properties
D) A and B
E) A, B, and C

Back 166

Answer: D

Front 167

167) Which of the following is a type of element in an XML Schema?
A) simple
B) composite
C) compound
D) complex
E) A and D

Back 167

Answer: E

Front 168

168) XML Schema elements of the complexType may contain ________.
A) one simple element
B) one complexType element
C) more than one simple element
D) more than one complexType element
E) Any of the above

Back 168

Answer: E

Front 169

169) In an XML Schema, the tags ...<\xsd:ComplexType> indicate that:
A) a sequence of numbers is listed between the tags.
B) a sequence of letters or words is listed between the tags.
C) a set of elements will occur in a multi-layered format between the tags.
D) A or B
E) A, B, or C

Back 169

Answer: C

Front 170

170) In database/ XML applications, it is a recommended practice that ________.
A) elements carry data, and attributes carry metadata
B) elements carry metadata, and attributes carry data
C) elements and attributes carry data, and the XML Schema carry metadata
D) elements and attributes carry metadata, and the XML Schema carry data
E) either A or B

Back 170

Answer: A

Front 171

171) The default cardinality for elements in an XML Schema is ________.
A) 0.1
B) 1.1
C) 1.N
D) N.1
E) M.N

Back 171

Answer: B

Front 172

172) The use of the XML Schema expression minOccurs="0" ________.
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

Back 172

Answer: C

Front 173

173) XML Schema that have all elements residing at the same level are called ________.
A) flat
B) structured
C) single-leveled
D) multi-leveled
E) styled

Back 173

Answer: A

Front 174

176) The SQL Server XML SELECT statements can be applied to ________.
A) single table SELECT statements
B) multiple table SELECT statements
C) XML Schema statements
D) A and B
E) A, B, and C

Back 174

Answer: D

Front 175

177) XML is important because XML processing provides a standardized facility to ________ any database view.
A) describe
B) validate
C) materialize
D) A and B
E) A, B, and C

Back 175

Answer: E

Front 176

178) The standard for locating particular elements within a document is called ________.
A) XML
B) XSL
C) XPath
D) SAX
E) DOM

Back 176

Answer: C

Front 177

179) XQuery is a standard for expressing ________.
A) queries as ADO.NET datasets
B) queries as XML documents
C) queries on SQL databases
D) A and B
E) A, B, and C

Back 177

Answer: B