cis-09

10) A computer that provides database storage and access in a client/server environment is called a(n): A) database server. B) file server. C) cloud data store. D) info server.

A

12) Sets of routines that an application program uses to direct the performance of procedures by the computer's operating system is called a(n): A) application program interface. B) XPI C) application device interface. D) CMOS.

A

20) Extensible Markup Language (XML) is: A) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations. B) a database language. C) a product used for database middleware. D) a special SQL command to JOIN tables.

A

21) ________ is a rapidly developing scripting language that allows for the creation of customized tags that can be used across applications. A) XML B) HTML C) SGL D) CGI

A

25) ---------------Controls appearance of Web elements in an HTML document. A) CSS B) XML C) HTML D) HTTP

A

3) ________ is the process of assigning pieces of application code to clients or servers. A) Application partitioning B) Modularizing programs C) Code distribution D) Program breakup

A

8) A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer's operating system. A) API B) MON C) RPC D) LAN

A

11) An application programming interface that enables an application program to process RDBMS databases meets the: A) object linking and embedding standard. B) open database connectivity standard. C) multi-platform connectivity standard. D) open source standard.

B

13) The ________ specification allows drivers to conform to various levels of the specification, and that affects the level of functionality of the drivers. A) JDBC B) ODBC C) CORBA D) JAVA

B

14) A Web server: A) is used only to host Web pages. B) processes client requests and returns HTML pages to the client. C) always contains a database. D) is considered to be part of the firewall. Answer: B

B

17) Which of the following is NOT a disadvantage of stored procedures? A) Writing stored procedures takes more time than writing an application in Visual Basic or PowerBuilder. B) Decreases in network traffic are realized. C) Stored procedures are proprietary and not easy to move from one RDBMS to another. D) Each client must be loaded with the application to be used at that location.

B

22) All of the following are concerns about developing a Web services approach EXCEPT: A) transaction speed. B) user acceptability. C) security. D) reliability.

B

5) Which of the following is NOT common distribution logic for two-tiered server environments? A) Fat client B) Tall client C) Thin client D) Distributed

B

6) ________ is/are any of several classes of software that allow an application to interoperate with other software without requiring the user to understand all software involved. A) User interface enhancers B) Middleware C) Interface managers D) MPP

B

24) Which one is not a benefit of Three-Tier Architectures? A) Scalability B) Flexibility C) High risk D) Cost reduction

C

4) The client/server architectures that have evolved can be distinguished by the distribution of ________ across clients and servers. A) memory B) files C) application logic components D) query logic components

C

7) A PC configured to handle user interface with little or no local storage is called a: A) server. B) fat client. C) thin client. D) workstation.

C

9) Which of the following is true about three-tier architectures? A) Less scalable than two-tier B) Increased risk C) More technological flexibility D) Requires a Mac

C

C) CSS

Cascading Style Sheets

C) CGI

Computer-Generated Imagery

1) Which of the following is a component of processing logic? A) Input B) Output C) Retrieval D) Business rules

D

15) A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server. A) SQL program B) select module C) select procedure D) stored procedure

D

16) Which of the following is an advantage of stored procedures? A) Data integrity improves when fewer applications access the procedure. B) The layers get cleaner. C) Stored procedures result in fatter clients. D) Performance improves for compiled SQL statements.

D

18) The phrase ________ refers to a model for providing ubiquitous, convenient and on-demand network access. A) software services B) grid computing C) network computing D) cloud computing

D

19)A module of code that may be written in a proprietary language such as Oracle's PL/SQL that implements business rules on a database server is called a(n): A) persistent module. B) function. C) application component. D) stored procedure.

D

2) A client PC that is responsible for processing presentation logic, extensive application and business rules logic as well as many DBMS functions is called a: A) file server. B) file processor. C) database server. D) fat client.

D

23) ---------------- is to continue to function well when it is changed in size or volume in order to meet a user need. A) Flexibility B) Security C) Redundancy D) Scalability

D

B) XML

Extensible Markup Language

A) GUI

Graphical User Interface

D) HTTP

Hypertext Transfer Protocol

B) RDP

Remote Desktop Protocols

D) SGML

Standard Generalized Markup Language

A) TCP/IP

Transmission Control Protocol/Internet Protocol