Page 330 - Trackpad 402_Class-X_Final
P. 330

3.  Write an SQL command for the instructions written by using the table given below:
                                                   Friends
                 Sno    Friend_Name       Address          City     Phoneno      Percentage
                  11    Amita         Defence Colony   Jalandar       11223344        98
                  22    Sweta         R K Puram        Delhi          22334411        91
                  33    Ajay          GK-1             Meerut         33445566        97
               a.  How many rows and columns are there in the table?
               b.  Display only those friend who live in Delhi.
               c.  Display the records in the ascending order of friends' addresses.
               d.  Display name and phone number of those where percentage is between 95 to 100.
          Ans.  a.  Rows=3   Columns=5
               b.  SELECT * FROM FRIENDS WHERE CITY=’DELHI’;
               c.  SELECT * FROM FRIENDS ORDER BY ADDRESS;
               d.  SELECT FRIEND_NAME,PHONENO FROM FRIENDS WHERE PERCENTAGE BETWEEN 95 AND 100;



                                                         Unsolved


                                          SECTION A (Objective Type Questions)

        A.  Choose the correct option.

            1.  The intersection point between a row and column is called   .
              a. Row                                             b. Column
              c. Table                                           d. Cell

            2.  In database            helps us to retrieve the filtered data based upon some conditions.
              a. Forms                                           b. Reports
              c. Queries                                         d. Table
            3.  Rudrakshh wants that the name column of a table must not be left blank. Help him to identify the field property for this
              purpose.
              a. Length                                          b. Default
              c. Entry Required                                  d. Format
            4.  Vikram wants to create a connection between two or more tables. Suggest her the option to accomplish the task.
              a. Table                                           b. Form
              c. Relationships                                   d. Sorting
            5.  A table is a set of data elements that is organized using a model of vertical    and horizontal    .
              a. Rows, Tables                                    b. Columns, Rows
              c. Rows, Columns                                   d. Forms, Reports
            6.  Vinay wants to store a huge amount of information about his firm in a database. Which type of table organization would
              be most suitable for this purpose?
              a. Relational                                      b. Flat File
              c. Either Relational or Flat file                  d. Hierarchical
            7.  Which of the following is not an example of DDL?
              a. CREATE                                          b. ALTER
              c. SELECT                                          D. DROP

            8.  Full form of DML is          .
              a. DATA MANAGEMENT LANGUAGE                        b. DATA MANIPULATION LEVEL
              c. DATA MANIPULATION LANGUAGE                      d. DATA MANAGING LANGUAGE


          330   Trackpad Information Technology-X
   325   326   327   328   329   330   331   332   333   334   335