CLASS : XII (SET 2) TIME ALOTTED : 3HRS
SUBJECT :COMPUTER SCIENCE (083) MAXIMUM MARKS : 70
General instructions:
• This question paper contains five sections, Section A to E.
• All questions are compulsory.
• Section A have 18 questions carrying 01 mark each.
• Section B has 07 Very Short Answer type questions carrying 02 marks each.
• Section C has 05 Short Answer type questions carrying 03 marks each.
• Section D has 03 Long Answer type questions carrying marks 05 each.
• Section E has 02 questions carrying 04 marks each. One internal choice is given in Q34
against part C only.
• All programming questions are to be answered using Python Language only.
SECTION – A
1.which statement in SQL allows to change the definition of the table is [1]
a) alter b) update c)create d) select
2. protocol provides access to command line interface on a remote computer.
(a) FTP (b) PPP (c) Telnet (d) SMTP [1]
3.What will the following code do? [1]
dict={"Exam":"AISSCE", "Year":2022}
dict.update({"Year”:2023})
a.It will create new dictionary dict={” Year”:2023}and old dictionary will be deleted
b. It will throw an error and dictionary cannot updated
c. It will make the content of dictionary as dict={"Exam":"AISSCE","Year":2023}
d. It will throw an error and dictionary and do nothing
4. Which functions is used to close a file in python? [1]
(A) close (B) cloose() (C) Close() (D) close()
5. is a non-key attribute, whose values are derived from the primary key of some other
table. [1]
(A) Primary Key (B) Candidate Key (C) Foreign Key (D) Alternate Key
6. Which of the following is not a valid python operator? [1]
a) % b) in c) # d) **
7. Select the correct output of the following python Code: [1]
str="My program is program for you"
t = str.partition("program")
print(t)
a) ('My ', 'program', ' is ', 'program', ' for you')
b) ('My ', 'program', ' is program for you')
c) ('My ', ' is program for you')
d) ('My ', ' is ', ' for you')
, 8. Which of the following statements is True? [1]
a) There can be only one Foreign Key in a table.
b) There can be only one Unique key is a table
c) There can be only one Primary Key in a Table
d) A table must have a Primary Key.
9. What will be the output of the following python expression?print(2**3**2) [1]
a) 64 b) 256 c) 512 d) 32
10. Which of the following is used to receive emails over Internet? [1]
a) SMTP b) POP3 c) PPP d) VoIP 8.
Q11 and 12 are ASSERTION AND REASONING based questions. Mark the correct choice
as [1]
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False (d) A is false but R is True
11. Assertion (A):- If the arguments in a function call statement match the number and order
of arguments as defined in the function definition, such arguments are called positional
arguments.
Reasoning (R):- During a function call, the argument list first contains default argument(s)
followed by positional argument(s).
12. Assertion (A): CSV (Comma Separated Values) is a file format for data storage which
looks like atext file.
Reason (R): The information is organized with one record on each line and each field is
separatedby comma
13. The correct syntax of seek()is: [1]
(a) file_object.seek(offset [, reference_point]) (b) seek(offset [,reference_point])
(c) seek(offset, file_object) (d)seek.file_object(offset)
14. Which of the following is not a legal method for fetching records from a database from
within aPython program? [1]
(a) fetchone() b)fetchtwo() (c) fetchall() (d) fetchmany()
15.Consider the given expression: not ((True and False) or True) [1]
Which of the following will be correct output if the given expression is evaluated?
(A) True (B) False (C) NONE (D) NULL
16. say true or false : [1]
“ A dictonary key must be of a data type that is mutable
17. The statement which is used to get the numbers of rows fetched by execute() method of
cursor [1]
a)cursor.rowcount b) cursor.rowcount() c)cursor.allrows() d) cursor.countrows()
18.The SELECT statement when combined with clause, returns records without
repetition. [1]
(A) DISTINCT (B) DESCRIBE (C) UNIQUE (D) NULL
SECTION B
SUBJECT :COMPUTER SCIENCE (083) MAXIMUM MARKS : 70
General instructions:
• This question paper contains five sections, Section A to E.
• All questions are compulsory.
• Section A have 18 questions carrying 01 mark each.
• Section B has 07 Very Short Answer type questions carrying 02 marks each.
• Section C has 05 Short Answer type questions carrying 03 marks each.
• Section D has 03 Long Answer type questions carrying marks 05 each.
• Section E has 02 questions carrying 04 marks each. One internal choice is given in Q34
against part C only.
• All programming questions are to be answered using Python Language only.
SECTION – A
1.which statement in SQL allows to change the definition of the table is [1]
a) alter b) update c)create d) select
2. protocol provides access to command line interface on a remote computer.
(a) FTP (b) PPP (c) Telnet (d) SMTP [1]
3.What will the following code do? [1]
dict={"Exam":"AISSCE", "Year":2022}
dict.update({"Year”:2023})
a.It will create new dictionary dict={” Year”:2023}and old dictionary will be deleted
b. It will throw an error and dictionary cannot updated
c. It will make the content of dictionary as dict={"Exam":"AISSCE","Year":2023}
d. It will throw an error and dictionary and do nothing
4. Which functions is used to close a file in python? [1]
(A) close (B) cloose() (C) Close() (D) close()
5. is a non-key attribute, whose values are derived from the primary key of some other
table. [1]
(A) Primary Key (B) Candidate Key (C) Foreign Key (D) Alternate Key
6. Which of the following is not a valid python operator? [1]
a) % b) in c) # d) **
7. Select the correct output of the following python Code: [1]
str="My program is program for you"
t = str.partition("program")
print(t)
a) ('My ', 'program', ' is ', 'program', ' for you')
b) ('My ', 'program', ' is program for you')
c) ('My ', ' is program for you')
d) ('My ', ' is ', ' for you')
, 8. Which of the following statements is True? [1]
a) There can be only one Foreign Key in a table.
b) There can be only one Unique key is a table
c) There can be only one Primary Key in a Table
d) A table must have a Primary Key.
9. What will be the output of the following python expression?print(2**3**2) [1]
a) 64 b) 256 c) 512 d) 32
10. Which of the following is used to receive emails over Internet? [1]
a) SMTP b) POP3 c) PPP d) VoIP 8.
Q11 and 12 are ASSERTION AND REASONING based questions. Mark the correct choice
as [1]
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False (d) A is false but R is True
11. Assertion (A):- If the arguments in a function call statement match the number and order
of arguments as defined in the function definition, such arguments are called positional
arguments.
Reasoning (R):- During a function call, the argument list first contains default argument(s)
followed by positional argument(s).
12. Assertion (A): CSV (Comma Separated Values) is a file format for data storage which
looks like atext file.
Reason (R): The information is organized with one record on each line and each field is
separatedby comma
13. The correct syntax of seek()is: [1]
(a) file_object.seek(offset [, reference_point]) (b) seek(offset [,reference_point])
(c) seek(offset, file_object) (d)seek.file_object(offset)
14. Which of the following is not a legal method for fetching records from a database from
within aPython program? [1]
(a) fetchone() b)fetchtwo() (c) fetchall() (d) fetchmany()
15.Consider the given expression: not ((True and False) or True) [1]
Which of the following will be correct output if the given expression is evaluated?
(A) True (B) False (C) NONE (D) NULL
16. say true or false : [1]
“ A dictonary key must be of a data type that is mutable
17. The statement which is used to get the numbers of rows fetched by execute() method of
cursor [1]
a)cursor.rowcount b) cursor.rowcount() c)cursor.allrows() d) cursor.countrows()
18.The SELECT statement when combined with clause, returns records without
repetition. [1]
(A) DISTINCT (B) DESCRIBE (C) UNIQUE (D) NULL
SECTION B
