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
   185   186   187   188   189   190   191   192   193   194   195