Computer Science – Class 12 – Pre Board Examination Question Paper

12COM03QP
KENDRIYA VIDYALAYA SANGATHAN , CHENNAI REGION
PRE-BOARD-I EXAMINATION 2023-2024
CLASS XII-COMPUTER SCIENCE (083)
TIME: 03 HOURS M.M.: 70
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A has 18 questions carrying 01mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 02 Long Answer type questions carrying 04 marks each.
7. Section E has 03 questions carrying 05 marks each.
8. All programming questions are to be answered using Python Language only.
SECTION A
1. Assign a tuple containing an Integer? (1)


2. Which of the following data type in Python supports concatenation? (1)
a) int b) float c) bool d) str
3. What will be output of the following code: (1)
d1={1:2,3:4,5:6}
d2=d1.popitem()
print(d2)
a){1:2} b){5:6} c)(1,2) d)(5,6)


4. The correct output of the given expression is: (1)
True and not False or False
(a)False (b)True(c)None (d) Null

5. Fill in the blank: (1)
Command is used to add a new column in a table in SQL.
a)update b)remove c)alter d)drop
6. Consider the Python statement: f.seek(10, 1) (1)
Choose the correct statement from the following:

(a) File pointer will move10 byte in forward direction from beginning of the file
(b) File pointer will move 10 byte in forwarddirection from end of the file
(c) File pointer will move 10 byte inforwarddirection from current location
(d) File pointer will move 10 byte in backward direction from current location
7. Choose correct SQL query which is expected to delete all rows of a table emp without (1)
deleting its structure.
a) DELETE TABLE;
b) DROP TABLE emp;
c) REMOVE TABL emp;
d) DELETE FROM emp;
8. Which of the following is NOT a DML Command? (1)
(a)Insert (b)Update (c)Drop (d)Delete

, 9. Select the correct outpu to the code: (1)
a="Year2022atallthe best"
a=a.split('a')
b=a[0]+"-"+a[1]+"-"+a[3]
print (b)

a) Year–0-atAllthebest
b) Ye-r2022-llthe best
c) Year–022-at Allthebest
d) Year–0-atallthebest

10. Which of the following statement(s) would give an error during execution?
S="Lucknow is the Capital of UP " #Statement1

print(S) #Statement2

S[4]='$’ #Statement3

S="Thankyou" #Statement4

S=S+"Thankyou" #Statement5

(a)Statement3 (b)Statement4 (c)Statement5 (d)Statement4and5

11. Which of the following function returns a list datatype? (1)
a) d=f.read() b) d=f.read(10) c) d=f.readline() d)d=f.readlines()

12. Select the correct statement,with reference to SQL: (1)
a) Aggregate functions ignore NULL
b) Aggregate functions consider NULL as zero or False
c) Aggregate functions treat NULL as a blank string
d) NULL can be written as 'NULL' also.

13. Fill in the blank: (1)
The is a mail protocol used to retrieve mail from a remote server to a local
email client.
(a)VoIP (b) FTP (c)POP3 (d)HTTP
14. What will be the value of y when following expression be evaluated in (1)
Python?
x=10.0
y=(x<100.0) and x>=10
(a)110 (b)False (c)Error (d)True
15. All aggregate functions except ignore null values in their input collection. (1)
(a) Count(attribute)
(b) Count(*)
(c) Avg
(d) Sum
16. Which of the following method is used to create a connection between the MySQL (1)
database and Python?
a) (a) connector ( ) (b) connect ( ) (c) con ( ) (d)cont()