Types of DBMS

Question 1

What is a Centralized DBMS?

Answer 1

The centralized database system consists of a single computer system associated with its peripherals, physically located in a single location.

Question 2

What is a Parallel DBMS?

Answer 2

Parallel database systems architecture consists of a multiple central processing units (CPU) and data storage disk in parallel operating simultaneously

Question 3

Define a Distributed DBMS?

Answer 3

Thus, in a distributed database system, the organizations data might be
distributed on different computers in such a way that data for one portion (or department) of the organization is stored in one computer and data for another department is stored in
another computer.

Question 4

what is a Client- Server DBMS

Answer 4

The applications and tools of DBMS run on one or more client platforms, while the DBMS software reside on the server

Question 5

Advantages of Centralized DBMS

Answer 5

• Most of the functions such as update, backup, query, control access etc. are easier with this system.
• Single database is shared across the several different users.

Question 6

Advantages of parallel DBMS

Answer 6

· Useful in the applications, which have to process an extremely large number of transactions per seconds

· Performance of such database system is very high.

Question 7

Advantages of Distributed DBMS

Answer 7

· efficiency and performance of this system is high.

· efficiency and performance of this system is high.

· As data volumes and transaction rates increase, users can grow the system incrementally.

Question 8

Advantages of Client-Server

Answer 8

· Performance is high
· A single database (on server) can be shared across several distinct client system.
· Facilitates in more productive work by the users and making better use of existing data.