CHAPTER 14: DATABASE CONNECTIVITY AND WEB TECHNOLOGIES
1. Database connectivity software is also known as database middleware because it interfaces between the
application program and the database.
a. True
b. False
2. An API (application programming interface) is defined as a set of routines, protocols, and tools for building
software applications.
a. True
b. False
3. A good API makes it easy to develop a program by providing all of the building blocks.
a. True
b. False
4. Among the three levels of compliance of the ODBC API standards, Level-1 provides support for procedural
SQL and cursors.
a. True
b. False
5. Having a web-based database interface eliminates the design and implementation issues of a database system.
a. True
b. False
and they require the same basic database structures and relationships.
a. True
b. False
7. The effects of bad database design, implementation, and management are magnified in an environment in which
the number of transactions is less than one hundred.
a. True
b. False
Chapter 14: Database Connectivity and Web Technologies
8. The benefits of the web as a data access platform arise from its cross-platform functionality and the simplicity of
its interface.
a. True
b. False
9. A web server is the main hub through which all Internet services are accessed.
a. True
b. False
10. When an end user uses a web browser to dynamically query a database, the client browser actually requests a
web page from the web server.
a. True
b. False
11. In the database query scenario, the web server generates the webpage contents before it sends the page to the
client web browser.
a. True
b. False
12. A client-side extension is a program that interacts directly with the web server to handle specific types of
requests.
a. True
b. False
13. Extending the web server functionality implies that the web server and the web–to-database middleware will
properly communicate with each other.
a. True
b. False
and faster than a dynamic link library (DLL).
a. True
b. False
Chapter 14: Database Connectivity and Web Technologies
15. An application programming interface (API) uses script files that perform specific functions based on the client’s
parameters that are passed to the web server.
a. True
b. False
16. APIs are implemented as dynamic-link libraries that are dynamically invoked when needed.
a. True
b. False
17. The browser’s interpretation and presentation capabilities are sufficient to develop web-based applications.
a. True
b. False
18. The label “stateless system” indicates that, at any given time, there is an open communication line between the
server and each client accessing it.
a. True
b. False
19. 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.
a. True
b. False
20. The use of HTML does not equip a web browser with computational abilities beyond formatting output text and
accepting form field inputs.
a. True
b. False
21. A plug–in is an external application that is automatically invoked by a web browser when needed.
a. True
b. False
Chapter 14: Database Connectivity and Web Technologies
22. HTML is designed to facilitate the extraction and manipulation of data from structured documents over the
Internet.
a. True
b. False
23. The first line of an XML document represents the document declaration, and it is mandatory.
a. True
b. False
24. In a document type definition (DTD) file, a plus (+) symbol beside an element indicates that it is an optional child
element within its parent.
a. True
b. False
25. A document type definition (DTD) can be referenced by many Extensible Markup Language (XML) documents
of the same type.
a. True
b. False
26. Cloud services allow any organization to quickly and economically add information technology services to its IT
portfolio.
a. True
b. False
27. The initial costs of using cloud services tend to be significantly higher than building on-premise IT infrastructures.
a. True
b. False
28. 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
Chapter 14: Database Connectivity and Web Technologies
29. ODBC works on the operating system.
a. Kronos b. UNIX
c. Windows d. Mac
30. is a higher-level, object-oriented application interface used to access remote database servers.
a. UDA b. ODBC
c. DAO d. RDO
31. 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
32. 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
33. 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
34. 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
35. In the ADO.NET framework, the object is the in-memory representation of the data in the database.
a. Command b. DataReader
c. DataAdapter d. DataSet
36. The is the most specialized object in the ADO.NET framework.
a. Command b. DataReader
c. DataAdapter d. DataSet
Chapter 14: Database Connectivity and Web Technologies
37. 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
38. 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
39. Another name for a database server-side extension program is .
a. a web server b. a web application middleware
c. web-to-database middleware d. a database application server
40. Which of the following is the first step in the exchange between a web browser and a 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.
41. Which of the following is the last step in the exchange between a web browser and a 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.
42. 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
Chapter 14: Database Connectivity and Web Technologies
43. 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.
44. 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
45. 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.
46. 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
47. 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.
48. You must use plug-ins and other client–side extensions:
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.
49. Which of the following is a client-side extension?
a. ActiveX b. ODBC
c. SQL*Net d. TCP/IP
Chapter 14: Database Connectivity and Web Technologies
50. Among client-side extensions, is a Microsoft specification for writing programs that run inside the
Internet Explorer browser.
a. COBOL b. ActiveX
c. JavaScript d. Visor.Net
51. _____ is a scripting language that allows web authors to design interactive sites.
a. Visual Basic b. HTML
c. JavaScript d. Java
52. Which of the following is true of a web application server?
a. It is Microsoft’s implementation of a superset of the SQL Access Group CLI standard for database access.
b. It is automatically invoked by the browser when needed.
c. It runs on the client machine, freeing server resources.
d. It provides security and authentication of users through user IDs and passwords.
53. code is embedded inside an HTML page and is activated by triggering events such as clicking on a link.
a. XML b. SQL
c. Visual Basic d. VBScript
54. is a web application server that provides the ability to connect web servers to multiple data sources.
a. MS Access b. ColdFusion/JRun
c. FoxPro d. dBase
55. Which of the following is a characteristic of the XML metalanguage?
a. It is concerned with the way data are displayed.
b. It allows the definition of new tags.
c. You can use the // symbol for entering a comment in the XML document.
d. It can be used as a replacement of HTML.
56. Every XML document has a .
a. root element b. base tag
c. schema d. DTD
Chapter 14: Database Connectivity and Web Technologies
57. A(n) file provides the composition of the database’s logical model and defines the syntax rules for an
XML document.
a. XMLD b. XHTML
c. DTD d. meta
58. The _____ is an advanced data definition language that is used to describe the structure of XML data
documents.
a. XHTML b. HTML schema
c. DTD d. XML schema
59. Using , you can extract data from an XML document and convert it into a text file.
a. XMLD b. XSLT
c. DTD d. XML schema
60. cloud is a type of cloud infrastructure that is built by a third-party organization to sell cloud services to the
general public.
a. Community b. Public
c. Exclusive d. Private
61. In the category, the cloud service provider offers the capability to build and deploy consumer–created
applications using the provider’s cloud infrastructure.
a. Application as a Service (AaaS) b. Infrastructure as a Service (IaaS)
c. Software as a Service (SaaS) d. Platform as a Service (PaaS)
62. ODBC, OLE-DB, and ADO.NET form the backbone of the architecture.
63. Open Database Connectivity (ODBC), a superset of the SQL Access Group Call Level Interface
(CLI), is implemented by .
64. A(n) is a unique name by which the data source will be known to ODBC, and therefore, to applications.
Chapter 14: Database Connectivity and Web Technologies
65. In the context of OLE-DB, a is an object (application or process) that requests and uses data.
66. In the OLE-DB model, the acts like a data consumer of the data provider and as a data provider for the
data consumer (end–user application).
67. A(n) _____ is a program written in a programming language that is not compiled, but is interpreted and
executed at run time.
68. provides a unified interface to access data from any programming language that uses the underlying
OLE- DB objects.
69. The Microsoft framework is a component-based platform for developing distributed, heterogeneous,
interoperable applications aimed at manipulating any type of data over any network under any operating system
and any programming language.
70. is an application programming interface that allows a Java program to interact with a wide range of data
sources (relational databases, tabular data sources, spreadsheets, and text files).
71. webpages are at the heart of current generation websites.
72. APIs are faster than scripts because the code resides in memory and there is no need to run an external
program for each request.
73. Regardless of the type of web server interface used, a web-to-database program must be able to
connect with a database.
74. A web server is a middleware application that expands the functionality of web servers by linking them to
a wide range of services.
Chapter 14: Database Connectivity and Web Technologies
75. To prevent the server from performing all data validation, data input validation is one of the most basic
requirements for web applications.
76. , or transactions done over the Internet, enables all types of organizations to sell products and services to
a global market.
77. XML is derived from the , an international standard for the publication and distribution of highly complex
technical documents.
78. XML tags must be well formed, that is, each opening tag must have a corresponding tag.
79. A(n) provides limited additional semantic value to XML, such as data type support or data validation
rules.
80. 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.
81. What are the components in the basic ODBC architecture?
Chapter 14: Database Connectivity and Web Technologies
82. What are the main types of objects in the OLE-DB model? Explain.
83. What is a server-side extension? Explain.
84. What is JavaScript? How does it work?
85. Explain the features provided by web application servers.