Introduction of DBMS

What is a Database Management System (DBMS)?

• A software application that manages databases

• A computer hardware component used for data storage

• A programming language for creating databases

• A network protocol for database communication

Which of the following is not a function of a DBMS?

• Data storage

• Data retrieval

• Data manipulation

• Data transmission

What is the primary purpose of a DBMS?

• To store and manage data efficiently

• To analyze and visualize data

• To create data backups

• To secure data from unauthorized access

Which of the following is an advantage of using a DBMS?

• Reduced data redundancy

• Increased data security

• Improved data integrity

• All of the above

Which data model is commonly used in modern DBMS?

• Hierarchical model

• Network model

• Relational model

• Object-oriented model

What is the key difference between a Flat File System and a DBMS?

• Flat File System stores data in a single file, while a DBMS stores data in multiple interconnected files.

• Flat File System is faster in data retrieval than a DBMS.

• Flat File System uses a relational data model, while a DBMS uses a hierarchical data model.

• Flat File System can only handle small amounts of data, while a DBMS can handle large amounts of data.

Which of the following is a disadvantage of using a Flat File System compared to a DBMS?

• Limited data storage capacity

• Slower data retrieval and updates

• Lack of data security and integrity mechanisms

• All of the above

In a Flat File System, data redundancy refers to:

• The ability to store multiple copies of the same file

• The repetition of the same data within a single file

• The inability to store data in separate files

• The lack of data indexing capabilities

Which of the following best describes the scalability of a Flat File System compared to a DBMS?

• Flat File System is more scalable than a DBMS.

• DBMS is more scalable than a Flat File System.

• Flat File System and DBMS have similar scalability.

• Neither Flat File System nor DBMS are scalable.

Which of the following is a characteristic feature of a DBMS that is not present in a Flat File System?

• Ability to enforce data integrity constraints

• Support for complex data relationships

• Concurrent access and multi-user capabilities

• All of the above