COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Centralized database
|
|
|
Distributed database
|
|
|
Enterprise database
|
|
|
Discipline specific database
|
Detailed explanation-1: -A distributed database is basically a database that is not limited to one system, it is spread over different sites, i.e, on multiple computers or over a network of computers. A distributed database system is located on various sites that don’t share physical components.
Detailed explanation-2: -A database that supports data distributed across several different sites is called a distributed database.
Detailed explanation-3: -centralized DBMS-A database management system that supports a database located at a single site.
Detailed explanation-4: -A heterogeneous distributed database is which of the following? The same DBMS is used at each location and data are not distributed across all nodes. The same DBMS is used at each location and data are distributed across all nodes. A different DBMS is used at each location and data are not distributed across all nodes.
Detailed explanation-5: -Data redundancy occurs when the same piece of data is stored in two or more separate places and is a common occurrence in many businesses.