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 7, 8 and 12.
SECTION A
Q.1 Write a function Push() which takes number as argument and add in a stack “MyValue”
Q.2. Write two advantages and two disadvantages of network.
Q.3. What is the difference between where and having clause in SQL
Q.4. Write a small python program to insert a record in the table books with attributes (title,isbn).
Q.5. Consider the following tables FACULTY and COURSES. Write SQL commands for the statements (i) to (ii) and give outputs for SQL queries (iii) to (iv).
i) To display the details of courses whose fees is in the range of 15000 to 50000 (both values included).
ii) To increase the fees of all courses by 500 of “System Design” Course.
iii) Select COUNT(DISTINCT F_ID) from COURSES;
iv) Select Fname,Cname from FACULTY,COURSE where COURSE.F_ID=FACULTY.F.ID;
Q.6. i) What is constraint?
ii) What are single row functions?
Q.7. Make difference between DELETE and DROP command. Explain with suitable examples of each.
OR
Differentiate between Alter and Update Command
SECTION B
Q.8. Write a function in Python PUSH(Arr), where Arr is a list of numbers. From this list push all numbers divisible by 5 into a stack implemented by using a list. Display the stack if it has at least one element, otherwise display appropriate error message.
OR
Write a function in Python POP(Arr), where Arr is a stack implemented by list of numbers. The function returns the value deleted from the stack.
Q.9 Define degree and cardinality. Based upon given table write degree and cardinality
Q.10. In a database there are two tables ‘LOAN’ and ‘BORROWER’ as shown below:
(i) Write Degree and Cardinality of LOAN table.
(ii) Identify the Primary Key column in the LOAN table.
(iii) How many rows and columns will be there in the natural join of these two tables?
SECTION C
Q. 11. Consider the following table WORKERS and DESIG. Write SQL commands for the statements (i) to (iv).
(i) To display W_ID Firstname, Address and city of all employees living in New York from the table WORKERS.
(ii) To Display the content of WORKERS table in ascending order of LASTNAME.
(iii) To display the Firstname, Lastname and Total Salary of all Clerks from the tables WORKERS and DESIG, Where Total Salary is calculated as a Salary +Benefits.
(iv) To display the Minimum salary among Managers and Clerks from the table DESIG.
Q.12. i) Define the following data communicating devices:
(a) Repeater (b) Gateway
ii) Write the two advantages and two disadvantages of Bus Topology in network.
OR
Define the following: (i)3G (ii)SMS.
Q.13. Multipurpose Public School, Bengaluru is Setting up the network between its Different Wings of school campus. There are 4 wings named as SENIOR(S), JUNIOR(J), ADMIN(A) and HOSTEL(H).
Distance between various wings are given below:
Wing A to Wing S 100m
Wing A to Wing J 200m
Wing A to Wing H 400m
Wing S to Wing J 300m
Wing S to Wing H 100m
Wing J to Wing H 450m
Number of Computers installed at various wings are as follows:
Wings Number of Computers
Wing A 20
Wing S 150
Wing J 50
Wing H 25
a. Suggest the best wired medium and draw the cable layout to efficiently connect various wings of Multipurpose Public School, Bengaluru.
b. Name the most suitable wing where the Server should be installed. Justify your answer.
c. Suggest a device/software and its placement that would provide data security for the entire network of the School.
d. Suggest a device and the protocol that shall be needed to provide wireless Internet access to all smartphone/laptop users in the campus of Multipurpose Public School, Bengaluru.