Class 12 Informatics Practices Practical Paper 4

QUESTION

Class 12 Informatics Practices Practical Paper 4 plays a vital role in the CBSE board examination. This practical paper assesses students’ hands-on programming skills, database management knowledge, and problem-solving ability using Python and SQL. A strong performance in this paper can significantly improve overall board results.
This article provides a complete, exam-oriented guide to Practical Paper 4, including exam pattern, important topics, commonly asked questions, preparation strategies, and career relevance.

Python Program

Q – 1 Write a program in python to create the following dataframe named “employee” storing the following details:

Considering the above dataframe answer the following queries by writing appropriate command in python pandas.
i. Display Name, Post and Salary for all employees earning more than 60000 .
ii. Add a new row of your choice data.
iii. Transfer these data from dataframe to csv named employees.csv.
iv. Now plot a multi-line chart depicting the Employee Name on x-axis and their corresponding Salary on y-axis, with appropriate Graph title, x-axis title, y-axis title, legends and color etc.

MySQL

Q – 2 Create the table “employee” and write sql queries for the following:

i) Count and display employees post wise.
ii) Display 3 characters from 2nd place from the column ename.
iii)Display last 2 characters of post column.
iv)Display ename in lower letters
v)Display most senior employee

Leave a Reply

Your email address will not be published. Required fields are marked *

sign up!

We’ll send you the hottest deals straight to your inbox so you’re always in on the best-kept software secrets.