Site MapHelpFeedbackMultiple Choice Quiz
Multiple Choice Quiz
(See related pages)



1

The following is an example of scalability provided by a client-server approach with distributed processing:
A)Move some work from an overloaded server to a new server
B)Move some work from an overloaded server to a client
C)Move some work from a client to a server
D)All of the above
2

Which of the following statements is not true about two-tier client-server database architecture?
A)SQL statements are processed on the server
B)SQL statements may be processed on some of the clients
C)Business logic is mostly processed on clients
D)Business logic may be processed on the server
3

An advantage of the three-tier architecture over the two-tier architecture is:
A)Easier maintenance
B)Better control over the data
C)Better performance
D)All of the above
4

Which of the following is not one of the advantages of parallel processing?
A)scaleup
B)autonomy
C)speedup
D)availability
5

In a parallel database architecture with clustering, which statement is true?
A)In the CN architecture, the processors in each cluster share all disks, but nothing is shared across clusters.
B)In the CD architecture, the processors in each cluster share all disks, but nothing is shared across clusters.
C)In the CD architecture, the processors in each cluster share no resources, but each cluster can be manipulated to work in parallel to perform a task.
D)None of the above
6

The degree of resource sharing determines architectures for parallel database processing. The standard classification of architectures are known as:
A)shared everything (SE)
B)shared disks (SD)
C)shared nothing (SN)
D)all of the above
7

In a distributed DBMS, a local data manager:
A)Only processes SQL queries on the local database
B)Is only involved in recovery from failure
C)Has all the features of a non-distributed DBMS on the local database
D)Only performs transaction management on the local database
8

When a distributed DBMS is loosely integrated, which of the following statements is true?
A)The distributed DBMS may integrate the DBMS of a newly acquired organization
B)SQL is often used as an interface between the distributed data manager and local data managers
C)The distributed data manager does not efficiently support distributed transactions
D)All of the above
9

A SQL query with location transparency needs to specify:
A)Fragments
B)Locations
C)Local formats
D)All of the above
10

Distributed query processing is more complex than centralized query processing because it involves:
A)Movement of data
B)Remote processing
C)Site coordination
D)All of the above





To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 17 > Multiple Choice Quiz