Page 182 - IT-802_class_12
P. 182

Solved Exercise



                                                         Section A
                                                 (Objective Type Questions)
        A.  Choose the correct option.
           1.  What is the full form of DBMS?
             i.  Data of Binary Management System               ii.  Database Management System
             iii. Database Management Service                   iv.  Data Backup Management System
           2.  Which of the following is a component of the DBMS?
             i.  Data                                           ii.  Data Languages
             iii. Data Manager                                  iv.  All of these
           3.  What does an RDBMS consist of?
             i.  Collection of Records                          ii.  Collection of Keys
             iii. Collection of Tables                          iv.  Collection of Fields
           4.  Which of the following commands is used to create a new table in SQL?
             i.  CREATE TABLE                                   ii.  BUILD TABLE
             iii. GENERATE TABLE                                iv.  None of these
           5.  Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?
             i.  UNIQUE                                         ii.  NOT NULL
             iii. DEFAULT                                       iv.  CHECK
           6.  The rows of a relation is known as ................................ .
             i.  Degree                                         ii.  Entity
             iii. Tuple                                         iv.  None
           7.  Which of the following is not a Constraint in SQL?
             i.  Primary Key                                    ii.  Not Null
             iii. Check                                         iv.  None of these
           8.  Which command is used to change the definition of a table in SQL?
             i.  CREATE                                         ii.  UPDATE
             iii. ALTER                                         iv.  SELECT
           9.  ................................ is used to establish an association between related tables.
             i.  Line                                           ii.  Relationship
             iii. Primary Key                                   iv.  Records
          10.  In which of the following formats data is stored in the database management system?
             i.  Image                                          ii.  Text
             iii. Table                                         iv.  Graph
          11.  Which of the following is true for self-referencing table?                  [CBSE Sample Paper 2023]
             i.  A foreign key constraint can reference columns within the same table.
             ii.  A primary key constraint can be null.
             iii. You cannot delete this table.
             iv. You cannot update or delete this table.
          12.  Identify the operator that performs pattern searching in MYSQL.             [CBSE Sample Paper 2023]
             i.  EXISTS operator                                ii.  BETWEEN operator
             iii. LIKE operator                                 iv.  SEARCH operator
          13.  Cardinality of a table is four and degree is three. If two columns and four rows are added to this table, what will be the new
             degree and cardinality of the given table?                                    [CBSE Sample Paper 2023]
             i.  5,8                                            ii.  3,4
             iii. 8,5                                           iv.  4,3
          180   Touchpad Information Technology-XII
   177   178   179   180   181   182   183   184   185   186   187