Home » MCQs » DBMS MCQs

DBMS Databases & Types Multiple-Choice Questions (MCQs) and Answers | Set 3

DBMS Databases & Types MCQs (Set 3): This section contains DBMS Databases & Types Multiple-Choice Questions (MCQs) and Answers.
Submitted by Anushree Goswami, on December 06, 2021

1. Which among the following is a type of database?

1. Centralized
2. Distributed
3. Cloud
4. All of the above

Answer: D) All of the above

Explanation:

Centralized, Distributed and Cloud are all types of databases.

Discuss this Question

---

2. What is Centralized Database?

1. These databases store information in a central location.
2. These databases store information in a decentral location.
3. These databases store information in a left location.
4. These databases store information in a right location.

Answer: A) These databases store information in a central location

Explanation:

These databases store information in a central location.

Discuss this Question

---

3. What is the advantage of Centralized Database?

1. As a result of the large size of the centralized database, fetching the data takes a long time.
2. Because data is managed in a central repository, consistency is maintained.
3. An extensive database system is difficult to update.
4. A server failure could result in the loss of all data, which is a huge loss.

Answer: B) Because data is managed in a central repository, consistency is maintained

Explanation:

Because data is managed in a central repository, consistency is maintained.

Discuss this Question

---

4. What is the disadvantage of Centralized Database?

1. As a result of the large size of the centralized database, fetching the data takes a long time.
2. An extensive database system is difficult to update.
3. A server failure could result in the loss of all data, which is a huge loss.
4. All of the above

Answer: D) All of the above

Explanation:

The disadvantages of Centralized Database are –

1. As a result of the large size of the centralized database, fetching the data takes a long time.
2. An extensive database system is difficult to update.
3. A server failure could result in the loss of all data, which is a huge loss.

Discuss this Question

---

5. What is an example of Distributed Database?

1. HBase
2. Ignite
3. Apache
4. All of the above

Answer: D) All of the above

Explanation:

HBase, Ignite, Apache are all examples of Distributed Database.

Discuss this Question

---

6. What is a Homogeneous DDB?

1. Database systems running on these platforms are running on the same operating system, using the same application protocol, and using similar hardware.
2. Database systems on these platforms operate on different operating systems and use different application protocols, as well as different hardware.
3. Database systems running on these platforms are running on the different operating system, using the same application protocol, and using similar hardware.
4. Database systems on these platforms operate on same operating systems and use different application protocols, as well as different hardware.

Answer: A) Database systems running on these platforms are running on the same operating system, using the same application protocol, and using similar hardware

Explanation:

Database systems running on these platforms are running on the same operating system, using the same application protocol, and using similar hardware.

Discuss this Question

---

7. Database systems on ____ operate on different operating systems and use different application protocols, as well as different hardware.

1. Homogeneous DDB
2. Heterogeneous DDB
3. DDB
4. None of the above

Answer: B) Heterogeneous DDB

Explanation:

Database systems on heterogeneous DDB operate on different operating systems and use different application protocols, as well as different hardware.

Discuss this Question

---

8. What is the advantage of Distributed Database?

1. The distributed database can be developed in a modular way, that is, new computers can be added to the system, and they can be connected to the system.
2. There will be no impact on the data set if one server fails.
3. Both A. and B.
4. None of the above

Answer: C) Both A. and B.

Explanation:

The advantages of Distributed Database are –

1. The distributed database can be developed in a modular way, that is, new computers can be added to the system, and they can be connected to the system.
2. There will be no impact on the data set if one server fails.

Discuss this Question

---

9. What is TRUE about Relational Database?

1. Relational databases store information in rows (tuples) and columns (attributes), which create tables (relations).
2. Data is stored, manipulated, and maintained using SQL in a relational database
3. Tables in the database contain unique keys that identify them from other tables.
4. All of the above

Answer: D) All of the above

Explanation:

The following statements are TRUE about Relational Database –

1. Relational databases store information in rows (tuples) and columns (attributes), which create tables (relations).
2. Data is stored, manipulated, and maintained using SQL in a relational database
3. Tables in the database contain unique keys that identify them from other tables.

Discuss this Question

---

10. What is the short form of properties in Relational Database?

1. ADEC
2. ADID
3. ACIE
4. ACID

Answer: D) ACID

Explanation:

There are four properties in Relational Database known as ACID in short, i.e., Atomicity, Consistency, Isolation and Durability.

Discuss this Question

---

---