Question 1

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

Accepted Answer

A)  It is slower than CGI scripts. 
B)  It is inefficient because it uses DLLs. 
C)  An external program needs to run for each user request. 
D)  An API error can bring down the entire web server. 
A)  It is slower than CGI scripts. 
B)  It is inefficient because it uses DLLs. 
C)  An external program needs to run for each user request. 
D)  An API error can bring down the entire web server.

Question 2

Among the three levels of compliance of the ODBC API standards, Level-1 provides support for procedural SQL and cursors.

Accepted Answer

A) True 
 B)False

Question 3

The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client.

Accepted Answer

A) True 
 B)False

Question 4

HTML is designed to facilitate the extraction and manipulation of data from structured documents over the Internet.

Accepted Answer

A) True 
 B)False

Question 5

You must use plug-ins and other client-side extensions:

Accepted Answer

A)  to create an open communication line between a server and its clients. 
B)  to eliminate the need for running external programs for each client request. 
C)  to improve processing capabilities of a browser. 
D)  to create dynamic web search pages. 
A)  to create an open communication line between a server and its clients. 
B)  to eliminate the need for running external programs for each client request. 
C)  to improve processing capabilities of a browser. 
D)  to create dynamic web search pages.

Question 6

Every XML document has a .

Accepted Answer

A)  root element 
B)  base tag 
C)  schema 
D)  DTD 
A)  root element 
B)  base tag 
C)  schema 
D)  DTD

Question 7

ODBC, OLE-DB, and ADO.NET form the backbone of the architecture.

Accepted Answer

UDA
Universal Data A

Question 8

Which of the following is the last 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 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 web browser requests a page from a web server. 
D)  The web-to-database middleware uses ODBC to connect to the database.

Question 9

What is a server-side extension? Explain.

Accepted Answer

A server-side extension is a program tha

Question 10

, or transactions done over the Internet, enables all types of organizations to sell products and services to a global market.

Accepted Answer

The answer of , or transactions done over the Internet,...

Question 11

ODBC works on the operating system.

Accepted Answer

A)  Kronos 
B)  UNIX 
C)  Windows 
D)  Mac 
A)  Kronos 
B)  UNIX 
C)  Windows 
D)  Mac

Question 12

The Common Gateway Interface (CGI) is a newer web server interface standard that is much more efficient and faster than a dynamic link library (DLL).

Accepted Answer

A) True 
 B)False

Question 13

In the category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider's cloud infrastructure.

Accepted Answer

A)  Application as a Service (AaaS) 
B)  Infrastructure as a Service (IaaS) 
C)  Software as a Service (SaaS) 
D)  Platform as a Service (PaaS) 
A)  Application as a Service (AaaS) 
B)  Infrastructure as a Service (IaaS) 
C)  Software as a Service (SaaS) 
D)  Platform as a Service (PaaS)

Question 14

The is the most specialized object in the ADO.NET framework.

Accepted Answer

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

Question 15

One of the advantages of over other middleware is that it requires no configuration on the client side.

Accepted Answer

A)  ODBC 
B)  JDBC 
C)  OLE-DB 
D)  ADO.NET 
A)  ODBC 
B)  JDBC 
C)  OLE-DB 
D)  ADO.NET

Question 16

Which of the following is a client-side extension?

Accepted Answer

A)  ActiveX 
B)  ODBC 
C)  SQL*Net 
D)  TCP/IP 
A)  ActiveX 
B)  ODBC 
C)  SQL*Net 
D)  TCP/IP

Question 17

In the ADO.NET framework, the object contains the actual SQL code or a stored procedure call to be run by the database.

Accepted Answer

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

Question 18

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 19

Regardless of the type of web server interface used, a web-to-database program must be able to connect with a database.

Accepted Answer

The answer of Regardless of the type of web server...

Question 20

The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.

Accepted Answer

A) True 
 B)False

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

Among the three levels of compliance of the ODBC API standards, Level-1 provides support for procedural SQL and cursors.

The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client.

HTML is designed to facilitate the extraction and manipulation of data from structured documents over the Internet.

You must use plug-ins and other client-side extensions:

Every XML document has a .

ODBC, OLE-DB, and ADO.NET form the backbone of the architecture.

Which of the following is the last step in the exchange between a web browser and a database?

What is a server-side extension? Explain.

, or transactions done over the Internet, enables all types of organizations to sell products and services to a global market.

ODBC works on the operating system.

The Common Gateway Interface (CGI) is a newer web server interface standard that is much more efficient and faster than a dynamic link library (DLL).

In the category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider's cloud infrastructure.

The is the most specialized object in the ADO.NET framework.

One of the advantages of over other middleware is that it requires no configuration on the client side.

Which of the following is a client-side extension?

In the ADO.NET framework, the object contains the actual SQL code or a stored procedure call to be run by the database.

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

Regardless of the type of web server interface used, a web-to-database program must be able to connect with a database.

The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Administration and Security

Filters

Exam 14: Database Connectivity and Web Technologies

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

Among the three levels of compliance of the ODBC API standards, Level-1 provides support for procedural SQL and cursors.

The only time the client and server computers communicate is when the client requests a page and the server sends the requested page to the client.

HTML is designed to facilitate the extraction and manipulation of data from structured documents over the Internet.

You must use plug-ins and other client-side extensions:

Every XML document has a .

ODBC, OLE-DB, and ADO.NET form the backbone of the architecture.

Which of the following is the last step in the exchange between a web browser and a database?

What is a server-side extension? Explain.

, or transactions done over the Internet, enables all types of organizations to sell products and services to a global market.

ODBC works on the operating system.

The Common Gateway Interface (CGI) is a newer web server interface standard that is much more efficient and faster than a dynamic link library (DLL).

In the category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider's cloud infrastructure.

The is the most specialized object in the ADO.NET framework.

One of the advantages of over other middleware is that it requires no configuration on the client side.

Which of the following is a client-side extension?

In the ADO.NET framework, the object contains the actual SQL code or a stored procedure call to be run by the database.

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

Regardless of the type of web server interface used, a web-to-database program must be able to connect with a database.

The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of its interface.

Database Systems

Data Models

The Relational Database Model

Entity Relationship Er Modeling

Advanced Data Modeling

Normalization of Database Tables

Introduction to Structured Query Language Sql

Advanced Sql

Database Design

Transaction Management and Concurrency Control

Database Performance Tuning and Query Optimization

Distributed Database Management Systems

Business Intelligence and Data Warehouses

Database Administration and Security

Filters