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

Solved Exercise



                                                           Section
                                                      ecti e T  e  uestions

                Multi le c oice  uestions:

               1.  The Select command is which of the following categories command?
                 i.  DDL                                           ii  DML
                 iii  TCL                                          iv. XML

               2.  SQL stands for ............................. .
                 i.  Structured Queue Language                     ii.  Structured Query Language

                 iii. Structured Query Lang                        iv. None of these
               3.  ............................. statement is used to retrieve data from table.

                 i.  Delete                                        ii.  Update
                 iii. Print                                        iv. Select

               4.  Which of the following commands is used to edit records through SQL View?
                 i.  Update                                        ii.  Edit
                 iii. Modify                                       iv. Alter

               5.  Which of the following commands is used to delete records using SQL view?
                 i.  Remove                                        ii.  Drop

                 iii. Delete                                       iv. Erase
               6.  Which of the following is not a data type of SQL?

                 i.  Between                                       ii.  Integer
                 iii. Character                                    iv. Date


              Ans.  1. ii    2. ii      3. iv    4. i       5. iii    6. i

                Fill in t e  lan s
               1.  A ............................. enables users to view, enter, and change data directly in database objects such as tables.


                2.  The ............................. command is used to insert record using SQL view.

                3.  A ............................. is a part of DML involving information retrieval only.

                4.  A popular data manipulation language is ............................. .

                5. ............................. are used to manage transactions by tracking other comman and there effects on the database.

              Ans.  1. DML comamnds                     2. Insert                         3. Select
                   4. SQL                               5. TCL commands





                                                                                       More on Database        321
   318   319   320   321   322   323   324   325   326   327   328