SAMPLE QUESTION PAPER (2021-22)
COMPUTER SCIENCE (083)
TERM II
CLASS 12
Time: 2 Hrs Max. Marks: 35
GENERAL INSTRUCTIONS
Programming language is Python.
• This question paper is divided into 3 sections A, B and C.
• Section A has 7 Questions (1-7). Each question carries 2 marks.
• Section B has 3 Questions (8-10). Each question carries 3 marks.
• Section C has 3 case-based Questions (11-13). Each question carries 4 marks.
• Internal choices have been given for question numbers 1, 3, 8 and 12.
SECTION A
Q.1 What is a stack? Write two operations that can be performed on the stack.
Q.2. (i) Expand the following terms: (a) VoIP, (b) NIC.
(ii) Which device is used to regenerate the weak signals for long-distance transmission?
Q.3. Consider a table ‘Online_Class’ with the following structure:
(i) Identify the data types of Date_of_Class and Charges columns.
(ii) If a column ‘passcode’ contains only 4 letters password information like ‘1#a4’ then out of char or varchar,which data type is suitable for this column. Justify your answer.
Q.4. What are the different parameters in connect() function of mysql.connector?
There are four parameters in connect() function:
Q.5. Write the output of the queries (i) to (iv) based on the table Product given below:
(i) Select P_Name, P_Price from Product Where P_Price>1500;
(ii) Select PId, P_Name, P_Price * P_Qty from Product Where P_Name Like ‘%e’;
(iii) Select Max(Date_Of_Purchase) from Product Where P_Price>500;
(iv) Select Sum(P_Price) from Product Where P_Price * P_Qty >3000;
Q.6. (i) Which command is used to create a database in SQL?
(ii) How will you calculate columns and rows in a cross join?
Q.7. Consider the table Employee with the following records:
(i) What could be the possible reason when inserting a new row using the following command gives an error? Justify your answer.
Insert Into Employee Values(‘E104’, ‘Jai Gupta’, ‘Manager’, 80000, ‘2020-12-10’);
(ii) What would be the cardinality and degree of the table when 3 more rows are added to the table?
OR
Consider the table PF_Details and answer the following questions:
(i) Identify the Primary and Foreign keys of table PF_Details if the Employee table given above is linked to this table.
(ii) Can we delete the record of any employee from the table PF_Details?
SECTION B
Q.8. Pankaj has to create a record of books containing BookNo, BookName and BookPrice. Write a userdefined function to create a stack and perform the following operations:
• Input the Book No, BookName and BookPrice from the user and Push into the stack.
• Display the status of stack after each insertion.
OR
Write a function in Python PUSH(Arr), where Arr is a list of numbers. From this list push all numbers divisible by 3 into a stack implemented using a list. Display the stack if it has at least one element, otherwise display appropriate error message.
Q.9 (i) A table Voter_list is created with the following columns: V_ID, V_Name, V_Address, V_Age, V_AreaCode, V_Gender, V_Phone_No Write an SQL command to delete column V_Phone_No from the table Voter_list.
(ii) Differentiate between Alter and Update commands with the help of examples
Q.10. Rashmi has to create a table in SQL to store the records of students and their projects submission information. The structure of the table Project_Info is:
Help Rashmi to complete the following tasks:
(i) To create the table Project_Info.
(ii) She has forgotten to add the Primary key to this table. Write a command to add Primary key to column Stud_Roll_No
SECTION C
Q. 11. Consider the following tables Activity and Coach. Write SQL commands for the statements (i) to (iv).
(i) To display the name of all activities with their Acodes in descending order.
(ii) To display the sum of PrizeMoney for each of the number of participants group-wise.
(iii) To display the content of the Activity table where Scheduled_date is earlier than 2022-02-26 in ascending order of Participant_Num.
(iv) To display Participant_Num from Activity table without repetition.
Q.12. (i) Differentiate between Bus topology and Star topology.
OR
Define the following terms: Web browser, Protocols.
(ii) Differentiate between Client-Server and Peer-to-Peer networks.
Q.13. Bright Study University is setting up its academic centres in Gurugram and planning to set up a network. The university has 3 academic centres and one administration centre as shown in the diagram given below:
(i) Suggest and draw a cable layout to efficiently connect various centres within the university.
The most suitable cable layout is:
(ii) Which device will you suggest to be placed/ installed in each of these centres to efficiently connect all the computers within the university?
(iii) Name the centre where the server is to be installed. Justify your answer.
(iv) The university is planning to connect its admin office in the closest big city, which is more than 350 km from the university. Which type of network out of LAN, MAN or WAN will be formed? Justify your answer