CBSE Class 12 Computer Science Sample Paper 2023 Solved

SECTION A

1. State True or False
“Variable declaration is implicit in Python.”

Answer : TRUE

2. Which of the following is an invalid datatype in Python?
(a) Set
(b) None
(c) Integer
(d) Real

Answer : D

3. Given the following dictionaries
dict_exam={"Exam":"AISSCE", "Year":2023}
dict_result={"Total":500, "Pass_Marks":165}
Which statement will merge the contents of both dictionaries?
a. dict_exam.update(dict_result)
b. dict_exam + dict_result
c. dict_exam.add(dict_result)
d. dict_exam.merge(dict_result)

Answer : A

4. Consider the given expression:
not True and False or True
Which of the following will be correct output if the given expression is evaluated?
(a) True
(b) False
(c) NONE
(d) NULL

Answer : A

5. Select the correct output of the code:
a = "Year 2022 at All the best"
a = a.split('2')
b = a[0] + ". " + a[1] + ". " + a[3]
print (b)
(a) Year . 0. at All the best
(b) Year 0. at All the best
(c) Year . 022. at All the best
(d) Year . 0. at all the best

Answer : A

6. Which of the following mode in file opening statement results or generates an error if the file does not exist?
(a) a+
(b) r+
(c) w+
(d) None of the above

Answer : B

7. Fill in the blank:
______ command is used to remove primary key from the table in SQL.
(a) update
(b)remove
(c) alter
(d)drop

Answer : C

8. Which of the following commands will delete the table from MYSQL database?
(a) DELETE TABLE
(b) DROP TABLE
(c) REMOVE TABLE
(d) ALTER TABLE

Answer : B

9. Which of the following statement(s) would give an error after executing the following code?
S="Welcome to class XII" # Statement 1
print(S) # Statement 2
S="Thank you" # Statement 3
S[0]= '@' # Statement 4
S=S+"Thank you" # Statement 5
(a) Statement 3
(b) Statement 4
(c) Statement 5
(d) Statement 4 and 5

Answer : B

10. Fill in the blank:
_________ is a non-key attribute, whose values are derived from the mprimary key of some other table.
(a) Primary Key
(b) Foreign Key
(c) Candidate Key
(d) Alternate Key

Answer : B

11. The correct syntax of seek() is:
(a) file_object.seek(offset [, reference_point])
(b) seek(offset [, reference_point])
(c) seek(offset, file_object)
(d) seek.file_object(offset)

Answer : A

12. Fill in the blank:
The SELECT statement when combined with __________ clause, returns records without repetition.
(a) DESCRIBE
(b) UNIQUE
(c) DISTINCT
(d) NULL

Answer : C

13. Fill in the blank:
______is a communication methodology designed to deliver both voice and multimedia communications over Internet protocol.
(a) VoIP
(b) SMTP
(c) PPP
(d)HTTP

Answer : A

14. What will the following expression be evaluated to in Python?
print(15.0 / 4 + (8 + 3.0))
(a) 14.75
(b)14.0
(c) 15
(d) 15.5

Answer : A

15. Which function is used to display the total number of records from table in a database?
(a) sum(*)
(b) total(*)
(c) count(*)
(d) return(*)

Answer : C

16. To establish a connection between Python and SQL database, connect() is used. Which of the following arguments may not necessarily be given while calling connect() ?
(a) host
(b) database
(c) user
(d) password

Answer : B