Page 328 - IT 402 v2.0 class 10
P. 328

2.  Command to display all the data in the table “emp” is ............................. .
              i.  Select * from emp                             ii.  Select * from emp;
              iii. Select all from emp                          iv. Select all from emp;
            3.  Which command is used to modify data in table?
              i.  delete                                        ii.  select
              iii. modify                                       iv. update
            4.  Select " emp name" ,  " salar y "  *  3  f r om emp ;
              i.  will increase the salary three times of all employees in table
              ii.  display name and three times salary
              iii. give error
              iv. None of the above
            5.   ommand to increase the salary of all employees by  5   .  table name emp and column name sal
              i.  update emp set sal = sal + 15000;             ii.  update emp set sal = 15000;
              iii. update set sal = sal + 15000;                iv. None of the above
            6.  Which command is used to delete data from table?
              i.  select                                        ii.  delete
              iii. insert                                       iv. remove
            Fill in t e  lan s

            1.  ............................. is the most commonly used  ata Manipulation  anguage   M   command.
            2.  ............................. are used to identify which type of data we are going to store in the database.
            3.  ............................. command is used to create a table.
            4.  A ............................. is a language that enables users to access and manipulate data in a database.
            5.  A ............................. is a standard for commands that define the different structures in a database.
            6.  ............................. statement retrieves zero or more rows from one or more database tables or database views.
            7.  ............................. statement is used to remove one or more records in a Database.

                                                        Section
                                                Su  ecti e T  e  uestions
             ns er t e follo ing  uestions:
             .  Name two categories of S   commands.
             .   ifferentiate between     and  M  commands.
            3.  Explain the following commands:
              i.  Create                                        ii.  Update
              iii. Insert                                       iv. Delete
            4.  What are the ways to create a table?

            5.   rite S   command to insert a student record in a student table.  he fields are rollno  name  birthplace  contactno
              and previousschool.
            6.  State the purpose of Update Command with the help of an example.

            7.  Explain SQL Comparison Operators.
            8.  Consider the following table: Sales                                      [CBSE Sample Paper 2023]
                   Sale Id       Prod  ame            Price           iscount
                    1101        Laptop               65000             2500
                    1103        Pen tab              29500             1000
                    1105        Desktop              50000             1550
                    1106        Printer              12000             2000


         326       Touchpad Information Technology-X
   323   324   325   326   327   328   329   330   331   332   333