Question 1

A Web server:

Accepted Answer

A)  is used only to host Web pages. 
B)  processes client requests and returns HTML pages to the client. 
C)  always contains a database. 
D)  is considered to be part of the firewall. 
A)  is used only to host Web pages. 
B)  processes client requests and returns HTML pages to the client. 
C)  always contains a database. 
D)  is considered to be part of the firewall. B

Question 2

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server,depending upon which location will give the best performance.

Accepted Answer

A) True 
 B)False  True

Question 3

Which of the following is an advantage of stored procedures?

Accepted Answer

A)  Data integrity improves when fewer applications access the procedure. 
B)  The layers get cleaner. 
C)  Stored procedures result in fatter clients. 
D)  Performance improves for compiled SQL statements. 
A)  Data integrity improves when fewer applications access the procedure. 
B)  The layers get cleaner. 
C)  Stored procedures result in fatter clients. 
D)  Performance improves for compiled SQL statements. D

Question 4

Which of the following is true about three-tier architectures?

Accepted Answer

A)  Less scalable than two-tier 
B)  Increased risk 
C)  More technological flexibility 
D)  All of the above 
A)  Less scalable than two-tier 
B)  Increased risk 
C)  More technological flexibility 
D)  All of the above

Question 5

Strippimg an XML document means storing each element of an XML schema in a relational table and using other tables to store the elements.

Accepted Answer

A) True 
 B)False

Question 6

A(n)________ is a language used for defining XML databases.

Accepted Answer

XML Schema

Question 7

Discuss some of the key benefits of three-tier applications.

Accepted Answer

Three-tier applications can lead to seve

Question 8

SOAP is an insignificant Web standard.

Accepted Answer

A) True 
 B)False

Question 9

ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.

Accepted Answer

A) True 
 B)False

Question 10

Java servlets execute from within another program and reside on the server.

Accepted Answer

A) True 
 B)False

Question 11

An API is a set of routines that a database server uses to access database objects.

Accepted Answer

A) True 
 B)False

Question 12

All of the following are common Web server interfaces EXCEPT:

Accepted Answer

A)  Common Gateway Interface (CGI). 
B)  Hypertext Markup Language. 
C)  Application Program Interface (API). 
D)  Java servlets. 
A)  Common Gateway Interface (CGI). 
B)  Hypertext Markup Language. 
C)  Application Program Interface (API). 
D)  Java servlets.

Question 13

PHP is a popular API for MySQL because of all of the following EXCEPT:

Accepted Answer

A)  Microsoft integration. 
B)  high performance. 
C)  easy to use. 
D)  MySQL connectivity built-in. 
A)  Microsoft integration. 
B)  high performance. 
C)  easy to use. 
D)  MySQL connectivity built-in.

Question 14

A ________ is a language used for defining XML databases.

Accepted Answer

The answer of A ________ is a language used for...

Question 15

A PC configured to handle user interface with little or no local storage is called a:

Accepted Answer

A)  server. 
B)  fat client. 
C)  thin client. 
D)  workstation. 
A)  server. 
B)  fat client. 
C)  thin client. 
D)  workstation.

Question 16

Extensible Markup Language (XML)is:

Accepted Answer

A)  a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. 
B)  a database language. 
C)  a product used for database middleware. 
D)  none of the above. 
A)  a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. 
B)  a database language. 
C)  a product used for database middleware. 
D)  none of the above.

Question 17

________ is an XML transformation language for querying relational data as well as XML databases.

Accepted Answer

The answer of ________ is an XML transformation language for...

Question 18

Which if the following is NOT a method for storing XML documents?

Accepted Answer

A)  shredding 
B)  use a BLOB or CLOB to store the entire XML file 
C)  use an XML native database 
D)  convert to text 
A)  shredding 
B)  use a BLOB or CLOB to store the entire XML file 
C)  use an XML native database 
D)  convert to text

Question 19

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

Accepted Answer

A)  HTML 
B)  XSLT 
C)  SGI 
D)  WSL 
A)  HTML 
B)  XSLT 
C)  SGI 
D)  WSL

Question 20

Business rules logic includes such activities as data validation and identification of processing errors.

Accepted Answer

A) True 
 B)False

A Web server:

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server,depending upon which location will give the best performance.

Which of the following is an advantage of stored procedures?

Which of the following is true about three-tier architectures?

Strippimg an XML document means storing each element of an XML schema in a relational table and using other tables to store the elements.

A(n)________ is a language used for defining XML databases.

Discuss some of the key benefits of three-tier applications.

SOAP is an insignificant Web standard.

ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.

Java servlets execute from within another program and reside on the server.

An API is a set of routines that a database server uses to access database objects.

All of the following are common Web server interfaces EXCEPT:

PHP is a popular API for MySQL because of all of the following EXCEPT:

A ________ is a language used for defining XML databases.

A PC configured to handle user interface with little or no local storage is called a:

Extensible Markup Language (XML)is:

________ is an XML transformation language for querying relational data as well as XML databases.

Which if the following is NOT a method for storing XML documents?

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

Business rules logic includes such activities as data validation and identification of processing errors.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters

Exam 8: Database Application Development

A Web server:

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server,depending upon which location will give the best performance.

Which of the following is an advantage of stored procedures?

Which of the following is true about three-tier architectures?

Strippimg an XML document means storing each element of an XML schema in a relational table and using other tables to store the elements.

A(n)________ is a language used for defining XML databases.

Discuss some of the key benefits of three-tier applications.

SOAP is an insignificant Web standard.

ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.

Java servlets execute from within another program and reside on the server.

An API is a set of routines that a database server uses to access database objects.

All of the following are common Web server interfaces EXCEPT:

PHP is a popular API for MySQL because of all of the following EXCEPT:

A ________ is a language used for defining XML databases.

A PC configured to handle user interface with little or no local storage is called a:

Extensible Markup Language (XML)is:

________ is an XML transformation language for querying relational data as well as XML databases.

Which if the following is NOT a method for storing XML documents?

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

Business rules logic includes such activities as data validation and identification of processing errors.

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model and Business Rules

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Data Warehousing

Data Quality and Integration

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Using Relational Databases to Provide Object Persistence

Filters