Sample Question Paper (Theory)
Class XII
Informatics Practices (065)
Time allowed: 3 Hours Maximum Marks: 70
General Instructions
- Please check this question paper contains 37 questions.
- All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions.
- The paper is divided into 5 Sections- A, B, C, D and E.
- Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
- Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
- Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
- Section D consists of 2 case study type questions (33 to 34). Each question carries 4 Marks.
- Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
- All programming questions are to be answered using Python Language only.
- In case of MCQ, text of the correct answer should also be written.
Section A (21 × 1 = 21 Marks)
| Q. No. | Question | Marks |
|---|---|---|
| 1 | State whether the following statement is True or False: Slicing can be used to extract a specific portion from a Pandas Series. | 1 |
| 2 | The purpose of WHERE clause in a SQL statement is to: (A) Create a table (B) Filter rows based on a specific condition (C) Specify the columns to be displayed (D) Sort the result based on a column | 1 |
| 3 | Identify the networking device responsible for routing data packets based on their destination addresses. (A) Modem (B) Hub (C) Repeater (D) Router | 1 |
| 4 | Identify the SQL command used to delete a relation (table) from a relational database. (A) DROP TABLE (B) REMOVE TABLE (C) DELETE TABLE (D) ERASE TABLE | 1 |
| 5 | e-waste refers to: (A) Software that has become obsolete (B) Data that has been deleted (C) Viruses (D) Electronic devices no longer in use | 1 |
| 6 | Which of the following Python statements selects a column column_name from DataFrame df?(A) df.getcolumn(‘column_name’) (B) df[‘column_name’] (C) df.select(‘column_name’) (D) df(column_name) | 1 |
| 7 | By default, the plot() function of Matplotlib draws a ______ plot.(A) histogram (B) column (C) bar (D) line | 1 |
Section B (7 × 2 = 14 Marks)
| Q. No. | Question | Marks |
|---|---|---|
| 22 | (A) What is a Series in Pandas? Give example. OR (B) What does the term ‘library’ signify in Python? Mention one use each of Pandas and Matplotlib. | 2 |
| 23 | What are intellectual property rights (IPR), and why are they important in the digital world? | 2 |
Section C (4 × 3 = 12 Marks)
| Q. No. | Question | Marks |
|---|---|---|
| 29 | Ayesha’s family is replacing their old computer… I. Explain hazard II. Suggest responsible disposal III. Importance of recycling | 3 |
| 30 | (A) Write a Python program to create DataFrame… OR (B) Create Pandas Series from dictionary (Russia:Moscow etc.) | 3 |
Section D (2 × 4 = 8 Marks)
| Q. No. | Question | Marks |
|---|---|---|
| 33 | Ankita must complete blanks in a Python bar chart program… Fill Statement-1 to Statement-4. | 4 |
| 34 | (A) Bookshop DB table BOOK with columns BCODE,TITLE,AUTHOR,PRICE. Write SQL queries: I. Titles lowercase II. Highest price III. Number of characters in title IV. BookCode & Price sorted desc. OR (B) Table MEDICINE… write output of SQL queries. | 4 |
Section E (3 × 5 = 15 Marks)
| Q. No. | Question | Marks |
|---|---|---|
| 35 | ABC Pvt Ltd case study: networking across departments (HR, Finance, Technical, Support) and Lucknow office. Answer parts I–V. | 5 |
| 36 | Given DataFrame df (MovieID, Title, Year, Rating). Write Python statements: I. Print first 2 rows II. Display all titles III. Remove column rating IV. Display Title rows 2–4 V. Rename column Title to Name | 5 |
| 37 | (A) Write SQL queries: I. Average score from Exams table II. Last 3 chars of registration_number in Vehicles table III. Trim username in Users IV. Max salary from Employees V. Count rows in Suppliers OR (B) SQL queries: I. Round pi to 2 decimals II. 125 % 8 III. Length of ‘NewDelhi’ IV. First 5 chars of ‘Informatics Practices’ V. Trim email in Students table | 5 |