Class 12 Computer Science (083) Multiple Choice Questions (2023-24)- SOLVED
Q1. Which of the following is an invalid datatype in Python?
(a) Set
(b) None
(c) Integer
(d) Real
Q2. Which of the following join gives the intersection of two tables?
(a) Inner join
(b) Outer join
(c) Equi join
(d) None of these
Q3. What will be the output of the following statement:
print(3-2**2**3+99/11)
(a) 244
(b) 244.0
(c) -244.0
(d) Error
Q4. 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
Q5. Consider the given expression:
not True and False or True
Which of the following will be the correct output if the given expression is evaluated?
(a) True
(b) False
(c) NONE
(d) NULL
Q6. Select the correct output of the code:
s = "Python is fun"
l = s.split()
s_new = "-".join([l[0].upper(), l[1], 1[2].capitalize()])
print (s_new)
Options:
(a) PYTHON-IS-Fun
(b) PYTHON-is-Fun
(c) Python-is-fun
(d) PYTHON-Is-Fun
Q7. 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
Q8. Which of the following will delete the key-value pair for key = “Red” from a dictionary D1?
(a) delete D1("Red")
(b) del D1["Red"]
(c) del.D1["Red"]
(d) D1.del["Red"]
Q9. Which of the following modes in the 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
Q10. Which value type does input( ) return?
(a) Float
(b) Boolean
(c) Int
(d) String
Q11. A protective covering that protects the optical fibre from the outside environment is known as
(a) Core
(b) Jacket
(c) Buffer
(d) Cladding
Q12. Fill in the blank:
______ command is used to remove the primary key from a table in SQL.
(a) update
(b) remove
(c) alter
(d) drop
Q13. In the MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and another table, Beta has degree 3 and cardinality 5, what will be the degree and cardinality of the Cartesian product of Alpha and Beta?
(a) 5,3
(b) 8,15
(c) 3,5
(d) 15,8
Q14. Riya wants to transfer pictures from her mobile phone to her laptop. She uses Bluetooth Technology to connect two devices. Which type of network will be formed in this case?
(a) PAN
(b) LAN
(c) MAN
(d) WAN
Q15. Which of the following real-time examples is based on Insertion sort?
(a) database scenarios and distributes scenarios
(b) arranging books on a library shelf
(c) real-time systems
(d) arranging a pack of playing cards
Answers:
1. (d) Real
2. (a) Inner join
3. (c) -244.0
4. (a) Year . 0. at All the best
5. (a) True
6. (b) PYTHON-is-Fun
7. (a) dict_exam.update(dict_result)
8. (b) del D1["Red"]
9. (b) r+
10. (d) String
11. (c) Buffer
12. (c) alter
13. (b) 8,15
14. (a) PAN
15. (d) arranging a pack of playing cards
Database Concepts (Important Terms)
Divisibility Rules
SQL Commands (Summary)
Worksheet on Database Management Systems
No comments:
Post a Comment
We love to hear your thoughts about this post!
Note: only a member of this blog may post a comment.