Questions from Database Systems

Q: Explain the difference between distributed database and distributed processing.

Explain the difference between distributed database and distributed processing.

Q: What is a fully distributed database management system?

What is a fully distributed database management system?

Q: What are the components of a DDBMS?

What are the components of a DDBMS?

Q: List and explain the transparency features of a DDBMS.

List and explain the transparency features of a DDBMS.

Q: Suppose you are asked to evaluate a DBMS in terms of lock

Suppose you are asked to evaluate a DBMS in terms of lock granularity and the different locking levels. Create a simple database environment in which these features would be important.

Q: Write a query to display the employee number, last name,

Write a query to display the employee number, last name, e-mail address, title, and department name of each employee whose job title ends in the word “ASSOCIATE.” S...

Q: Define and explain the different types of distribution transparency.

Define and explain the different types of distribution transparency.

Q: Explain the need for the two-phase commit protocol. Then

Explain the need for the two-phase commit protocol. Then describe the two phases.

Q: Describe the three data fragmentation strategies. Give some examples of each

Describe the three data fragmentation strategies. Give some examples of each.

Q: What is data replication, and what are the three replication strategies

What is data replication, and what are the three replication strategies?