Download Computer Science – Class 12 – Examination Question Paper and more Exams Computer science in PDF only on Docsity!
CSC ZONE 4(SOUTH) CLUSTER
COMMON EXAMINATION(2023-2024)
CLASS XII: READING TIME: 15 min SUBJECT: COMPUTER SCIENCE(083) DURATION: 3 Hours General Instructions: Please check this question paper contains 35 questions. The paper is divided into 4 Sections- A, B, C, D and E. Section A, consists of 18 questions (1 to 18). Each question carries 1 Mark. Section B, consists of 7 questions (19 to 25). Each question carries 2 Marks. Section C, consists of 5 questions (26 to 30). Each question carries 3 Marks. Section D, consists of 2 questions (31 to 32). Each question carries 4 Marks. Section E, consists of 3 questions (33 to 35). Each question carries 5 Marks. All programming questions are to be answered using Python Language only. Q.No Question Marks SECTION A
Which of the following can be used as valid variable identifier(s) in Python? a) Total c) Number# b) 5 Th^ Sum d) True
Consider a declaration L = ( 23, “Python”,78.9). Which of the following represents the data type of L? a) List c) Dictionary b)String d) Tuple
What will be the output of the following python statements?
b= for a in range(1,10,2): b+=a+ print(b) a) 31 c) 33 b) 36 d) 39
- Which type of error causes abnormal termination of program while it is executing? a) Syntax error c) Logical error b) Runtime error d) None of the above
- What will be the output for the following python statements? Lst1= [10,20,30,40,50] Lst1.insert(3,4) Lst1.insert(2,3) print(Lst1[-5]) a) 4 c) 4 b) 3 d) 20
- import random x=['Monday', 'Tuesday','Wednesday','Thursday', 'Friday', 'Saturday','Sunday'] print(x[random.randint( 0, len(x) - 2)] ) a) All days of the week except Sunday b) Wednesday c) Saturday d) Wednesday or Saturday
- Which module is to be imported to make the following line functional? sys.stdout.write( “ABC”) a) System c) sys b) Stdout d) stdin
- What will be the output for the following python code def cube (X): return X * X * X
14 Which of the following aggregate functions ignore NULL values? a) COUNT c) MAX b) AVERAGE d) All of these
- Consider the table with the following structure : Employee( E_id, Ename, Dept, desig, basic). In this table which attribute can be used as a primary key? a) Dept c) E_id b) Ename d) desig
- What will be the output of 0.1 + 0.2 = = 0.3? a) True c) False b) Machine dependent d) Error
Directions :In the (17), (18) questions A statement of Assertion (A) is followed by a statement of Reason (R). Mark the correct choice as. a) Both A and R are true and R is the correct explanation of A. b) Both A and R are true and R is not the correct explanation of A. c) A is true but R is false. d) A is false but R is true.
Assertion (A) :String is a sequence which is made up of one or more Unicode character. Reason ( R) : A String can be created by enclosing one or more characters in single, double or triple quote.
- Assertion(A): A hub is a networking device used to create LAN. Reason (R ): A hub is a device that is used to segment networks into different subnetworks.
SECTION-B
- (i) Expand the following terms: ARPANET, NIC (ii) Give one difference between circuit switching technique and packet switching technique OR i)Define the term gateway (ii)How is MAC Address different from IP Address.
- The code given below accepts a number from the user and returns whether the number is a positive or negative number. Observe the following code carefully and rewrite it after removing any/all syntactical errors with each correction underlined. function f1(b): if b>0 then: return “Positive” else return “Negative” m=int(input(“enter an number:”)) msg=f1() print(msg)
2 1. Write a function LShift(Arr,n) in python, which accepts a list Arr of numbers and n is a numeric value by which all elements of the list are shifted to left. Sample input data of the list: Arr=[10,20,30,40,12,15], n= Output: Arr=[30,40,12,15,10,20] OR 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 indexList will have - [0,1,3,5]
What will be scope of the variables a,b,c,x,y? def show( ): a= b= c= def show1( ): x=” happy morning” y= z=
SECTION C
- Predict the output for the following code: I= J= X= I=I+(J-1) X=J+I print(X,":",I) J=J** X=J+I I=I+ print(I,":",J)
- Write the output for the queries 1 to 3 based on the table” Furniture” given below Table: Furniture FID NAME DATE OF PURCHASE COST DISCOUNT B DOUBLE BED 03 - 01 - 2018 45,000 10 T DININING TABLE 10 - 03 - 2020 51,000 5 B SINGLE BED 19 - 07 - 2016 22,000 0 C LONG BACK CHAIR 30 - 12 - 2016 12,000 3 T CONSOLE TABLE 17 - 11 - 2019 15,000 12 B006 BUNK BED 01 - 01 - 2021 28,000 14
1) SELECT SUM(DISCOUNT) FROM FURNITURE
WHERE COST>15000;
2) SELECT MAX(DATE OF PURCHASE) FROM
FURNITURE;
3) SELECT* FROM FURNITURE WHERE
DISCOUNT>5 AND FID LIKE=’T%’
- Write a program to read a text file line by line and display each word separated by a “@” text file content: Python is a programming language. OR Write a function, vowelCount() in Python that counts and displays the number of vowels in the text file named hello.txt.
- Consider the table FLIGHT given below: Table: FLIGHT FNO START END F-DATE FARE F101 MUMBA I CHEN NAI 2021 - 12 - 25 4500 F102 MUMBA I BENG ALUR U 2021 - 11 - 20 4000 F103 DELHI CHEN NAI 2021 - 12 - 10 5500 F104 KOLKAT TA MUM BAI 2021 - 12 - 20 4500 F105 DELHI BENG ALUR U 2021 - 01 - 15 5000 Based on the table, write SQL queries for the following:
- Write a query to change the fare to 6000 of the flight whose FNO is F
- Write a query to delete the records of the flights which end at Mumbai
- To display the average fare of among all the flights
Write a function in python, Push(Sitem) where, Sitem is a dictionary containing the details of Stationary items-
- To display the code and name of all salesperson having “17” item typecode from the table Salesperson
- To display all details from table Salesperson in descending order of Salary
- To display the number of Salesperson dealing in each Type of item, (use ITCode for the same)
- To display Name of all the salesperson table along with their corresponding Itemtype from the Item table.
- Amrithya is a programmer, who is writing the code with the following statements. a) Addstudents() to create a csv file called “student.csv” containing student information roll number, name and marks(out of 100) of each student. b) Getstudents() to display the name and percentage of these students who have a percentage greater than 75. In case there is no student having percentage >75 the function displays an appropriate message. The function should also display the average percent.
SECTION – E
Quick learn university is setting up its academic blocks at Prayag nagar and is planning to setup a network. The university has 3 academic blocks and one HR Centre as shown in the diagram below:
Business block Technology block Law block HR block
Centre to Centre distances between various blocks/ centre is as follows. Law block to business block 40 m Law block to technology block 80 m Law block to HR block 105 m Business block to technology block 30m Business block to HR centre 35 m Technology block to HR centre 15m Number of computers in each of the blocks/centre is as follow: a) Suggest the most suitable place to install server of this university with a suitable reason b) Suggest an ideal layout for connecting these blocks/centers for a wired connectivity c) Which device will you suggest to be placed/ installed in each of these blocks/centers to efficiently connect all the computers within these blocks/centers. d) The university is planning to connect its admission office in the closest big city, which is more than 250 km from university. Which type of network out of LAN, MAN, OR WAN will be formed? Justify your answer. e) Which block is having less number of computers. Law/block 15 Technology block 40 Hr center 115 Business block 25
i)What happens when we use file open() function in python? ii) create file phonebook.txt that stores the details in the following format:
