Question 1

All of the following are concerns about developing a Web services approach EXCEPT:

Accepted Answer

A)  transaction speed. 
B)  user acceptability. 
C)  security. 
D)  reliability. 
A)  transaction speed. 
B)  user acceptability. 
C)  security. 
D)  reliability.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Explain how middleware is used in a two-tier application.

Accepted Answer

Middleware is any class of software that

Question 4

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

Accepted Answer

A)  API 
B)  MOM 
C)  RPC 
D)  LAN 
A)  API 
B)  MOM 
C)  RPC 
D)  LAN

Question 5

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 6

Geolocation logic is the application logic component responsible for data storage and retrieval.

Accepted Answer

A) True 
 B)False

Question 7

Stripping 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 8

Which of the following is NOT a common distribution logic for two-tiered server environments?

Accepted Answer

A)  Fat client 
B)  Tall client 
C)  Thin client 
D)  Distributed 
A)  Fat client 
B)  Tall client 
C)  Thin client 
D)  Distributed

Question 9

Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers.

Accepted Answer

A) True 
 B)False

Question 10

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

Question 11

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

Accepted Answer

A) True 
 B)False

Question 12

All .html files can be processed by the web server itself.

Accepted Answer

A) True 
 B)False

Question 13

Web services:

Accepted Answer

A)  are a set of services available to all on the Web. 
B)  are a set of emerging standards for protocols for automatic communication between software over the Web. 
C)  are a set of standards based upon HTML. 
D)  are still conceptual and yet to be created. 
A)  are a set of services available to all on the Web. 
B)  are a set of emerging standards for protocols for automatic communication between software over the Web. 
C)  are a set of standards based upon HTML. 
D)  are still conceptual and yet to be created.

Question 14

An XML-based grammar used to describe a Web service is called:

Accepted Answer

A)  Web Service Description Language (WSDL). 
B)  WIDL. 
C)  WISL. 
D)  Business-to-Business (B2
B) . 
A)  Web Service Description Language (WSDL). 
B)  WIDL. 
C)  WISL. 
D)  Business-to-Business (B2
B) .

Question 15

Which of the following is NOT a disadvantage of stored procedures?

Accepted Answer

A)  Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder. 
B)  Decreases in network traffic are realized. 
C)  Stored procedures are proprietary and not easy to move from one RDBMS to another. 
D)  Each client must be loaded with the application to be used at that location. 
A)  Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder. 
B)  Decreases in network traffic are realized. 
C)  Stored procedures are proprietary and not easy to move from one RDBMS to another. 
D)  Each client must be loaded with the application to be used at that location.

Question 16

Even with XML, different types of devices will require a different page.

Accepted Answer

A) True 
 B)False

Question 17

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a component of processing logic?

Accepted Answer

A)  Input 
B)  Output 
C)  Retrieval 
D)  Business rules 
A)  Input 
B)  Output 
C)  Retrieval 
D)  Business rules

Question 19

All of the following are characteristics of cloud technologies EXCEPT:

Accepted Answer

A)  unlimited bandwidth. 
B)  on-demand self-service IT capabilities. 
C)  broad network access. 
D)  rapid elasticity. 
A)  unlimited bandwidth. 
B)  on-demand self-service IT capabilities. 
C)  broad network access. 
D)  rapid elasticity.

Question 20

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)  a special SQL command to JOIN tables. 
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)  a special SQL command to JOIN tables.

All of the following are concerns about developing a Web services approach EXCEPT:

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

Explain how middleware is used in a two-tier application.

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

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.

Geolocation logic is the application logic component responsible for data storage and retrieval.

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

Which of the following is NOT a common distribution logic for two-tiered server environments?

Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers.

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.

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

All .html files can be processed by the web server itself.

Web services:

An XML-based grammar used to describe a Web service is called:

Which of the following is NOT a disadvantage of stored procedures?

Even with XML, different types of devices will require a different page.

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Which of the following is a component of processing logic?

All of the following are characteristics of cloud technologies EXCEPT:

Extensible Markup Language (XML) is:

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

All of the following are concerns about developing a Web services approach EXCEPT:

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

Explain how middleware is used in a two-tier application.

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system.

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.

Geolocation logic is the application logic component responsible for data storage and retrieval.

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

Which of the following is NOT a common distribution logic for two-tiered server environments?

Infrastructure-as-a-Service refers to the use of technologies such as servers, storage and networks from external service providers.

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.

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

All .html files can be processed by the web server itself.

Web services:

An XML-based grammar used to describe a Web service is called:

Which of the following is NOT a disadvantage of stored procedures?

Even with XML, different types of devices will require a different page.

A client PC that is responsible for presentation logic, application logic, and many DBMS functions is called a fat client.

Which of the following is a component of processing logic?

All of the following are characteristics of cloud technologies EXCEPT:

Extensible Markup Language (XML) is:

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