Get premium membership and access revision papers, questions with answers as well as video lessons.

Got a question or eager to learn? Discover limitless learning on WhatsApp now - Start Now!

Distributed Databases Question Paper

Distributed Databases

Course:Bachelor Of Science In Information Technology

Institution: Kca University question papers

Exam Year:2010

UNIVERSITY EXAMINATIONS: 2010/2011
THIRD YEAR EXAMINATION FOR THE DEGREE OF BACHELOR OF
SCIENCE IN INFORMATION TECHNOLOGY
BIT 4306: DISTRIBUTED DATABASES
DATE: DECEMBER 2010 TIME: 2 HOURS
INSTRUCTIONS: Answer question ONE and any other TWO questions
QUESTION ONE
a) Explain how you would distinquish between a homogenous distributed database system and a
heterogeneous distributed database system. (2 Marks)
b) Explain the importance of the following concepts in the context of Oracle DBMS
i) Distributed processing (3 Marks)
ii) Heterogeneous Services (3 Marks)
iii) Replication (3 Marks)
c) Give an explanation of why a database link does not always have the same name as the global
database name of the remote database that it references. (5 Marks)
d) The distributed database supports all of the security features that are available with a nondistributed
database environment, including Password, Some types of external authentication for users and
roles, Login packet encryption for client-to-server and server-to-server connections. As a database
Administrator, which other FIVE security options will you consider in a distributed database
environment in addition to the above? (10 Marks)
e) Explain how data is accessed directly or indirectly in a distributed database environment based on
client server architecture (4 Marks)
2
QUESTION TWO
a) Describe the process of changing a domain in a Global Database Name. ( 6 Marks)
b) In a distributed database environment, it is vital to coordinate with the database administrator to
determine the best location for the data. Outline SIX issues to be considered in determining the
location of the data. (6 Marks)
c) Discuss how referential integrity is maintained in a distributed system (8 Marks)
QUESTION THREE
a) In your own opinion what are the benefits of fragments allocation in a distributed database
(5 Marks)
b) Explain the characteristics of a distributed database management system. (6 Marks)
c) Distributed databases can be fragmented in many ways. Define the term fragmentation and explain
any four types of fragmentation that can be carried out. (9 Marks)
QUESTION FOUR
a) Explain the meaning of the following SQL statements. (6 Marks)
b) Explain briefly the phases of two phase commit mechanism . (6 Marks)
c) Outline any SIX services provided by a DDBMS. (6 Marks)
d) Define the term site autonomy (2 Marks)
QUESTION FIVE
a) Describe how the different character sets are used in the various database environments. (9 Marks)
b) Discuss the TWO main concepts that facilitates interconectivity between oracle DBMS and a nonoracle
DBMS (8 Marks)
c) State the THREE ways in which Distributed transactions can become in-doubt (3 Marks)

Distributed Databases Question Paper

More Question Papers

Popular Exams