Site MapHelpFeedbackPractice Quiz
Practice Quiz
(See related pages)

TRUE/FALSE questions:

1
Database architecture is the specification of the technologies to be used to implement information systems.
A)True
B)False
2
One of the considerations that define the application architecture is the degree to which the information system will be centralized or distributed.
A)True
B)False
3
A physical data flow diagram models the technical and human design decisions to be implemented as part of an information system.
A)True
B)False
4
Physical data stores implement the logical data stores.
A)True
B)False
5
A distribution layer is one of the four layers for mapping an information system application.
A)True
B)False
6
A file server is a WAN-based solution in which server computers host the data and the data manipulation layers.
A)True
B)False
7
File server architectures are practical only for small database applications to be shared by relatively few users
A)True
B)False
8
A distributed data and application client/server system is a is a solution in which: (1) the data and data manipulation layers are placed on their own server(s); (2) the application logic is placed on its own server; and (3) the presentation logic and presentation layers are placed on different servers.
A)True
B)False
9
Vertical partitioning is when different rows in a database are assigned to different database servers.
A)True
B)False
10
Remote procedure calls (RPCs), message queues and object request brokers are examples of application middleware.
A)True
B)False

Multiple Choice questions:

11
A system in which the components of an information system are distributed to multiple locations in a computer network is known as a:
A)database system
B)networked system
C)distributed system
D)communication system
E)none of the above
12
Which of the following define the application architecture for an information system?
A)the implementation technology for all software to be developed in-house
B)the technology to be used to implement the user interface
C)the distribution of stored data across a network
D)the degree to which the information system will be centralized or distributed
E)all of the above
13
Which of the following is NOT an information system application layer?
A)data layer
B)database layer
C)presentation layer
D)application logic layer
E)data manipulation layer
14
An application system can be mapped into how many different layers?
A)one
B)two
C)three
D)four
E)none of the above
15
A server that hosts services for e-mail, calendaring, and other work group functionality is known as a(n):
A)groupware server
B)communication server
C)exchange server
D)application server
E)transaction server
16
Which technique allocates different rows in a table to different database servers?
A)vertical partitioning
B)segmented partitioning
C)hierarchical partitioning
D)horizontal partitioning
E)none of the above
17
Which of the following does not describe a rule of correctness for drawing a physical DFD?
A)a system that fulfills user requirements
B)a system that works
C)a system that provides adequate performance (throughput and response time)
D)a system that is adaptable to changing requirements and enhancements
E)a system that is not cost effective
18
Which of the following is(are) shown on a network architecture DFD?
A)processor specifications
B)transport protocols
C)clients and their physical locations
D)servers and their physical locations
E)all of the above
19
Which technique assigns different columns to different database servers?
A)vertical partitioning
B)horizontal partitioning
C)hierarchical partitioning
D)segmented partitioning
E)none of the above
20
Which of the following is(are) data distribution option(s)?
A)replicate specific tables or subsets on different servers
B)store all data on a single server
C)store subsets of specific tables on different servers
D)store specific tables on different servers
E)all of the above







Whitten: Intro SA&D 1eOnline Learning Center

Home > Chapter 12 > Practice Quiz