Question 1

APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.

Accepted Answer

A) True 
 B)False

Question 2

A DBMS that supports ____ exchanges can integrate with external systems such as the
Web, mobile data, and legacy systems, thus enabling the creation of new types of systems.

Accepted Answer

The answer of A DBMS that supports ____ exchanges can...

Question 3

What is a disadvantage of using an API Web-server interface?

Accepted Answer

A)  It is slower than CGI. 
B)  It is very inefficient because it uses DLLs. 
C)  You need to run an external program for each request. 
D)  An error can bring down the Web server. 
A)  It is slower than CGI. 
B)  It is very inefficient because it uses DLLs. 
C)  You need to run an external program for each request. 
D)  An error can bring down the Web server.

Question 4

____ is a higher-level object-oriented application interface used to access remote database servers.

Accepted Answer

A)  API 
B)  ODBC 
C)  DAO 
D)  RDO 
A)  API 
B)  ODBC 
C)  DAO 
D)  RDO

Question 5

A(n) ____ file provides the composition of the database's logical model and defines the syntax rules for an XML document.

Accepted Answer

A)  XMLD 
B)  HTML 
C)  DTD 
D)  meta 
A)  XMLD 
B)  HTML 
C)  DTD 
D)  meta

Question 6

The ODBC API standard defines three levels of compliance: ____, Level-1, and Level-2, which provide increasing levels of functionality.

Accepted Answer

A)  Complete 
B)  Basic 
C)  Core 
D)  Level-0 
A)  Complete 
B)  Basic 
C)  Core 
D)  Level-0

Question 7

When using an Oracle database, your Web-to-database middleware can connect to the database via ____.

Accepted Answer

A)  ODBX 
B)  CGI 
C)  SQL*Net 
D)  SQL*Plus 
A)  ODBX 
B)  CGI 
C)  SQL*Net 
D)  SQL*Plus

Question 8

The creation and management of user interfaces and database connectivity are not affected by the Web's existence.

Accepted Answer

A) True 
 B)False

Question 9

The ____ object is the in-memory representation of the data in the database.

Accepted Answer

A)  Command 
B)  DataReader 
C)  DataAdapter 
D)  DataSet 
A)  Command 
B)  DataReader 
C)  DataAdapter 
D)  DataSet

Question 10

Extending the Web server functionality implies that the Web server and the Web-to-database middleware will properly communicate with each other.

Accepted Answer

A) True 
 B)False

Question 11

Database connectivity software is also known as database middleware because it interfaces between the application program and the database.

Accepted Answer

A) True 
 B)False

Question 12

There are currently ____ well-defined Web-server interfaces.

Accepted Answer

A)  one 
B)  two 
C)  five 
D)  ten 
A)  one 
B)  two 
C)  five 
D)  ten

Question 13

What is the first step in the exchange between a Web browser and a database?

Accepted Answer

A)  The HTML output is displayed on the client computer's Web browser. 
B)  The middleware receives the query result and creates the HTML-formatted page. 
C)  The client's Web browser requests a page from a Web server. 
D)  The Web-to-database middleware uses ODBC to connect to the database. 
A)  The HTML output is displayed on the client computer's Web browser. 
B)  The middleware receives the query result and creates the HTML-formatted page. 
C)  The client's Web browser requests a page from a Web server. 
D)  The Web-to-database middleware uses ODBC to connect to the database.

Question 14

Of the following, what is one of the benefits of rapid development at manageable costs for Internet technologies?

Accepted Answer

A)  Platform independence and portability 
B)  Availability of multiple development tools 
C)  Reduced requirements 
D)  Reduced training time 
A)  Platform independence and portability 
B)  Availability of multiple development tools 
C)  Reduced requirements 
D)  Reduced training time

Question 15

Cloud services allow any organization to quickly and economically add information technology services such as applications, storage, servers, processing power, databases, and infrastructure to its IT portfolio.

Accepted Answer

A) True 
 B)False

Question 16

____ is a Web application server that provides the ability to connect Web servers to multiple data sources.

Accepted Answer

A)  Access 
B)  ColdFusion/JRun 
C)  FoxPro 
D)  dBase 
A)  Access 
B)  ColdFusion/JRun 
C)  FoxPro 
D)  dBase

Question 17

The effects of bad database design, implementation, and management are multiplied in an environment in which transactions may be measured in hundreds of thousands per day, rather than in hundreds per day.

Accepted Answer

A) True 
 B)False

Question 18

A ____ is an external application that is automatically invoked by the browser when needed.

Accepted Answer

A)  Web client 
B)  plug-in 
C)  Web service 
D)  Web server 
A)  Web client 
B)  plug-in 
C)  Web service 
D)  Web server

Question 19

A database server-side extension is known as Web-to-database middleware.

Accepted Answer

A) True 
 B)False

Question 20

What is JavaScript?

Accepted Answer

JavaScript is a scripting language (one

APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.

A DBMS that supports ____ exchanges can integrate with external systems such as the Web, mobile data, and legacy systems, thus enabling the creation of new types of systems.

What is a disadvantage of using an API Web-server interface?

____ is a higher-level object-oriented application interface used to access remote database servers.

A(n) ____ file provides the composition of the database's logical model and defines the syntax rules for an XML document.

The ODBC API standard defines three levels of compliance: ____, Level-1, and Level-2, which provide increasing levels of functionality.

When using an Oracle database, your Web-to-database middleware can connect to the database via ____.

The creation and management of user interfaces and database connectivity are not affected by the Web's existence.

The ____ object is the in-memory representation of the data in the database.

Extending the Web server functionality implies that the Web server and the Web-to-database middleware will properly communicate with each other.

Database connectivity software is also known as database middleware because it interfaces between the application program and the database.

There are currently ____ well-defined Web-server interfaces.

What is the first step in the exchange between a Web browser and a database?

Of the following, what is one of the benefits of rapid development at manageable costs for Internet technologies?

Cloud services allow any organization to quickly and economically add information technology services such as applications, storage, servers, processing power, databases, and infrastructure to its IT portfolio.

____ is a Web application server that provides the ability to connect Web servers to multiple data sources.

The effects of bad database design, implementation, and management are multiplied in an environment in which transactions may be measured in hundreds of thousands per day, rather than in hundreds per day.

A ____ is an external application that is automatically invoked by the browser when needed.

A database server-side extension is known as Web-to-database middleware.

What is JavaScript?

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters

Exam 11: Interacting With Databases Through the Web

APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.

A DBMS that supports ____ exchanges can integrate with external systems such as the Web, mobile data, and legacy systems, thus enabling the creation of new types of systems.

What is a disadvantage of using an API Web-server interface?

____ is a higher-level object-oriented application interface used to access remote database servers.

A(n) ____ file provides the composition of the database's logical model and defines the syntax rules for an XML document.

The ODBC API standard defines three levels of compliance: ____, Level-1, and Level-2, which provide increasing levels of functionality.

When using an Oracle database, your Web-to-database middleware can connect to the database via ____.

The creation and management of user interfaces and database connectivity are not affected by the Web's existence.

The ____ object is the in-memory representation of the data in the database.

Extending the Web server functionality implies that the Web server and the Web-to-database middleware will properly communicate with each other.

Database connectivity software is also known as database middleware because it interfaces between the application program and the database.

There are currently ____ well-defined Web-server interfaces.

What is the first step in the exchange between a Web browser and a database?

Of the following, what is one of the benefits of rapid development at manageable costs for Internet technologies?

Cloud services allow any organization to quickly and economically add information technology services such as applications, storage, servers, processing power, databases, and infrastructure to its IT portfolio.

____ is a Web application server that provides the ability to connect Web servers to multiple data sources.

The effects of bad database design, implementation, and management are multiplied in an environment in which transactions may be measured in hundreds of thousands per day, rather than in hundreds per day.

A ____ is an external application that is automatically invoked by the browser when needed.

A database server-side extension is known as Web-to-database middleware.

What is JavaScript?

The Database Approach

Database Development Process

Data Models

Relational Model Characteristics

Beginning Structured Query Language Sql

Procedural Language Sql and Advanced Sql

Data Modeling With Entity Relationship Diagrams

Data Modeling Advanced Concepts

Normalizing Database Designs

Distributed Databases

Database Administration and Security

Managing Transactions and Concurrency

Managing Database and Sql Performance

Databases for Decision Support

Filters