Database Management System Excellence: Module - 2

1. What is meant by database server?
2. What is the function of database servers?
3. Database servers operate on a client-server model. Comment.
4. A database server consists of hardware alone. Comment.
5. What the key hardware components usually found in a database server?

Why proper cooling system is required in database servers?

When more powerful hardware is required in the case of database servers?

What are some common software components of database servers?

1. What is the full form of DBMS?
2. What is meant by Database management system?
3. What is the benefit of DBMS to users?
4. How DBMS manages the concurrent access to data?
5. DBMS provides controlled access to the data. What is meant by controlled access?
6. What are the various uses of DBMS for business activities or what are the applications of DBMS?

Why there are so many types of database servers?

1. Functions of DBMS
2. What are the various functions performed by DBMS?
3. What is meant by data manipulation?
4. What are those storage devices where DBMS usually stores data?
5. Which are the common performance optimization techniques used by DBMS?
6. How DBMS enables data sharing and collaboration?
7. How DBMS is helpful to Database Administrators?

1. What are the various types of database servers?
2. What is meant by centralized database servers?
3. What is meant by Distributed database servers?
4. If e-commerce company is having distributed database servers for its organization, what should be done as the data and workload grows?
5. What is the after effect if one of the servers of the distributed database servers goes out of order or becomes unavailable?
6. What are the possible steps which may have to be taken to resolve the issue?
7. What is the function of operational database servers used?
8. What is meant by cloud based servers? How a customer or organization can avail the services of cloud based server?
9. If an organization needs to improve scalability, which type of server will be its likely choice?
10. Which type of server is likely to be used by an organization that needs to share data across multiple departments?
11. Name some of the factors which an organization may consider when choosing a database server?

What are the various types of database servers?

What is meant by centralized database servers?

What is meant by Distributed database servers?

If e-commerce company is having distributed database servers for its organization, what should be done as the data and workload grows?

What is the after effect if one of the servers of the distributed database servers goes out of order or becomes unavailable?

What are the possible steps which may have to be taken to resolve the issue?

What is the function of operational database servers used?

What is meant by cloud based servers? How a customer or organization can avail the services of cloud based server?

If an organization needs to improve scalability, which type of server will be its likely choice?

Which type of server is likely to be used by an organization that needs to share data across multiple departments?

Name some of the factors which an organization may consider when choosing a database server?