Page 190 - IT-802_class_12
P. 190
14. Discuss any three main purposes of using Database applications in education domain. [2023]
Ans. Database applications in the education domain serve several important purposes, but here are three main ones:
(i) Student Information Management: Education databases store and manage student information, including personal
details, enrollment records, attendance, and academic performance.
(ii) Curriculum and Course Management: Databases are used to manage curriculum details, course catalogs, class
schedules, and resources. These systems help educators plan courses, allocate resources efficiently, and make
curriculum adjustments.
(iii) Research and Analysis: Databases aid in educational research by collecting and storing data related to student
performance, teaching methods, and institutional effectiveness.
15. State the role of a DBA (Database Administrator). [2023]
Ans. A Database Administrator (DBA) plays an important role in the efficient and secure management of database systems within
organisations. DBAs are responsible for a wide range of tasks that revolve around the design, implementation, maintenance,
and optimisation of databases. They collaborate with software developers and business analysts to create well-structured
databases, ensuring data integrity and efficiency. DBAs keep a vigilant eye on data growth and plan for capacity needs, as
well as contribute to disaster recovery planning to ensure business continuity.
16. Sana has given the following query but she is unable to execute it successfully. Write the correct query after rectifying the
error: [2023]
SELECT NAmE, mARKS
FROm STUDENT TABLE
WHERE NAmE = “p%”
Ans. SELECT NAmE, mARKS FROm STUDENT WHERE NAmE LiKE ‘p%’;
17. The functions that are used to apply certain mathematical functions on a group of values in a database are called
………………………… . [2023]
Ans. Aggregate functions or SQL aggregate functions
18. Adarsh is maintaining data of his company in the form of files. He uses various application programs to insert, delete or
modify data. With time he needs to add new application programs. Different users maintain details about different areas
in separate files. He faces the problem of data redundancy and data inconsistency very often. Identify the type of system
approach he uses. [2022]
(a) Hierarchical approach (b) Traditional file system
(c) Database approach (d) Network approach
Ans. (b) Traditional file system
19. Rashid is maintaining various records of his sales in different independent files. His boss asked him to give a compiled report
of his work. As all the data is stored in independent files, it becomes difficult to access information out of multiple files. He
is facing the problem of: [2022]
(a) Lack of data integration (b) Data storage
(c) Lack of data availability (d) Data deletion
Ans. (a) Lack of data integration
20. Identify the incorrect statement w.r.t. DBMS. [2022]
(a) It enables creation of repository of data. (b) There is a single repository that is accessed by all the programs.
(c) It helps users to create and maintain database. (d) Data is accessible by only one user.
Ans. (d) Data is accessible by only one user.
21. Mrigank works in a company. He identifies requirements of the end users and development specifications to interact with
the database. He plays a major role in database designing. He is a ………………………… . [2022]
Ans. System analyst
22. ………………………… is a collection of raw facts which have not been processed to reveal useful ………………………… . [2022]
(a) Data, information (b) Information, data
(c) Database, Information (d) Information, database.
Ans. (a) Data, information
188 Touchpad Information Technology-XII

