Lecture 1&2 DBMS
Uploaded by
7saqr607Lecture 1&2 DBMS
Uploaded by
7saqr607Database management
system 1
Lecture 1 & 2
Database overview
Database overview
Database overview
Simplified database system environment
multiple choice questions
1. What is the full form of DBMS?
a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Data Backup Management System
Answer: b
Explanation: DBMS is abbreviated as Database Management System. Database Management System stores the
data and allows authorized users to manipulate and modify the data.
2. What is a database?
a) Organized collection of information that cannot be accessed, updated, and managed
b) Collection of data or information without organizing
c) Organized collection of data or information that can be accessed, updated, and managed
d) Organized collection of data that cannot be updated
Answer: c
Explanation: It is defined as an organized collection of data or information for easy access, updating, and
management in a computer.
3. What is DBMS?
a) DBMS is a collection of queries
b) DBMS is a high-level language
c) DBMS is a programming language
d) DBMS stores, modifies and retrieves data
Answer: d
Explanation: DBMS is nothing but a storehouse wherein the authorized user can create a database to store,
modify or retrieve the organized data in the table. It can be modified or retrieved by users who have access to
DBMS only.
• 4. Who created the first DBMS?
a) Edgar Frank Codd
b) Charles Bachman
c) Charles Babbage
d) Sharon B. Codd
Answer: b
Explanation: Charles Bachman along with his team invented the first DBMS known as Integrated Data
Store (IDS).
• 5. Which type of data can be stored in the database?
a) Image oriented data
b) Text, files containing data
c) Data in the form of audio or video
d) All of the above
• Answer: d
Explanation: The reason for creating the database management system was to store large data and these
data can be of any form image, text, audio, or video files, etc. DBMS allows the users to store and access
the data of any format.
6. Which of the following is not an example of DBMS?
a) MySQL
b) Microsoft Acess
c) IBM DB2
d) Google
Answer: d
Explanation: MySQL, Microsoft Access, IBM DB2 are database management systems while Google is a search engine.
MySQL is a Linux-based database management system, Microsoft Access is a tool that is a part of Microsoft Office
used to store data, IBM DB2 is a database management system developed by IBM. Google’s Bigtable is the database
that runs Google’s Internet search, Google Maps, YouTube, Gmail, and other products.
7. Which of the following is not a feature of DBMS?
a) Minimum Duplication and Redundancy of Data
b) High Level of Security
c) Single-user Access only
d) Support ACID Property
Answer: c
Explanation: Single-user Access only” is not a feature of DBMS. DBMS allows multiple users to access and manipulate
the database concurrently. It provides mechanisms to handle concurrent access and ensure data consistency and
integrity among multiple users.
8. Which of the following is a feature of the database?
a) No-backup for the data stored
b) User interface provided
c) Lack of Authentication
d) Store data in multiple locations
Answer: b
Explanation: The important features are:
1) Provides backup for the data stored by the user and the user can retrieve the data whenever
required.
2) Provides User-interface to access the data.
3) Only authorized users can access the stored data.
4) Data is stored in one central location but multiple authorized users can access the data.
9. Which of the following is not a function of the database?
a) Managing stored data
b) Manipulating data
c) Security for stored data
d) Analysing code
Answer: d
Explanation: It allows authorized users to update, store, manipulate, or access data. Since data is
stored in table format it is easy to access the data and perform the required functions. It also removes
duplicate and redundant data.
10. Which of the following is a function of the DBMS?
a) Storing data
b) Providing multi-users access control
c) Data Integrity
d) All of the above
Answer: d
Explanation: The purpose of creating DBMS was to store the data. The data stored in the
database management system can be can accessed by multiple users if the access is provided.
The data stored will be accurate and complete hence providing data integrity.
11. Which of the following is a component of the DBMS?
a) Data
b) Data Languages
c) Data Manager
d) All of the above
Answer: d