SAMPLE QUESTION PAPER (THEORY) COMPUTER SCIENCE (083) CLASS: XII SESSION: 2024-25
SAMPLE QUESTION PAPER (THEORY)
CLASS: XII SESSION: 2024-25
COMPUTER SCIENCE (083)
Time allowed: 3 Hours Maximum Marks: 70
General Instructions:
● 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 3 questions (29 to 31). Each question carries 3 Marks.
● Section D consists of 4 questions (32 to 35). Each question carries 4 Marks.
● Section E consists of 2 questions (36 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.
| QNo. | Section-A(21 x 1=21 Marks) | Marks |
| 1 | True False from XI revision | 1 |
| 2 | String function based output MCQ(i.e. replace…..) | 1 |
| 3 | Evaluate Boolean expression MCQ | 1 |
| 4 | String function based output MCQ (i.e. split…..) | 1 |
| 5 | String slicing based output question | 1 |
| 6 | Tuple based MCQ question (output based) | 1 |
| 7 | Exception based MCQ question (dict example) | 1 |
| 8 | List method based MCQ question | 1 |
| 9 | Tuple based MCQ question | 1 |
| 10 | Text file based fill in the blank question using seek() tell() | 1 |
| 11 | True False from exception handling | 1 |
| 12 | Local global out based MCQ using function | 1 |
| 13 | Alter command based question one line answer | 1 |
| 14 | SQL query output based MCQ (like/between, in etc.) | 1 |
| 15 | SQL data type based MCQ | 1 |
| 16 | Aggregate function based MCQ | 1 |
| 17 | Protocol based MCQ | 1 |
| 18 | Network devices based MCQ | 1 |
| 19 | Switching technique based question one line answer | 1 |
| Q20 and Q21 are Assertion(A) and Reason(R) based questions. Mark the correct choice as: (A) Both A and R are true and R is the correct explanation for A (B) Both A and R are true and R is not the correct explanation for A (C) A is True but R is False (D) A is False but R is True | ||
| 20 | Function arguments based | 1 |
| 21 | Where having based |
| QNo. | Section-C ( 3 x 3 = 9 Marks) | Marks |
| 29 | (A) Text file based question to write a function OR (B)Text file based question to write a function | 3 |
| 30 | (A) Stack based question (i) push (ii) pop (iii) peep OR (B) Stack based program using List | 3 |
| 31 | SQL table based question (A) (i) query using aggregate function with Group by (ii) query based on order by (iii) query with distinct OR (B) (i)query using aggregate function with Group by (ii) query based on delete (iii) query using aggregate function with null | 3 |
| QNo. | Section-D ( 4 x 4 = 16 Marks) | Marks |
| 32 | Exception based question (A) (i) Exception based question (ii) sample code of Try Except OR (B) (i) Exception based question (ii) Try Except | 4 |
| 33 | CSV file based question (i) Read data from file and display records on basis of given condition (ii) count number of records or similar question | 4 |
| 34 | SQL Two table based question (i) Natural join based query (ii) IN/Between type query (iii) Update/Like query (iv)Natural join based query OR Natural join based query | 4 |
| 35 | SQL-Python connectivity based question Write a function to add the given records(as per given data types)and display the data on basis of given condition | 4 |
| QNo. | Section-E ( 2 x 5 = 10 Marks) | Marks |
| 36 | File based question (Text/Binary/CSV) (i) selection of appropriate file with justification (ii) write a function to insert/append data on file (iii) write a function to read sand display data on condition basis | 5 |
| 37 | Networking based question (i) Server based question (ii) hub/switch based question (iii) Cable layout based question (iv)repeater based question (v)Voip/Telnet/Internet/Email based question OR PAN,LAN,MAN,WAN based question | 5 |