Page 191 - IT-802_class_12
P. 191

23  (a)  Improved security                       (b)  User friendly
                  (c)  Reduced redundancy                      (d)  Security and recovery overheads
             Ans.  (d)  Security and recovery overheads
              24.  Consider a table Employee with fields Empid, Empname, DOB, DOJ, Salary, Designation and Phone, num. Every record must
                 have a non-repeated Empid. Identify the appropriate key that must be applied while creating the table.   [2022]
                  (a)  Default                                 (b)  Null
                  (c)  Primary Key                             (d)  Domain
             Ans.  (c)  Primary Key
              25.  Consider a table Student with attributes AdmnNo. Rno. Sname, Class and Marks. The column AdmnNo is the Primary key.
                 Every student has a Identify set of attributes that cannot be a superkey in table Student:    [2022]
                  (a)  (AdmNo. Sname)                          (b)  (AdmNo. Class, Marks)
                  (c)  (Class Marks)                           (d)  (AdmnNo. Marks)
             Ans.  (c)  (Class Marks)
              26.  Consider the table Supplier:                                                                [2022]

                    S.D.       Supp_name          City        Phoneno         Company           Status
                    S101    Jitesh           Jaipur          9812131415   Jain & Co.        Delivered
                    S102    Rohit            Jodhpur         6958686868   Jumbo Electricals  Pending
                    S103    Ramesh           Bikaner         9565859565   J & K Collabs     Delivered
                    S109    Rankat           Jaipur          6598102030   Felian Company    Delivered
                    S201    Dilshad          Agra            6510205030   Reliant Transient  Pending
                    S223    Jitesh           Lucknow         6510204548   J & K Collabs     Pending
                  Select the appropriate set of candidate keys:
                  (a)  S_ID, Supp_name, Company                (b)  Supp_name, City, Phoneno
                  (c)  S_ID, Supp_name, Phoneno                (d)  S-ID, Phoneno
             Ans.  (d)  S-ID, Phoneno
              27.  Parinity wants to remove all the records from table “Customer” with fields(Cust_ID,C_name, Amount, Dues, Address) whose
                 dues status is ‘Clear’. Select the query that will solve the purpose:                         [2022]
                  (a)  Delete from Customer where dues=’Clear’;   (b)  Remove from Customer where dues=’Clear’;
                  (c)  Drop Customer where dues=’Clear’;       (d)  Delete from Customer where dues=’Clear’;
             Ans.  (d)  Delete from Customer where dues=’Clear’;
              28.  Jagriti wants to display the list of all the students in relation ‘Student’ with fields (Admno, Name, DOB, DOJ, City, Class,
                 FatherName, MotherName) whose city name ends with letter ‘d’ in decending order of Admno. Identify the correct query
                 to do the same from the following:                                                            [2022]
                  (a)  Select from Student where City like ‘%d’ order by Admno;
                  (b)  Select from Student where City like “%d’ order by Admno.
                  (c)  Select *from Student where City like ‘%d’ order by Admno desc;
                  (d)  Select *from Student where City like ‘%d’ order by Admno desc.
             Ans.  (c)  Select *from Student where City like ‘%d’ order by Admno desc;
              29.  Which of the following is incorrect with respect to the foreign key?                        [2022]
                  (a)  Foreign key in one table is primary key of another table.
                  (b)  Foreign key of a table must have same name as the associated primary key.
                  (c)  A foreign key can have a NULL value.
                  (d)  A foreign key can have duplicate value
             Ans.  (b)  Foreign key of a table must have same name as the associated primary key.



                                                                                 Database Concepts—RDBMS Tool   189
   186   187   188   189   190   191   192   193   194   195   196