Page 62 - ipp11
P. 62

23.  Write a short note on Data Storage.                                                        [2]
            24.  What will be the output of the following code?                                             [2]

               st = "LearnProgramming"
               print(st[:4] + st[4:].upper())
            25.  (a)  What is a keyword in Python? Give two examples.                                       [2]
                                                           OR
                (b)  Define smart cities.
            26.  What are tokens in Python? How many types of tokens are allowed in Python? Explain.        [2]
            27.  Write any two advantages of using database.                                                [2]
            28.  (a)  A college library maintains a table named Books, which stores details of all the books in the library. The
                   table has 7 columns (Book_ID,  Title, Author, Publisher, Genre,  Price,  Availability_Status)  and  150  rows
                   representing books records.                                                              [2]
                    Based on this information, answer the following:
                    (i)  What is the degree of the Books table?
                    (ii)  What is the cardinality of the Books table?
                                                           OR
                (b)  An online shopping platform stores order data in a table named Orders with the attributes like Order_ID,
                   Customer_ID, Product_ID, Order_Date, Shipping_Address. Each order is assigned a unique Order_ID and
                   customers’ Customer_ID and Product_ID are also unique.
                    Based on this information, answer the following:
                    (i)  Identify the Primary Key for this table.
                    (ii)  List the possible candidate Keys and justify them.


                                                SECTION C (3 × 3 = 9 Marks)
            29.  Define the following terms:                                                                [3]
                (a)  Entity               (b)  NULL value              (c)  Data Integrity
            30.  (a)  Write an SQL statement to create a table, DOCTORS, with the following specifications:   [3]
                    Column Name           Data Type            Constraints
                    DOC_ID                Varchar(5)           Primary Key
                    DOC_Name              Varchar(40)          NOT NULL
                    Department            Varchar(30)          NOT NULL
                    Salary                Decimal(7,2)
                    Join_Date             Date

                                                           OR
                (b)  Write SQL commands to perform the following tasks:
                    (i)  Create a database named Office.
                    (ii)  Open the database Office.
                   (iii)  Display all records from a table named Staff.
            31.  Consider the following table:                                                              [3]
                                               Table: CUSTOMER_FEEDBACK
                   Feedback_ID           Name               Rating             Product         Feedback_Date
                       F101        Simran Gupta                4          Vacuum Cleaner        2025-04-20
                       F102        Rajeev Arora                5          Blender               2025-05-22
                       F103        Meena Kumari                3          Iron                  2025-03-24
                       F104        Ayaan Mehta                 5          Microwave             2025-01-25
                       F105        Tanya Singh                 2          Mixer Grinder         2025-02-27




                                                        P.8
   57   58   59   60   61   62   63   64   65   66