Page 186 - IT-802_class_12
P. 186

2.  In the relational table, which of the following can also be represented by the term “attribute”?
             i.  Entity                                         ii.  Row
             iii. Column                                        iv.  None of these
           3.  What is DBMS?
             i.  DBMS is a collection of queries                ii. DBMS is a high-level language
             iii. DBMS is a programming language                iv. DBMS stores, modifies and retrieves data
           4.  Users who use the database for querying, modifying and generating reports as per their needs are called ............... .
             i.   End users                                     ii.   Database administrator
             iii.  System programmer                            iv.  System analyst
           5.  What will the given query give the output?
             UpDATE mARKS SET SCiENCE= SCiENCE+5;
             i.  Will update the marks column with 5 marks.     ii. Will create the new column set science.
             iii. Will  lose 5 marks from the science column.    iv. None of these
           6.  Which of the following keyword is used to arrange the data in ascending order?
             i.  Ascen                                          ii.  Ascending
             iii. Asc                                           iv.  Ascd
           7.  Which of the following command can sort the results or a query in a specific order?
             i.  Alter                                          ii.  ORDER BY
             iii. Update                                        iv.  Drop
           8.  How many Primary keys can have in a table?
             i.  Only 1                                         ii.  Only 2
             iii. Depends on no. of columns                     iv.  Depends on DBA

        B.  Fill in the blanks.
           1.  ................................ is the basic source of an information.
           2.  Database can be referred to as a ................................ .
           3.  ................................ is a relational DBMS in which tables are linked to each other by fields.
           4.  ................................ write application programs to interact with the database.
           5.  By making use of ................................ and controlling users’ database access rights, the DBA can provide security to the
             database.
           6.  ................................ is the set of tuples in the relation at a point in time.
           7.  The number of attributes in a relation is called the ................................ of a relation.
           8.  The number of rows in a relation is called the ................................ of a relation.
           9.  We can also write JOIN instead of ................................ .
          10.  LEFT JOIN is also known as ................................ .

                                                         Section B
                                                 (Subjective Type Questions)

        A.  Short answer type questions.
           1.  What is RDBMS?
           2.  Define data, process and information.
           3.  Define a relational schema and a relation.
           4.  What is referential integrity constraint?
           5.  What is a join in the SQL?

        B.  Long answer type questions.
           1.  What are the differences between a DBMS and RDBMS?

          184   Touchpad Information Technology-XII
   181   182   183   184   185   186   187   188   189   190   191