Chapter 8 Flashcards Preview

Database > Chapter 8 > Flashcards

Flashcards in Chapter 8 Deck (44)
Loading flashcards...
1
Q

Which of the following have affected the way businesses use computing systems to meet the demand of the competitive marketplace?

A

A) GUI evolutions B) Networking advances C) Communication changes D) All of the above

2
Q

2) Which of the following is a component of processing logic?

A

D) Business rules

3
Q

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(n):

A

D) fat client.

4
Q

________ is the process of assigning pieces of application code to clients or servers.

A

A) Application partitioning

5
Q

Which of the following is not a common distribution logic for two-tiered server environments?

A

A) Fat client

6
Q

________ 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

B) Middleware

7
Q

A(n) ________ is a set of application routines that programs use to direct the performance of procedures by the computer’s operating system.

A

A) API

8
Q

An application programming interface that enables an application program to process RDBMS databases meets the:

A

B) open database connectivity standard.

9
Q

A PC configured to handle user interface with little or no local storage is called a:

A

C) thin client.

10
Q

A Web server:

A

B) processes client requests and returns HTML pages to the client.

11
Q

The main difference between Java applets and Java servlets is:

A

B) servlets are stored on the server while applets are stored on the client.

12
Q

Java servlets:

A

A) are small programs that execute from within another application rather than from the operating system.

13
Q

PHP is a popular API for MySQL because of all of the following EXCEPT:

A

A) Microsoft integration.

14
Q

A(n) ________ is a module of code written in SQL or some proprietary language to run business rules on a server.

A

D) stored procedure

15
Q

Which of the following is an advantage of stored procedures?

A

D) Performance improves for compiled SQL statements.

16
Q

Which of the following is not a disadvantage of stored procedures?

A

B) Decreases in network traffic are realized.

17
Q

Which of the following is true about three-tier architectures?

A

C) More technological flexibility

18
Q

An emerging trend likely to have an effect on the development of three-tier applications is called:

A

C) cloud computing.

19
Q

All of the following are characteristics of cloud technologies EXCEPT:

A

A) unlimited bandwidth.

20
Q

Extensible Markup Language (XML) is:

A

A) a scripting language that allows the creation of customized tags to enable easier sharing of data across organizations.

21
Q

Extensible Business Reporting Language (XBRL) is an example of:

A

B) an XML-based vocabulary.

22
Q

________ facilitates the ability of applications to query relational data along with associated structured data.

A

A) XPath

23
Q

All of the following are newer XML schema languages EXCEPT:

A

A) Document Type Declarations (DTDs).

24
Q

When an XML document is shredded, each element is:

A

C) stored in a relational table.

25
Q

Which of the following is NOT a method for storing XML documents?

A

D) Convert to text

26
Q

FLWOR is an acronym for:

A

B) For, LET, Where OrderBy, Return.

27
Q

________ is a language used to transform complex XML documents and also to create HTML pages from XML documents.

A

B) XSLT

28
Q

Web services:

A

B) are a set of emerging standards for protocols for automatic communication between software over the Web.

29
Q

The promise of Web services is the development of a standardized communication system using:

A

C) XML.

30
Q

Client/server describes a networked computing model that distributes processes between computers that request services and computers that provide services.

A

TRUE

31
Q

Business rules logic includes such activities as data validation and identification of processing errors.

A

FALSE

32
Q

The storage component of a client/server architecture is responsible for data storage and retrieval from the physical storage devices associated with the application.

A

TRUE

33
Q

A fat client does most of its processing on the server.

A

FALSE

34
Q

Application partitioning gives developers the opportunity to write application code that can later be placed on either a client workstation or a server, depending upon which location will give the best performance.

A

TRUE

35
Q

When developing an application, one must decide where it will be placed when it is developed.

A

FALSE

36
Q

An API is a set of routines that a database server uses to access database objects.

A

FALSE

37
Q

ODBC is an application programming interface that provides a common language for application programs to access and process an SQL database independent of the particular RDBMS that is accessed.

A

TRUE

38
Q

In some three-tier architectures, most application code is stored on the application server.

A

TRUE

39
Q

Java servlets execute from within another program and reside on the server.

A

TRUE

40
Q

PHP is a platform for Web development.

A

TRUE

41
Q

Two-tier architectures are much more scalable than three-tier architectures.

A

FALSE

42
Q

Three-tier architectures generally result in higher long-term costs.

A

FALSE

43
Q

Cloud computing will have a limited impact on three-tier applications.

A

FALSE

44
Q

The presentation logic component of a client/server system is responsible for formatting and presenting data on the user’s screen.

A

TRUE