Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Aissce Practical Examination - 2021: Class XII Informatics Practices Code No. 065)

    Uploaded by

    RC Sharma
    CLASS XII (IP) PRACTICAL EXAM QUESTION 20-21

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Aissce Practical Examination - 2021: Class XII Informatics Practices Code No. 065)

    Uploaded by

    RC Sharma
    12 views1 page
    CLASS XII (IP) PRACTICAL EXAM QUESTION 20-21

    Original Title

    AISSCE PRACTICAL EXAMINATION

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    CLASS XII (IP) PRACTICAL EXAM QUESTION 20-21

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    12 views1 page

    Aissce Practical Examination - 2021: Class XII Informatics Practices Code No. 065)

    Uploaded by

    RC Sharma
    CLASS XII (IP) PRACTICAL EXAM QUESTION 20-21

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 1

    AISSCE PRACTICAL EXAMINATION - 2021

    Class XII INFORMATICS PRACTICES (Code No. 065)


    Duration: 3 Hours Total Marks: 30
    GENERAL INSTRUCTIONS:
     All questions are compulsory
    PART-A (8 Marks)

    Q1. Write a Pandas program to add, subtract, multiple and divide two Pandas Series.
    Sample Series: [2, 4, 6, 8, 10], [1, 3, 5, 7, 9] [4]

    Q2. Write a program to plot a bar chart in python to display the result of a school for five consecutive
    years.  [4]
    PART-B (7 Marks)
    Q3. Table Emp is shown below. [7]
    I Name Age Address Salar Phone
    D y
    1 Aman 23 B-5/45, Uday Park, Delhi 50000 9811007666
    2 Amit 26 H-2/49, Pitampura, Delhi 80000 6240596920
    3 Rajan 25 IC-24, South Avenue, Bhopal 87000 9386121777
    4 Kunal 21 A-152, Gomti Nagar, Bhopal 52000 9110489044
    5 Raunaq 27 H-49/21, Rohini, Delhi 46000 9765345565
    6 Kajal 22 I-B/256, Sec-62, Noida 34000 9910139358
    Write commands is SQL
    (i) To List Names and respective Salaries in descending order of Salary.
    (ii) To Count the number of employees with name starting with ‘A’.
    (iii) To display the name and address of employees whose age is greater than 25.
    (iv) To display those, record whose phone no is 9386121777.
    (v) To add another column Design with data type and size as Char (20).
    Give Output of the following:
    (vi) SELECT MAX(Salary) FROM EMP;
    (vii) SELECT SUM(Salary) AS SumSalary FROM Emp;

    4. Practical File : [5]


    5. Project : [5]
    6. Viva-Voce : [5]

    Signature of Internal Signature of External

    You might also like