MBOSE Class 11 Question Paper 2022 for Computer Science

Total No. of Printed Pages ––7 (2)
(ii) The control instruction carrying part of a system
bus is called
2022
(a) data bus
COMPUTER SCIENCE
(b) control bus
( Theory )
(c) Address bus

Full Marks : 70 (d) I/O bus.

Time : 3 hours

(iii) Which of the following statements is false for List
The figures in the margin indicate full marks for the questions
(a) List can contain values of mixed data types.
General Instructions :
(b) List are formed by placing a comma-
separated list of expression in square
(i) Write all the answers in the Answer Script. brackets.

(ii) Attempt all the questions. (c) List cannot grow or shrink.

(d) None of the above.
1. Choose the correct answer from the following 1 6  6

(i) The Complementary Law, states that (iv) In a relational database a degree refers to

(a) x  x  1, x .x  0 (a) A row of relation.

(b) x  x  x , x.x  x (b) Number of attributes in a relation.

(c) A collection of interrelated data.
(c) x x
(d) Set of one or more attributes to uniquely
(d) None of the above. identify data.

HS/XI/A.Sc.Com./CS/22 HS/XI/A.Sc.Com./CS/22

(3) (4)

(v) The process of attempting to acquire sensitive (iv) What is NoSQL?
information such as username, password, etc is
(v) What are cookies?
(a) Eavesdropping
(vi) What is a database system?
(b) Cyber Bullying
(c) Cyber stalking 3. Answer the following briefly: 2  5  10
(d) Phishing
(i) Draw a flowchart that checks if a given number
is even or odd.
(vi) What will be the output of the following
(ii) What is Dynamic Typing? Explain with an
a=1 example.
a, b = a + 1, a + 1 (iii) With the help of an example show how two or
Print (a) more Lists can be joined together?
Print (b)
(iv) What are functions? Give examples.
(a) 2, 2
(v) What do you know about Identity Operators? Give
(b) 2, 1
examples to show how they work.
(c) 1, 2
(d) 2, 4 4. (i) Write a program to enter N numbers in a tuple
Num, and find the maximum and minimum
values in the tuple. 33  9
2. Answer the following in two or more sentences: 1 6  6 (ii) Using an example, explain the basic string
operators in python.
(i) How does a compiler differ from an interpreter.
(iii) What are Augmented Assignment Operators?
(ii) If dict1={‘Name”: “suzie”, “Roll no”: “46”, “Marks”: Illustrate how they are used in Python.
“85”}, evaluate len (dict1)

(iii) How are Python variables different from other 5. (i) Write a program to find the factorial of an input
programming languages? number. 4

HS/XI/A.Sc.Com./CS/22 HS/XI/A.Sc.Com./CS/22

(5) (6)

Or (ii) Consider the following relation
Write a program to enter a three digit number Employee
and reverse the digits.
E_No E_Name Dept_No Salary DOJ
(ii) Write any two difference between append ( ) and 102 Jack D02 17,654 2000-Jul-18
extend ( ) functions. Illustrate their difference 465 Igor D03 15,078 1999-Aug-11
through an example. 4
326 Steven D02 20,500 1989-Oct-12
149 Jonas D01 25,600 2002-Sep-22
6. (i) State and verify Absorption Law using the truth 136 Julio D03 13,900 2000-Jan-12
table. 2
(a) Using the table ‘Employee’ write SQL commands
(ii) Draw Logic Circuit diagram for the following to list the names of employees in ascending order
expression 2 of date of joining. 1

F ( A, B ,C )  A  (B  C )  (AC )  AB (b) Write a query to find out which employee gets the
highest salary. 1

(c) Write a query to change the column name E_Name
7. (i) Convert any one of the following 2 1  2 to Emp_Name 1
(a) Convert (476)8 to binary
(d) List the name of employees who gets a
salary > 20,000. 1
(b) (100101.110)2 = (?)10
9. Create the following tables and specify the constraints.
(c) (BEE)16 = ( )8
Customer
(ii) Discuss UTF-8 encoding scheme 2 Cust_No Cust_Name Address 1
Order
Order_No Cust_No Order_Item Order_date 1
8. (i) Write down the advantages and disadvantages of
NoSQL. 4 Primary key : Order_No, Cust_No 1
Foreign key : Cust_No.

HS/XI/A.Sc.Com./CS/22 HS/XI/A.Sc.Com./CS/22

(7)

10. Explain the two types of constraints in SQL using
examples. 4

11. Answer the following questions:

(i) What is Cyber Stalking? 2

(ii) What is Spyware? What are the damages caused
by spyware? 1+2

(iii) What are the methods used by Anti-spam software
to get rid of spam? 3

