Home » MCQs » DBMS MCQs

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

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

1. The term ______ refers to a collection of different units of information.

Database
Datatype
Data
Table

Answer: C) Data

Explanation:

The term data refers to a collection of different units of information.

Discuss this Question

2. _____ are organized collections of data that make them easy to access and manage.

Datatype
Database
Data
System

Answer: B) Database

Explanation:

Databases are organized collections of data that make them easy to access and manage.

Discuss this Question

3. In a _____, users have access to the data through a single set of software programs.

Database Handler
Dynamic Websites
Database
Handler

Answer: A) Database Handler

Explanation:

In a database handler, users have access to the data through a single set of software programs.

Discuss this Question

4. Which of the following is a database?

MySQL
Informix
SQL Server
All of the above

Answer: D) All of the above

Explanation:

In addition to MySQL, Sybase, Oracle, MongoDB, Informix, PostgreSQL, and SQL Server, there are many other databases available.

Discuss this Question

5. What does SQL depend on?

Relation Algebra
Tuple Relational Calculus
Both A. and B.
None of the above

Answer: C) Both A. and B.

Explanation:

The SQL language relies on relationship algebra and tuple relational calculus.

Discuss this Question

6. The image of a database is displayed on a ____ structure.

Cyclical
Cylindrical
Rectangular
Triangular

Answer: B) Cylindrical

Explanation:

The image of a database is displayed on a cylindrical structure.

Discuss this Question

7. File-Based database system was introduced in –

1968
1958
1978
1948

Answer: A) 1968

Explanation:

File-Based database system was introduced in 1968.

Discuss this Question

8. What is the access method in File system?

Indexed
Random
Sequential
All of the above

Answer: D) All of the above

Explanation:

The access methods present in File system are Indexed, Random and Sequential.

Discuss this Question

9. IBM's first database management system was the prominent hierarchical database model known as –

Information Major System
Interactive Major System
Interactive Management System
Information Management System

Answer: D) Information Management System

Explanation:

IBM's first database management system was the prominent hierarchical database model known as Information Management System.

Discuss this Question

10. What is the limitation in Hierarchical Database Model?

Lack Structural Independence
Complex Implementation
Tough to handle many-many relationship
All of the above

Answer: D) All of the above

Explanation:

The limitations in Hierarchical Database Model are that it lacks structural independence, complex implementation and tough to handle many-many relationships, etc.

Discuss this Question

11. _____ (IDS) was the first database management system developed by Charles Bachman at Honeywell.

Integrated Data System
Integrated Database System
Integrated Database Store
Integrated Data Store

Answer: D) Integrated Data Store

Explanation:

Integrated Data Store (IDS) was the first database management system developed by Charles Bachman at Honeywell.

Discuss this Question

12. Which of the following is a component in Network data Model?

Network Schema
Sub-schema
Data Management
All of the above

Answer: D) All of the above

Explanation:

The components in Network data Model are –

Network Schema
Sub-schema
Data Management

Discuss this Question

13. Which of the following is a limitation in Network data Model?

Simple
Difficult design
Low-maintenance
Low-cost

Answer: B) Difficult design

Explanation:

One of the limitations in Network data Model is that it is difficult to design.

Discuss this Question

14. What is the main terminology in relational database model?

Instance
Schema
Both A. and B.
None of the above

Answer: C) Both A. and B.

Explanation:

The main terminology in relational database model is instance and schema.

Discuss this Question

15. What is TRUE about relational database model?

Set theory and predicate logic are used in this model.
Relational databases were replaced by many other models such as object-oriented models, object-relational models, and others during the era of the relational database.
There are two main terms used in a relational database model: instance and schema.
All of the above

Answer: D) All of the above

Explanation:

The following statements are TRUE about relational database model:

Set theory and predicate logic are used in this model.
Relational databases were replaced by many other models such as object-oriented models, object-relational models, and others during the era of the relational database.
There are two main terms used in a relational database model: instance and schema.

Discuss this Question

16. The ____ platform facilitates the storage, management, and retrieval of structured, unstructured data.