1. When building a distributed application, you suggest the use of ADO.NET because of the use of DataSets. How does the use of DataSets in ADO.NET facilitate the development of distributed applications?
Having a local copy reduces the data transference.
2.In a CGI system the server is in charge of
invoking an external program to execute the script file.
3. SDS provides _____________ that features things like triggers, reporting, and analytical functions.
hosted data management
4. Consider an XML file with the following content:
body is a subelement of content.
5. Based on Microsoft’s Component Object Model (COM), _____ is database middleware that adds object-oriented functionality for access to relational and nonrelational data.
OLE-DB
6. A programmer is in charge of writing an API for managing the recollection of information in several databases. Among the databases are several different providers. Is it possible to use an API model?
Yes, any type of middleware can connect to a database using ODBC, OLE-DB, ADO or JDBC.
7. What feature of a Web Application Server is particularly important when creating web pages to insert, update, and delete database applications?
Database access with transaction management capabilities.
8. A company needs to provide to its employees a storage service for documents related to their work. It is decided to use a cloud service. What type of cloud implementation is needed?
Private cloud.
9. Why does the use of web servers make the development of solutions faster?
The web browser provides an access tool that doesn’t require development.
10. When using web database development, if a database needs to be accessed which of the following is the last thing to be done?
Close all the database connections.
11. To reduce the load on the server side, a programmer wants to execute some basic data checking in a form before it is sent. Which of the following is true about a possible solution?
It can be done using a scripting language such as javascript.
12. A programmer is responsible for writing an application that reads data from a database. The program will be used in different environments, not only on windows machines. Which of the following is the best approach to develop a solution?
Use JDBC
13. Why could a solution using javascript be considered more portable than a solution using ActiveX?
ActiveX is dependent on Microsoft products.
14. A programmer needs to build a simple client-server application, although it is a very simple application, it is critical to prevent crashes. Which of the following features is an important reason to make use of a web application service?
Performance and fault-tolerant features.
15. _____ is a web application server that provides the ability to connect web servers to multiple data sources.
ColdFusion/JRun
16. Which of the following is a characteristic of the XML metalanguage?
It allows the definition of new tags.
17. A company needs a server to house its RDBM and data. The company doesn’t have the physical resources such as servers, storage space, and internet connections to do this. But they have the necessary IT and software personnel to manage the database. It is decided to hire a cloud service to meet the company’s needs. What type of cloud service is necessary for this situation?
IaaS
18. A web _____ server is a middleware application that expands the functionality of web servers by linking them to a wide range of services.
application
19. You suggest to a programmer changing the use of only native database connectivity interfaces. Which of the following is a reason to argue in favor of the change?
A programmer must maintain one interface per vendor.
20. _____ refer(s) to a cloud computing-base data management service that provides relational data storage, access, and management to companies of all sizes without the typical high costs of in house hardware, software, infrastructure, and personnel.
SQL data services