Question 1

What is service-oriented architecture?

Accepted Answer

Service-oriented architecture is a collection of Web services that communicate with each other in some manner, usually by passing data or coordinating a business activity.

Question 2

SOAP stands for:

Accepted Answer

A)  what you wash your hands with. 
B)  Simple ODBC Access Protocol. 
C)  Strategic Operational Advanced Planning. 
D)  Simple Object Access Protocol Method. 
A)  what you wash your hands with. 
B)  Simple ODBC Access Protocol. 
C)  Strategic Operational Advanced Planning. 
D)  Simple Object Access Protocol Method. D

Question 3

Two-tier architectures are much more scalable than three-tier architectures.

Accepted Answer

A) True 
 B)False  False

Question 4

Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services.

Accepted Answer

A) True 
 B)False

Question 5

Web Services are a set of emerging standards that define protocols for automatic communication between software programs over the Web.

Accepted Answer

A) True 
 B)False

Question 6

FLWOR is an acronym for:

Accepted Answer

A)  flowers. 
B)  For, LET, Where OrderBy, Return. 
C)  For, Locate, Work, Order, Results. 
D)  First, Let, Work, Order, Results. 
A)  flowers. 
B)  For, LET, Where OrderBy, Return. 
C)  For, Locate, Work, Order, Results. 
D)  First, Let, Work, Order, Results.

Question 7

Storing XML data is becoming a big question as XML data becomes more prevalent.

Accepted Answer

A) True 
 B)False

Question 8

XQuery is an HTML transformation language used to query HTML pages.

Accepted Answer

A) True 
 B)False

Question 9

What are Web services?

Accepted Answer

Web services are XML-based protocols tha

Question 10

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

Accepted Answer

Three-tier applications can lead to seve

Question 11

An application programming interface that enables an application program to process RDBMS databases meets the:

Accepted Answer

A)  object linking and embedding standard. 
B)  open database connectivity standard. 
C)  multi-platform connectivity standard. 
D)  open source standard. 
A)  object linking and embedding standard. 
B)  open database connectivity standard. 
C)  multi-platform connectivity standard. 
D)  open source standard.

Question 12

A language used to transform complex XML documents and also used to create HTML pages from XML documents is called Extensible Stylesheet Transformation.

Accepted Answer

A) True 
 B)False

Question 13

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.

Question 14

The XML shown in the figure below describes some data from the Pine Valley Furniture case study.  
What does the following The following XPath expression return?
/furniturecompany/product/[finish = "Cherry"]/standardprice

Accepted Answer

A)  All products with a cherry finish 
B)  A description of all products with a cherry finish 
C)  The standard price of products with a cherry finish 
D)  Nothing 
A)  All products with a cherry finish 
B)  A description of all products with a cherry finish 
C)  The standard price of products with a cherry finish 
D)  Nothing

Question 15

Java servlets:

Accepted Answer

A)  are small programs that execute from within another application rather than from the operating system. 
B)  must be executed each time a user makes a request. 
C)  are stored on the client. 
D)  are implemented as dynamic link libraries (DLLs). 
A)  are small programs that execute from within another application rather than from the operating system. 
B)  must be executed each time a user makes a request. 
C)  are stored on the client. 
D)  are implemented as dynamic link libraries (DLLs).

Question 16

The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access.

Accepted Answer

A)  software services 
B)  grid computing 
C)  network computing 
D)  cloud computing 
A)  software services 
B)  grid computing 
C)  network computing 
D)  cloud computing

Question 17

________ is the process of assigning pieces of application code to clients or servers.

Accepted Answer

A)  Application partitioning 
B)  Modularizing programs 
C)  Code distribution 
D)  Program breakup 
A)  Application partitioning 
B)  Modularizing programs 
C)  Code distribution 
D)  Program breakup

Question 18

A DTD is a language used for defining XML databases.

Accepted Answer

A) True 
 B)False

Question 19

A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a(n):

Accepted Answer

A)  persistent module. 
B)  function. 
C)  application component. 
D)  stored procedure. 
A)  persistent module. 
B)  function. 
C)  application component. 
D)  stored procedure.

Question 20

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a:

Accepted Answer

A)  file server. 
B)  file processor. 
C)  database server. 
D)  fat client. 
A)  file server. 
B)  file processor. 
C)  database server. 
D)  fat client.

What is service-oriented architecture?

SOAP stands for:

Two-tier architectures are much more scalable than three-tier architectures.

Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services.

Web Services are a set of emerging standards that define protocols for automatic communication between software programs over the Web.

FLWOR is an acronym for:

Storing XML data is becoming a big question as XML data becomes more prevalent.

XQuery is an HTML transformation language used to query HTML pages.

What are Web services?

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

An application programming interface that enables an application program to process RDBMS databases meets the:

A language used to transform complex XML documents and also used to create HTML pages from XML documents is called Extensible Stylesheet Transformation.

Which of the following is an advantage of stored procedures?

The XML shown in the figure below describes some data from the Pine Valley Furniture case study. What does the following The following XPath expression return? /furniturecompany/product/[finish = "Cherry"]/standardprice

Java servlets:

The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access.

________ is the process of assigning pieces of application code to clients or servers.

A DTD is a language used for defining XML databases.

A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a(n):

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters

Exam 8: Database Application Development

What is service-oriented architecture?

SOAP stands for:

Two-tier architectures are much more scalable than three-tier architectures.

Lack of secure standards and lack of user acceptance are the major issues that must be resolved with Web services.

Web Services are a set of emerging standards that define protocols for automatic communication between software programs over the Web.

FLWOR is an acronym for:

Storing XML data is becoming a big question as XML data becomes more prevalent.

XQuery is an HTML transformation language used to query HTML pages.

What are Web services?

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

An application programming interface that enables an application program to process RDBMS databases meets the:

A language used to transform complex XML documents and also used to create HTML pages from XML documents is called Extensible Stylesheet Transformation.

Which of the following is an advantage of stored procedures?

The XML shown in the figure below describes some data from the Pine Valley Furniture case study. What does the following The following XPath expression return? /furniturecompany/product/[finish = "Cherry"]/standardprice

Java servlets:

The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access.

________ is the process of assigning pieces of application code to clients or servers.

A DTD is a language used for defining XML databases.

A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a(n):

A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a:

The Database Environment and Development Process

Modeling Data in the Organization

The Enhanced E-R Model

Logical Database Design and the Relational Model

Physical Database Design and Performance

Introduction to SQL

Advanced SQL

Data Warehousing

Data Quality and Integration

Big Data and Analytics

Data and Database Administration

Distributed Databases

Object-Oriented Data Modeling

Filters