Page 18 - PYTHON-12

15. Which SQL datatype is used to store whole numbers without any decimal points? (1)
(a) INT
(b) FLOAT
(c) VARCHAR
(d) BOOLEAN

Ans. (a) INT
16. What does AND operator do in SQL WHERE clause? (1)
(a) It filters rows based on a single condition.
(b) It combines two or more conditions and returns rows where all conditions are true.
(c) It sorts the results based on multiple conditions.
(d) It combines multiple tables in the result set.
Ans. (b) It combines two or more conditions and returns rows where all conditions are true.

17. Which protocol ensures reliable communication between two devices over a network by establishing a
connection? (1)
(a) POP
(b) ICMP
(c) TCP
(d) HTTP
Ans. (c) TCP

18. In star topology, which device allows devices on a network to communicate by broadcasting data to all the
connected devices? (1)
(a) Switch
(b) Hub
(c) Router
(d) Gateway

Ans. (b) Hub
19. In which topology is a single point of failure a major drawback, as the failure of the main cable can disrupt
the entire network? (1)
Ans. Bus Topology
Q20 and Q21 are Assertion (A) and Reasoning (R) based questions. Mark the correct choice as:

(a) Both A and R are true and R is the correct explanation for A.
(b) Both A and R are true but R is not the correct explanation for A.
(c) A is true but R is false.

(d) A is false but R is true.
20. Assertion (A): The keyword return in Python functions is used to terminate the execution of functions and
return a value to the caller. (1)
Reasoning (R): If return is used without any expression, the function returns None.
Ans. (a) Both A and R are true and R is the correct explanation for A.

21. Assertion (A): In SQL, DELETE command removes rows from a table based on specified conditions. (1)
Reasoning (R): DELETE command temporarily removes data from a table, which can be undone with backups.
Ans. (c) A is true but R is false.

A.4 Computer Science–XII