PSEB Punjab Board Class 9 Computer Science Textbook Solution Chapter 8 Database Management System Exercise Questions and Answers
Lesson No 8 -Database Management System
Q1) Multiple Choice Questions :-
1) ………………………… is a raw and unorganized fact that requires processing to make it meaningful.
a) Data b) Information c) Database d) DBMS
Answer – a) Data
2) A Record is also known as a …………………………….
a) Column b) Attribute c) Field d) Tuple
Answer – d) Tuple
3) A person who manages and controls the overall DBMS is called a …………
a) DBA b) End User c) Database Designer d) Programmer
Answer – a) DBA
4) DBMS is a software layer that provides an interface between …………………… and ………………
a) Data, Information b) DBA, End User c) User, Database d) Data, Database
Answer – c) User, Database
5) ……………… refer to general rules and instructions that help to design the
database and to use database management system.
a) Information b) Procedure c) Application Programs c) System Programs
Answer – b) Procedure
Q2) Write the Full Forms :-
1) DBMS :- Database Management System
2) DBA :- Database Administrator
3) SQL :- Structured Query Language
Q3) Short Answer Type Questions :-
1) What is record?
Ans :- Record is the set of all data fields for one row of the table. Each record (row)
within a table must be unique. No two records in a table can be exactly identical.
Records includes the information about a given person, product or an event. A record is
also known as Tuple.
2) Define Database
Ans :- You might have heard a system called ‘ Sampoorna ‘ that contains all the information about the students in our public schools. The data regarding lakhs of students have be compiled systematically. Such collection of data in a systematic manner is called databases. In databases, the data is recorded in one or many tables. Database helps to store data securely , add new data, removes unwanted data, uses data as per need , makes suitable changes etc.
For ex:- Telephone and address books are examples of paper databases.
3) Write the name of different types of users of database.
Ans :- Application Programmers, Database Administrators, End-Users are the names
of different types of users of database.
4) What do you know about DBMS.
Ans :- DBMS stands for Database Management System. It is a software, that makes it convenient to do such activities with database is called a Database Management System (DBMS).It helps us to create new databases and use them securely. User, does not directly handles the database, but with the help of software it uses. DBMS also acts as a link between user and the database. MySQL, Microsoft SQL Server, Oracle etc. are well known database management system. LibreOffice Base, Microsoft Access, etc. are some of the DBMS applications that comes as part of office packages.
5) Write the various components of Database environment
Ans :- Software, Hardware, Procedure, Data, Users are the various components of
Database environment.
Q4) Long Answer Type Questions :-
1) Write the differences between Data and Information
Ans :- The difference between Data and Information are as followed which are
a) Data :- Data is the raw and unprocessed fact. For making the data meaningful, it
is required to be processed. Data has no meaning/importance. In bits and bytes
the data is been measured.
b) Information :- Information is already the processed data which does not require
any type of processing for making it much meaningful. Information has much
importance/meaning. Time and quantity are the measuring units in which the
meaningful information is been measured.
2) Explain the various components of DBMS environment
Ans :- The various components of DBMS environment are as follows :-
a) Software :- It relates with the software (collection of programs) that is been
used in the DBMS. This software contains the operating system, DBMS
software, application programs and utilities.
- The Operating system :– The work of operating system on the database
system is to control and run all the hardware. Other software can also been
run on this database system. The mostly used operating system in the
database system environment are UNIX, LINUX, Windows etc. - DBMS software :- ORACLE, MS Access, and SQL etc are the mostly used DBMS (RDMS) software used in the database environment. This software also helps
us to manage the database in the database environment. - Application programs and utilities :- In the database, this software helps the
user in accessing the data.
b) Hardware :- It refers to the availability of hardware devices of database system
environment. For the processing of huge data of the organization there is a
need of a powerful computer such as mainframe or mini computers. For the
storing huge organization data, there is also a need of HDD or RAID disks
(secondary storage which is big) and a RAM for handling or working on the
requests of the multiple users.
c) Procedure :- It refer to general rules and instructions that help to design the
database and to use database management system. The new DBMS can be set
up or installed with the help of procedures. Procedures also play an important
role in login and log out of the DBMS software, managing DBMS
programs/software, and keeping the backup of the database or changing its
structure etc.
d) Data :- DBMS performs the main role of data processing. The database is first
created, in which the data is being stored, accessed, and updated. Metadata
(data about data) and actual (operational data).
e) Users :- In the DBMS, the users are the persons who perform the task of
managing and controlling the databases. In DBMS , there are various types of
users which are :-
- Application Programmers :- For the interaction with the databases, such
type of users writes the application by making use of programming
languages is to be termed as Application Programmer. - Database administrators :- The Database administrator performs the task
related to the controlling and managing of DBMS. The other name of
Database administrator is DBA which means the group of persons whose
responsibility is to maintain the DBMS. - End-Users :- This are the people who comes into the contact of DBMS for
doing various types of operations such as insertion, updation, retrieving,
deletion of the data.
3) Differentiate between File Processing System and DBMS
Ans :- The difference between File Processing System and DBMS are as followed :-
a) File Processing system :- It is the system which manages and arranges the files
in the computer systems storage medium. In the file system, there is presence
of redundant data. It fails to recover the crashed memory mechanism. This
system does not provides the facility of data back up or recovery, in case the
data gets lost. this system does not have efficient query processing. There is less
data consistency and less complex. It provides low quality of security. It is more
cheaper as compared to the DBMS.
b) DBMS :- This system helps in managing only the databases. In DBMS there is no
redundant data. There is presence of crashed memory mechanism. It provides
the facility of backup or data recovery even if the data is lost. There is
availability of efficient query processing. In comparison to the file systems, there
is lot of complexity in handling. Here , in this system, there is more quality in
security. As comparison made with the file system, it is much expensive/costly.
4) What is DBMS? Explain any five advantages of DBMS.
Ans :- DBMS stands for Database Management System. It is a software, that makes it
convenient to do such activities with database is called a Database Management
System (DBMS).It helps us to create new databases and use them securely. User,
does not directly handles the database, but with the help of software it uses. DBMS
also acts as a link between user and the database. MySQL, Microsoft SQL Server,
Oracle etc. are well known database management system. LibreOffice Base, Microsoft Access, etc. are some of the DBMS applications that comes as part of office
packages. The advantages of DBMS are as followed :-
- DBMS provides the facility of sharing the data to its multiple users or
applications. - If any database is unauthorized, then DBMS makes a restriction on its user for
accessing it. - If incase, there is lost of data, then too there is no reason for one to worry as if
DBMS provides the facility of data backup and recovery. - DBMS provides mechanisms for providing access of the data by many users.
- As in the DBMS system, the databases are at centre, the redundancy of data is
mostly avoided.
Dear Student, I appreciate your efforts and hard work that you all had put in. Thank you for being concerned with us and I wish you for your continued success.
For more update, follow this page ⇒ PSEB Notes and Solutions