PYQ LensCBSE Class 12 Informatics Practices PYQs
Informatics Practices papers test data handling with Python, SQL queries, networks and societal impacts. Practise real CBSE questions and understand the logic behind each answer.
- 9Papers
- 5Years
- 325Questions
Chapters with the most questions
| Chapter | Questions |
|---|---|
| Database Query using SQL | 109 |
| Data Handling using Pandas | 97 |
| Societal Impacts | 61 |
| Computer Networks | 42 |
| Data Visualization | 16 |
Counted across the 9 papers listed on this page.
Try a sample question
From the CBSE Class 12 Informatics Practices Sample Paper 2027.
Which of the following is a Data Manipulation Language (DML) command in SQL?
- ALTER
- DROP
- UPDATE
- CREATE
Answer
C. UPDATE
Explanation
A database table has a structure, such as column names and types, and data records inside it. DML means Data Manipulation Language. It concerns operations on the stored data rather than creating or redefining the table structure.
Teacher example: UPDATE Student SET Score = 85 WHERE RollNo = 2; UPDATE selects an existing table, SET gives the new column value, and WHERE limits the change to the matching record. This changes a stored score without adding a new column.
UPDATE is the source answer. CREATE and ALTER are structural DDL examples; INSERT and DELETE are other DML examples. In the teacher example, removing WHERE could affect every row, so the condition matters. This lesson uses synthetic records, not a real student database.