Page 189 - IT-802_class_12
P. 189

Previous Years’ Questions



              1.  ………………………… command displays all the tables created in the current database.                  [2023]
                  (a)  SHOW DATABASES                          (b)  SHOW TABLES
                  (c)  CREATE TABLES                           (d)  DiSpLAy TABLES

             Ans.  (b)  SHOW TABLES
              2.  An attribute value may not be permitted to be NULL value with ………………………… constraint.         [2023]
             Ans.  NOT NULL
              3.  Ranjana has written the following query but it is giving an error. Rectify the error and rewrite the query.    [2023]

                 SELECT * FROm pRODUCT
                 SORT By pRiCE;
             Ans.  SELECT * FROm pRODUCT
                 ORDER By pRiCE;
              4.  “Database management system could not find any usage in hospital domain.” In the above statements true or false? [2023]
             Ans.  False
              5.  Define Referential Integrity.                                                                [2023]
             Ans.  Referential Integrity is a database concept that ensures relationships between tables are maintained. It is typically enforced
                 through the use of foreign keys and primary keys. In a relational database, the referential integrity constraint requires that
                 the values in a column (or columns) of one table correspond to the values in a referenced column (usually the primary key)
                 of another table.
              6.   Which of the following constraints specifies that the value of every attribute in each tuple must be from the domain of that
                 attribute?                                                                                     [2023
                  (a)  Domain Constraint                       (b)  Key Constraint
                  (c)  Null Value Constraint                   (d)  Entity Integrity Constraint
             Ans.  (a)  Domain Constraint
              7.  Database can be removed by using ………………………… command.                                         [2023]
             Ans.  DROP Command (DROP DATABASE database_name;)
              8.  Create Table is a ………………………… command.                                                        [2023]
             Ans.  DDL (Data Definition Language)
              9.  The functions that are used to apply certain mathematical functions on a group of values in a database are called ____.
             Ans.  aggregate functions or SQL aggregate functions
              10.  RDBMS packages are widely used as ………………………… (Frontend/Backend)                             [2023]
             Ans.  Backend
              11.   The number of attributes in a relation is called the ………………………… of a relation.             [2023]
             Ans.  degree
              12.  To avoid repetition in the result of a SELECT Query ………………………… clause is used.              [2023]
             Ans.  DISTINCT
              13.  Mention any two major significances of Database Management System.                          [2023]
             Ans.  Database Management Systems (DBMS) have several significant advantages, but here are two major significances:
                  (i)    Data Integrity and Consistency: DBMS enforces data integrity constraints, ensuring that data in the database follows
                     predefined rules and constraints. This helps maintain the accuracy and consistency of data, preventing inconsistencies
                     and errors.
                  (ii)    Data Security and  Access  Control:  DBMS  provides  robust  security  features  to  control  access  to  data.  It  allows
                     administrators to define user roles and permissions, limiting who can view, modify, or delete data.




                                                                                 Database Concepts—RDBMS Tool   187
   184   185   186   187   188   189   190   191   192   193   194