CBSE Class 12 Computer Science Important Questions for Board Exam 2024: ALL Chapters PDF Download

CBSE Class 12 Computer Science Important Questions for Board Exam 2024: Central Board of Secondary Education (CBSE) Class 12 Computer Science Board Exam 2024 is to be conducted on April 2, 2024 from 10:30 AM to 1:30 PM. At this time, students must be looking for last-minute revision materials to boost their preparation process one last time before sitting for the exam. To assist you all in the process, we have brought to you CBSE Class 12 Computer Science Important Questions for Board Exam 2024. Practising these important questions can upscale your preparation level and inform you about the types of questions to practise for the exam. Also, get a PDF download link of the important questions here. 

Important Questions for CBSE Class 12 Computer Science Board Exam 2024

Check marks-wise important questions for CBSE Class 12 Computer Board Exam 2024 below. 

Important MCQs for CBSE Class 12 Computer Science Board Exam 2024

Q1: What error occurs when you execute the following Python code snippet? apple = mango

a) SyntaxError

b) NameError

c) ValueError

d) TypeError

Answer. b) NameError

Q2. Which point can be considered as difference between string and list?

a) Length

b) Mutability 

c) Indexing and Slicing

d) Accessing individual elements

Ans: B) Mutability

3. Identify the module to which the following function load () belong to?

a) math 

b) random 

c) pickle 

d) sys

Ans: c) pickle

4. To read the entire remaining contents of the file as a string from a file object myfile, we use

a) myfile.read(2)

b) myfile.read()

c) myfile.readline()

d) myfile.readlines()

Ans: b) myfile.read()

5. If a text file is opened in w+ mode, then what is the initial position of file pointer/cursor?

a) Beginning of file

b) End of the file

c) Beginning of the last line of text file

d) Undetermined

Ans: a)  Beginning of file

For more Class 12 Computer Important MCQs, click on the link below

2 Marks Important Questions for CBSE Class 12 Computer Board Exam 2024

1. Write two advantages and two disadvantages of circuit switching.
2. Differentiate between Web server and web browser. Write the names of any two web browsers.
3. Write a Python Program containing a function FindWord(STRING, SEARCH), that accepts two arguments : STRING and SEARCH, and prints the count of occurrence of SEARCH in STRING. Write appropriate statements to call the function. For example, if STRING = "Learning history helps to know about history with interest in history" and SEARCH = 'history', the function should display The word history occurs 3 times.
4. Differentiate between % (percentage) and _(underscore) characters used with the LIKE operator in SQL with appropriate examples.
5. Consider the following two commands with reference to a table, named Employee having a column named Department: (a) Select count(Department) from Employee; (b) Select count(*) from Employee; If these two commands are producing different results, (i) What may be the possible reason? (ii) Which command (a) or (b) might be giving a higher value? 

3 Marks Important Questions for CBSE Class 12 Computer Board Exam 2024

1. Write a function in Python to read a text file, Alpha.txt and displays those lines which begin with the word ‘You’. 

2. Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named Poem.txt. 

3. A list, NList contains following record as list elements: [City, Country, distance from Delhi] Each of these records are nested together to form a nested list. Write the following user defined functions in Python to perform the specified operations on the stack named travel. 

(i) Push_element(NList): It takes the nested list as an argument and pushes a list object containing name of the city and country, which are not in India and distance is less than 3500 km from Delhi. 

(ii) Pop_element(): It pops the objects from the stack and displays them. Also, the function should display “Stack Empty” when there are no elements in the stack. 

4. Write a function ETCount() in Python, which should read each character of a text file “TESTFILE.TXT” and then count and display the count of occurrence of alphabets E and T individually (including small cases e and t too).

Example: 

If the file content is as follows: 

Today is a pleasant day.

 It might rain today. 

It is mentioned on weather sites 

The ETCount() function should display the output as: 

E or e: 6 

T or t : 9 

5. Write a function INDEX_LIST(L), where L is the list of elements passed as argument to the function. The function returns another list named ‘indexList’ that stores the indices of all Non-Zero Elements of L. 

For example: If L contains [12,4,0,11,0,56] 

The index List will have - [0,1,3,5]

4 Marks Important Questions for CBSE Class 12 Computer Board Exam 2024

1. Vedansh is a Python programmer working in a school. For the Annual Sports Event, he has created a csv file named Result.csv, to store the results of students in different sports events. The structure of Result.csv is :

[St_Id, St_Name, Game_Name, Result]

Where 

St_Id is Student ID (integer) 

ST_name is Student Name (string) 

Game_Name is name of game in which student is participating(string) Result is result of the game whose value can be either 'Won', 'Lost' or 'Tie' 

For efficiently maintaining data of the event, Vedansh wants to write the following user defined functions: 

Accept() – to accept a record from the user and add it to the file Result.csv. The column headings should also be added on top of the csv file. 

wonCount() – to count the number of students who have won any event. As a Python expert, help him complete the task.

2. Write SQL queries for the following: 

(i) Display product name and brand name from the tables PRODUCT and BRAND.

 (ii) Display the structure of the table PRODUCT. 

(iii) Display the average rating of Medimix and Dove brands 

(iv) Display the name, price, and rating of products in descending order of rating

3. Aman is a Python programmer. He has written a code and created a binary file record.dat with employeeid, ename and salary. The file contains 10 records. He now has to update a record based on the employee id entered by the user and update the salary. The updated record is then to be written in the file temp.dat. The records which are not to be updated also have to be written to the file temp.dat. If the employee id is not found, an appropriate message should to be displayed. As a Python expert, help him to complete the following code based on the requirement given above: 

(i) Which module should be imported in the program? (Statement 1) 

(ii) Write the correct statement required to open a temporary file named temp.dat. (Statement 2) 

(iii) Which statement should Aman fill in Statement 3 to read the data from the binary file, record.dat and in Statement 4 to write the updated data in the file, temp.dat?

4. Navdeep creates a table RESULT with a set of records to maintain the marks secured by students in Sem 1, Sem2, Sem3 and their division. After creation of the table, he has entered data of 7 students in the table. 

Based on the data given above answer the following questions: 

(i) Identify the most appropriate column, which can be considered as Primary key. 

(ii) If two columns are added and 2 rows are deleted from the table result, what will be the new degree and cardinality of the above table? 

(iii) Write the statements to:

6. Insert the following record into the table Roll No- 108, Name- Aadit, Sem1- 470, Sem2-444, Sem3- 475, Div – I.

I. Increase the SEM2 marks of the students by 3% whose name begins with ‘N’.

II. Create a function maxsalary() in Python to read all the records from an already existing file record.csv which stores the records of various employees working in a department. Data is stored under various fields as shown below:

Function should display the row where the salary is maximum. 

Note: Assume that all employees have distinct salary. 

Important Resources for Preparation of CBSE Class 12 Computer Science Board Exam 2024

CBSE Class 12 Computer Science Syllabus 2024

CBSE Class 12 Computer Science Sample Paper 2024