Question 1

The main disadvantage of using CGI scripts is that:
A) they cause a resource bottleneck since they have to execute separately for each user request.
B) they are specific to the web server and to the operating system, thus being platform dependent.
C) an error in one script can damage and bring down the web server completely.
D) they do not have the capability to process forms or prepare outputs based on form data.

Accepted Answer

CGI scripts require a separate process to be executed for each user request, which can slow down the server and cause a resource bottleneck. This is a major disadvantage compared to other server-side scripting technologies such as PHP or ASP.NET, which are designed to handle multiple requests concurrently. The other choices are not accurate as CGI scripts are platform dependent but can be used with popular web servers like Apache and Nginx, an error in one script may cause it to fail but not bring down the entire server, and CGI scripts can process forms and generate outputs based on form data.

Question 2

Each time an end user clicks a hyperlink, the browser generates a(n) _____ page request that is sent to the designated web server using the TCP/IP Internet protocol.
A) HTML
B) XML
C) HTTP GET
D) API

Accepted Answer

The HTTP GET request is used by the browser to request a particular webpage from the server. The request is sent over the Internet protocol TCP/IP. HTML and XML are markup languages used to structure and display content on web pages, while APIs are sets of protocols and routines used to build software applications.

Question 3

_____ is a higher-level, object-oriented application interface used to access remote database servers.
A) UDA
B) ODBC
C) DAO
D) RDO

Accepted Answer

RDO (Remote Data Objects) is a higher-level, object-oriented application interface used to access remote database servers. UDA (Universal Data Access) is a concept rather than a specific technology, ODBC (Open Database Connectivity) is a lower-level interface and DAO (Data Access Objects) was used in earlier versions of Microsoft Access.

Question 4

The ODBC API standard defines three levels of compliance: _____, Level-1, and Level-2, which provide increasing levels of functionality.
A) Elementary
B) Basic
C) Core
D) Level-0

Accepted Answer

The ODBC API standard defines three levels of compliance as Core, Level-1, and Level-2, with Core being the most basic level of functionality.

Question 5

One of the advantages of _____ over other middleware is that it requires no configuration on the client side.
A) ODBC
B) JDBC
C) OLE-DB
D) ADO.NET

Accepted Answer

JDBC (Java Database Connectivity) requires no configuration on the client side, as it is a Java-based middleware that provides a standard interface for connecting Java applications to relational databases. ODBC (Open Database Connectivity), OLE-DB (Object Linking and Embedding Database), and ADO.NET (ActiveX Data Objects for .NET) require some form of client-side configuration or installation of drivers.

Question 6

_____ is a collection of technologies used to access any type of data source and manage the data through a common interface.
A) DAO
B) UDA
C) ODBC
D) OLE-DB

Accepted Answer

The answer of _____ is a collection of technologies used...

Question 7

You must use plug-ins and other client-side extensions to:
A) create an open communication line between a server and its clients.
B) eliminate the need for running external programs for each client request.
C) improve processing capabilities of a browser.
D) create dynamic web search pages.

Accepted Answer

Plug-ins and other client-side extensions can be used to improve the processing capabilities of a browser. This can be achieved through various means, such as improving the rendering of graphics, enhancing video playback, or enabling the execution of advanced scripting languages. However, plug-ins and extensions do not necessarily create an open communication line between a server and its clients, eliminate the need for external programs, or create dynamic search pages.

Question 8

In the ADO.NET framework, the _____ is a disconnected, memory-resident representation of the database.
A) Command
B) DataReader
C) DataAdapter
D) DataSet

Accepted Answer

A DataSet is a collection of DataTables that represent the structure and data of a database. It is a disconnected, memory-resident representation of the database that can be used for data manipulation and data binding in client applications. The other options are used for different purposes in ADO.NET: Command is used to execute database commands, DataReader is used for fast, read-only access to data, and DataAdapter is used to fill a DataSet with data from a data source.

Question 9

_____ is an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software.
A) Visual Basic
B) Java
C) JavaScript
D) VBScript

Accepted Answer

Only Java fits the given description as being an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software. Visual Basic and VBScript require a separate runtime environment and JavaScript, while similar in name, is not directly related to Java and does not require a separate runtime environment.

Question 10

What is a disadvantage of using an API web-server interface?
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.

Accepted Answer

The answer of What is a disadvantage of using an...

Question 11

Which of the following is a well-defined web-server interface?
A) Common Gateway Interface
B) Tiny Internet Interface
C) Windows NT
D) Command Line Interface

Accepted Answer

The Common Gateway Interface (CGI) is a well-defined web-server interface that allows web servers to execute external programs and scripts, and pass data between the web server and these programs. The other options, Tiny Internet Interface and Command Line Interface, are not web-server interfaces, and Windows NT is an operating system.

Question 12

In the ADO.NET framework, the _____ object contains the actual SQL code or a stored procedure call to be run by the database.
A) Command
B) DataReader
C) DataAdapter
D) DataSet

Accepted Answer

The Command object in ADO.NET contains actual SQL code or a stored procedure call to be run by the database. It also manages the connections, transactions, and parameters associated with executing the command. The DataReader, DataAdapter, and DataSet objects are all used for retrieving and manipulating data from a database, but they do not contain the actual SQL code or a stored procedure call.

Question 13

In the ODBC architecture, a(n) _____ is in charge of managing all database connections.
A) ODBC API
B) DLL
C) ODBC driver
D) driver manager

Accepted Answer

The driver manager in the ODBC architecture is responsible for managing all database connections. It is responsible for loading the appropriate ODBC driver, establishing and terminating connections, and managing transactions. The ODBC API is a collection of functions used by applications to interact with the ODBC driver manager. The DLL (Dynamic Link Library) is a file that contains code and data that can be shared by multiple programs at runtime. The ODBC driver is responsible for communicating with a specific database management system.

Question 14

Which is a client-side extension?
A) ActiveX
B) ODBC
C) SQL*Net
D) TCP/IP

Accepted Answer

ActiveX is a client-side extension that allows for interactive content to be displayed in a web browser. ODBC, SQL*Net, and TCP/IP are all network protocols used for communication between client and server, but are not necessarily client-side extensions.

Question 15

Another name for a database server-side extension program is _____.
A) web server
B) web application middleware
C) web-to-database middleware
D) database application server

Accepted Answer

A database server-side extension program is also known as web-to-database middleware. This is a software layer that sits between the web server and the database system, handling interactions between the two. It can be used to improve the security, performance, and functionality of web applications that rely on access to a database. Options A, B, and D are not accurate descriptions of a database server-side extension program.

Question 16

The _____ is the most specialized object in the ADO.NET framework.
A) Command
B) DataReader
C) DataAdapter
D) DataSet

Accepted Answer

The answer of The _____ is the most specialized object...

Question 17

The web browser's job is to interpret the HTML code that it receives from a web server and to:
A) develop web-based applications.
B) display it in a standard formatted way.
C) perform immediate data entry validation.
D) extract details, such as order data, from it.

Accepted Answer

The web browser's primary job is to display HTML code in a standardized format.

Question 18

A(n) _____ can use a shared connection to the database instead of creating a new one every time.
A) DLL
B) API
C) web browser
D) HTTP GET request

Accepted Answer

An API (Application Programming Interface) can use a shared connection to the database instead of creating a new one every time, allowing for more efficient and optimized database communication. DLL (Dynamic Link Library) is a file containing executable code used by a program, but it does not directly relate to database connection. Web browsers and HTTP GET requests can access resources on the web, but they are not specifically designed for database communication.

Question 19

Based on Microsoft's Component Object Model (COM), _____ is database middleware that adds object-oriented functionality for access to relational and nonrelational data.
A) MS-DB
B) OLE-DB
C) COM-DB
D) ODBC

Accepted Answer

OLE-DB is the correct choice as it is the database middleware technology based on Microsoft's Component Object Model (COM) that provides object-oriented access to relational and non-relational data sources. MS-DB and COM-DB are not valid options, while ODBC is a different middleware technology.

Question 20

ODBC works on the _____ operating system.
A) Kronos
B) UNIX
C) Windows
D) Mac

Accepted Answer

ODBC (Open Database Connectivity) is a Windows-based technology and works on Windows operating system. While it may be possible to use ODBC on other operating systems with the help of additional software or tools, it is primarily designed and supported for Windows.

Quiz 15: Database Connectivity and Web Technologies

The main disadvantage of using CGI scripts is that:

Each time an end user clicks a hyperlink, the browser generates a(n) _____ page request that is sent to the designated web server using the TCP/IP Internet protocol.

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

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

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

_____ is a collection of technologies used to access any type of data source and manage the data through a common interface.

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

In the ADO.NET framework, the _____ is a disconnected, memory-resident representation of the database.

_____ is an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software.

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

Which of the following is a well-defined web-server interface?

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

In the ODBC architecture, a(n) _____ is in charge of managing all database connections.

Which is a client-side extension?

Another name for a database server-side extension program is _____.

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

The web browser's job is to interpret the HTML code that it receives from a web server and to:

A(n) _____ can use a shared connection to the database instead of creating a new one every time.

Based on Microsoft's Component Object Model (COM) , _____ is database middleware that adds object-oriented functionality for access to relational and nonrelational data.

ODBC works on the _____ operating system.