Chapter 14

A document type definition DTD can be referenced by many Extensible Markup Language XML documents of the same type a. true b. false

a

A good API makes it easy to develop a program by providing all of the building blocks a. true b. false

a

A plug in is an external application that is automatically invoked by a web browser when needed. a. true b. false

a

A web server is the main hub through which all Internet services are accessed a. true b. false

a

APIs are implemented as dynamic-link libraries that are dynamically invoked when needed a. true b. false

a

An API is defined as a set of routines, protocols, and tools for building software applications a. true b. false

a

Cloud services allow any organization to quickly and economically add information technology services to its IT portfolio. a. true b. false

a

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

a

Every XML document has a _____. a. root element b. base tage c. schema d. DTD

a

Extending the web server functionally implies that the web server and the web-to-database middleware will properly communicate with each other a. true b. false

a

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. dataset c. dataadapter d. datareader

a

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

a

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

a

The first line of an XML document represents the document declaration, and it is mandatory a. true b. false

a

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

a

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

a

When an end user uses a web browser to dynamically query a database, the client browser actually request a web page from the web server a. true b. false

a

Whether you purchase online or by standing in line, the system-level transaction details are essentially the same and they require the same basic database structures and relationships a. true b. false

a

Which of the following is a well defined web-server interface? a. common gateway interface b. command line interface c. tiny internet interface d. window NT

a

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 web browser request a page from a web server c. the web-to-database middleware uses ODBC to connect to the database. d. the middleware receives the query result and creates the HTML-formatted page

a

______ is a collection of technologies used to access any type of data source and manage the data through a common interface a. UDA b. DAO c. ODBC d. OLE-DB

a

______ is a scripting language that allows web authors to design interactive sites a. javascript b. HTML c. java d. visual basic

a

which of the following is true of a web application server? a. it provides security and authentication of users through users IDs and passwords b. it is microsofts implementation of a superset of the sql access group CLI standard for database access. c. it is automatically invoked by the browser when needed d. it runs on the client machine, freeing server resources

a

A client-side extension is a program that interacts directly with the web server to handle specific types of request. a. true b. false

b

A(N) ______ can use a shared connection to the database instead of creating a new one every time a. DLL b. API c. HTTP GET request d. web browser

b

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

b

An application programming interface uses script files that perform specific functions based on the client's parameters that are passed to the web server. a. true b. false

b

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. API b. HTTP GET c. HTML d. XML

b

HTML is designed to facilitate the extraction and manipulation of data from structured documents over the internet a. true b. false

b

Having a web-based database interface eliminates the design and implementation issues of database system a. true b. false

b

In a document type defintion DTD file a plus + symbol beside an element indicates that it is an optional element within its parent a. true b. false

b

The ______ is an advanced definition language that is used to describe the structure of XML data documents a. XHTML b. XML schema c. DTD d. HTML schema

b

The browser's interpretation and presentation capabilities are sufficient to develop web-based applications. a. true b. false

b

The common gateway interface is a newer web server interface standard that is much more efficient and faster than a dynamic link library a. true b. false

b

The effects of bad design, implementation, and management are magnified in an environment in which the number of transactions is less than one hundred a. true b. false

b

The initial costs of using cloud services tend to be significantly higher building on-premise IT infrastructures. a. true b. false

b

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

b

Using ______, you can extract data from an XML document and convert it into text file a. XMLD b. XSLT c. XML schema d. DTD

b

_____ is a higher-level, object-oriented application interface used to access remote database servers a. ODBC b. RDO c. UDA d. DAO

b

A(N) ____ file provides the composition of the database's logical model and defines the syntax rules for an XML document. a. meta b. XMLD c. DTD d. XHTML

c

Among client-side extensions, ______ is a microscoft specification for writing programs that run inside the internet explorer browser a. visor.net b.JavaScript c. ActiveX d. COBOL

c

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. software as a service (SaaS) c. Platform as a Service (PaaS) d. Infrastructure as a Service (IaaS)

c

ODBC works on the ____ operating system. a. mac b. kronos c. windows d. unix

c

One of the advantages of ____ over other middleware is that it requires no configuration on the client side a. ADO.NET b. ODBC c. JDBC d. OLE-DB

c

_______ cloud is type of cloud infrastructure that is built by a third-party organization to sell cloud services to the general public a. exclusive b. private c. public d. community

c

what is a disadvantage of using an API web-server interface? a. it is lower that CGI scripts b. it is inefficient because it uses DLLs c. An API error can bring down the entire web server d. an external program needs to run for each user request

c

which of the following is a client-side extension? a. TCP/IP b. Sql*Net c. ActiveX d. ODBC

c

which of the following is the first step in the exchange between a web browser and a database? a. the web-to-database middleware uses ODBC to connect to the database 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 HTML output is displayed on the client computer's web browser

c

Another name for a database server-side extension program is ______. a. a database application server b. a web server c. a web application middleware d. web-to-database middleware

d

In the ODBC architecture, a(n) _______ is in charge of managing all database connections a. DLL b. ODBC API c. ODBC driver d. driver manager

d

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

d

Which of the following is a characteristic of the XML metalanguage? a. it can be used as replacement of HTML b. you can use the // symbol for entering a comment in the XML document c. it is concerned with the way data are displayed d. it allows the definition of new taxes

d

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

d

______ code is embedded inside an HTML page and its activated by triggering events such as clicking on a link a. SQL b. XML c. Visual Basic d. VBScript

d

______ is an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software. a. VBScript b. visual basic c. javascript d. java

d

_______ is a web application server that provides the ability to connect web servers to multiple data sources a. dBAse b. MS Access c. Fox Pro d. ColdFusion/Jrun

d

the web browser's job is to interpret the HTML code that it receives from a web server and to a. extract details, such as order data from it b. perform immediate data entry validation c. develop web-based applications d. display it in a standard format way

d