KENDRIYA VIDYALAYA SANGATHAN
CHANDIGARH REGION
SAMPLEQUESTION PAPER
CLASSXI
SUBJECT:INFORMATICSPRACTICES(065)
GeneralInstructions:
1. Thisquestionpapercontains fivesections,Section AtoE.
2. Allquestionsarecompulsory.
3. SectionA have18 questionscarrying 01markeach.
4. SectionBhas07 Very ShortAnswer typequestionscarrying02 markseach.
5. SectionChas05 ShortAnswertypequestionscarrying03 markseach.
6. SectionDhas03 LongAnswertypequestionscarrying05 markseach.
7. SectionEhas02 questionscarrying04 markseach.
8. Allprogramming questionsare to beanswered usingPython Languageonly.
PART A
1 WhichofthefollowingisvalidarithmeticoperatorinPython: 1
(i)//(ii) &&(iii) > (iv)and
2 Outofthefollowing,whichoneisanexampleforUtilitysoftware? 1
a. Operatingsystem
b. Antivirussoftware
c. compiler
d. MSWord
3 In DML,Mstands for 1
a. maintain
b. manage
c. manipulation
d. manipulate
4 Whichofthefollowingiscorrect? 1
a. Keywords canbeusedas avariablename.
b. Variablenamecanstartwithadigit.
c. Variablenamecanstartwithanunderscore.
d. Variablenamecanhavesymbols like: @,#,$ etc.
133 | Page
5 Identifytheoddonefromthefollowing: 1
a. MySQL
b. SQLite
c. Python
d. Oracle
6 considerL=(2,3,4).Whatistheoutputofprint(L*2)a.(2,3,4),(2,3,4 1
)
b.(2,3,4,2,3,4)
c.(2,2,3,3,4,4)
[Link]
134 | Page
7 A candidate key that is not a primary key 1
arecalled
a. Superkey
b. AlternateKey
c. PrimaryKey
d. ForeignKey
8 Thedevicecapableofrecognizingapre- 1
specifiedtypeofmarkmadewithdarkpencilorink
a. OCR
b. OMR
c. MICR
d. Barcodereader
9 Evaluate: 1
not(1==1and0!=1)
a. True
b. False
c. Error
d. Cannotsay
10 Thenumberofrowsin arelationis called 1
a. Tuple
b. Attribute
c. Cardinality
d. Degree
11 WhichoneisnotacharacteristicofBigData? 1
a. Volume
b. Variety
c. Velocity
d. Virtual
12 IdentifythecorrectSQLquerytocreateadatabasenamedSCHOOL 1
a. CREATESCHOOL;
b. CREATEDATABASESCHOOL;
c. CREATESCHOOLDATABASE;
d. CREATEDATABASESSCHOOL;
135 | Page
13 1GBisequivalentto 1
a. 210bytes
b. 230bytes
c. 220bytes
d. Noneoftheabove
14 WhichSQLcommandhelpstofetchdatafromarelation. 1
a. Use
b. Show
c. Fetch
d. Select
136 | Page
15 In IoT,T standsfor 1
a. Technology
b. Things
c. Technical
d. Traffic
16 D1={1:‘India’,2:‘Russia’,3:‘World’} 1
D2={‘School’: ‘EOIS’, ‘Place’:
‘Moscow’}print([Link](D2))
Writetheoutputoftheabovecode:
a. None
b. {1:'India',2:'Russia',3:'World','School':'EOIS','Place':'Moscow'}
c. Error
d. Noneoftheabove
Q17and18areASSERTIONANDREASONINGbasedquestions.
Markthecorrectchoiceas
i. BothA and RaretrueandRisthecorrect explanation forA
ii. BothAand Raretrueand Risnotthecorrectexplanation forA
iii. AisTruebutRis False
iv. A is falsebutRisTrue
17 Assertion(A):MySQLisopensource. 1
Reason(R):MySQLisnotavailableforfreeofcost.
18 Assertion (A) : Python is an interpreted 1
[Link](R):pythonexecutesthecodelinebyline.
PART B
19 Distinguishbetweenprimarymemoryandsecondarymemory? 2
OR
Whatisthefunctionofinputdevices?Writeanytwoexamples?
20 Identifythecategory(Freeandopensource/proprietary/Freeware)offollowingsof 2
tware:
a. OpenOffice
b. AdobePhotoshop
c. Skype
d. Python
137 | Page
21 Whatwillbetheoutputofthefollowingcodep=10 2
q=20
p*=q/2q+=p+
q*2print('p=',
p)
print('q=',q)
138 | Page
22 CategorizefollowingcommandsintoDDLandDMLcommands?INSERT,DROP,ALTE 2
R,UPDATE
23 Whatwillbetheoutputofthefollowingprogram?a,b,c=10,20,30 2
a,b,a =
c+2,a+5,c+3print(a,b)
OR
What will be the
output?fornuminrange(2,10,
2):
s=0print(num,end=’’
)s=s+num
print(“sum=”,s)
24 Arvind is learning MySQL for managing different databases andtables for his 2
Python based application/software. Tell him the SQLcommands forthe
following:-
(i) Howtoshowpre-existingdatabases.
(ii) Howto useadesireddatabase
25 Withthehelpofsuitabletable,explaincandidatekeyandalternatekey? 2
PARTC
26 Brieflyexplaincomputersystemwithneatdiagram 3
27 Evaluatethefollowinga.17 3
//5
b.25>10 and50<10
c.15<5or7>10and3>2ornot5d.
28 a. WhatarethedifferentdatatypesinSQL. 1+2
b. DifferentiatebetweencharandvarchardatatypeinSQL?c.
139 | Page
29 a. Explaingridcomputing? 3
b. Listoutthethreecloudcomputingservices?
c. WriteanytwoapplicationsofArtificialIntelligence
OR
Whatisbigdata? What arethecharacteristicsofbig data?
140 | Page
30 Considerthegivenlist,L=[20,30,40,100].Whatwillbetheoutputofthe following: 3
i. print(L*2)
ii. print(L[-2])
iii. print([Link]())
or
Explainthefollowinglistfunctionswithexample:
i. insert()
ii. remove()
iii. append()
PARTD
141 | Page
31 WriteoutputforSQLqueries(i)to(v)basedonthetable:SCHOOL 5
i. SELECT * FROM SCHOOL
WHERESUBJECT=’ENGLISH’;
ii. SELECTCODE,TEACHERNAMEFROMSCHOOL;
iii. SELECTSUBJECTFROMSCHOOL;
iv. SELECTTEACHERNAMEFROMSCHOOLWHEREEXPERIENCE>10;
v. SELECT DOJ FROM SCHOOL
WHERESUBJECT=’CHEMISTRY’OREXPERIENCE=15;
OR
i. ListoutanytwoexamplesforRDBMS.
ii. Write any two advantages of database over
traditionalfilesystem.
iii. Whatis SQL?
iv. Writethedatatypeforthecolumnteachernameandexperienc
e.
v. WhichSQLclauseisusedtoapplyconditiontoindividual
rows.
142 | Page
32 [Link] 5
ionis1$=₹[Link]:rupee=input("Enter the amount
in rupees:")#Statement
1dollar=rupee//72.5#Formulaforconversion#(Statement2)
ifdollar>1:#Statement3
print("Amountindollarsis:",dollar,end='')#Statement4
else:
print("Enter valid amount!!!",end=
'')print("Thankyouforusingcurrencyconverter!")
i.Findouttheerrorinstatement1:
a. Noerror
b. Singlequotationstobeusedinplaceofdoublequotationmarks
c. Typeconversionfunctiontobeused
d. Noneoftheabove
ii.Istheoperatorusedinstatement2correct?Ifnot,whichisthecorrectone?
a. //is correct
b. /
c. %
d. Noneoftheabove
iii.Thecommentusedinstatement2(showninboldletters)is:
a. Singlelinecomment
b. Multilinecomment
c. Inlinecomment
d. Specificcomment
[Link] datatypeforrupeewill be
a. string
b. int
c. float
d. list
v. Suppose the input value rupees is accepted in integer form, thenwhat will
be the output of the above program, when theinput isgiven as200?
143 | Page
33 ConsiderthegiventableandwriteSQLqueriesforthefollowing: 5
i. Tocreatethetableorganisation.
ii. Toaddonemorerowwiththegivenvalues(2006,REENA,DEPUTYMAN
AGER,D001,22-DEC-2012)
iii. Todisplaythepostfromthetableorganisation?
144 | Page
iv. TodisplaythenameandpostofemployeeswhoseSGRADEisD003.
v. TodisplaytheSGRADEandPOSTofallemployees.
OR
Explainthefollowingtermswithanexampletable:
i. Relation
ii. Tuple
iii. Domain
iv. primarykey
v. cardinality
PART E
34 Consider the following table “ACTIVITY” and answer 1+1+2
thefollowingquestionbasedon thistable?
a. Whatisthedegreeandcardinalityofthegiventable?
b. Supposetwomorecolumnsareaddedtothegiventable,thenwhatwillbeth
e cardinalityand degree?
c. Writethenamesofmostappropriatecolumns,whichcanbeconsidered
asPrimary [Link] youranswer
OR (Optionfor partconly)
DifferencebetweenDDLandDMLwithexample?
35 Considerthegivendictionary, 1+1+2
D={1:’monday’,2:’Tuesday’,3:’Wednesday’,4:’Thursday’}.
a. Whatwillbetheoutputoffollowingcode:
i. print([Link]())
ii. print([Link](2))
b. writepythoncodetoadd anewvalue‘Friday‘withindex5.
Or(Option for part bonly)
Writepythoncodetoremovethevalue‘Wednesday’fromthedictionary.
145 | Page