Page 366 - Information_Practice_Fliipbook_Class11
P. 366

44.  How will you remove records having no products from the table "Suppliers" having fields Sno, name, area,
              products?

         Ans.  DELETE FROM Suppliers WHERE products = NULL;
          45.  What is primary key?
         Ans.  Primary key is a set of one or more attributes that uniquely identifies a tuple in a relation.

          46.  What is MySQL?
         Ans.  MySQL is an open source RDBMS that relies on SQL for processing the data in the database. The database is
              available for free under the terms of General Public License (GPL).
          47.  What is RDBMS?

         Ans.  Relational  Database  Management  System  (RDBMS)  facilitates  access,  security  and  integrity  of  data,  and
              eliminates data redundancy. For example, MySQL, Oracle, Microsoft Sql Server, etc.
          48.  How can we remove a table from a SQL database?

         Ans.  We can remove a table using the DROP statement.
          49.  How can we add a new column in a table?
         Ans.  A new column can be added using ALTER TABLE statement.

          50.  Who is the developer of the Python programming language? In which year was Python initially developed?
         Ans.  Python was developed by Guido Van Rossum. Python was first developed in the year 1991.



















































          352  Touchpad Informatics Practices-XI
   361   362   363   364   365   366   367   368   369   370   371