SECTION - A
1-False
2-C-20
3-D-ValueError
4-B-Break
5-B
6-D
7-is
8-A
9-A-UNIQUE
10-A - 25$$15
11-B
12-A-dict()
13-A-UPDATE
14-B-count()
15-C-FLOAT
16-True
17-C-Repeater
18-D-VoIP
19-Advanced Research Project Agency Network
20-C
21-B
SECTION - B
22:
The return statement in a function is used to send a value back to the caller. If a function does not have a return statement, it returns None by default.
def square(num):
return num * num
result = square(5)
print(result) # Output: 25
23.
(i) Syntax Error in Python:
A Syntax Error in Python occurs when the code violates the rules of the Python language. These errors prevent the program from running because Python cannot interpret the incorrect syntax.
Example of Syntax Errors:
- Missing or Mismatched Parentheses
- Misuse of Keywords
- Incorrect Indentation
- Using Reserved Keywords as Variable Names
- Missing Colon (:) in Control Statements
(ii) Implicit Type Conversion in Python:
Implicit Type Conversion, also known as Type Promotion, occurs when Python automatically converts one data type into another without explicit intervention by the programmer.
Example: Integer to Float Conversion
a = 10 # Integer
b = 2.5 # Float
c = a + b # Integer is automatically converted to Float
print(c) # Output: 12.5
print(type(c)) # Output: <class 'float'>
24 (i)
(a) D['Raj']
(b) len(D1)
(ii)
(a) D1.update(D)
(b) D1.pop('Amit') OR del D1['Amit']
25 - A - Spade#Diamond
26
def Sum(N):
S=0
for I in range(1,N+1):
S=S+I
return S
print(Sum(10))
first line me last me : add hoga
second line add hogi S=0
range me (1,N+1) likha jayega isme (0, N+1) bhi likh sakte hai
print wali line me ) add hoga
27 (i)
(a) EMPNO
(b) NOT NULL
(ii)
(a) Alter table EMPLOYEES modify column BASICSAL float(7,2);
(b) drop table EMPLOYEES
28
(a) URL - Uniform Resource Locator
(b) PPP - Point to Point Protocol
PPP is a data link layer protocol used to establish a direct connection between two network nodes primarily for dial-up internet access, DSL and VPNs
SECTION - C
31
(a) The new string is: g0n2Ge
(b)
SYNTAX ERROR of Indentation in the for loop
OR
(If Syntax Error will remove output should be)
[1, 2, 3]
['ONE', 'TWO', 'THREE']
{1: 'ONE', 2: 'TWO', 3: 'THREE'}
SECTION - D
32.
(a)
(i) Select WNAME, WAGE from worker where WAGE between 800 and 1500;
(ii) Select * from worker where SITEID is NULL;
(iii) Select WNAME, WAGE, HOURS from worker where TYPE = "Skilled";
(iv) Update worker set WAGE=1200 where TYPE="Semiskilled";
(b)
(i)
wname | wage*hours |
+---------+------------+
| Ahmed J | 300000 |
| Anju S | 156000 |
+---------+------------
(ii)
count(distinct type) |
+----------------------+
| 3 |
+----------------------
(iii)
max(wage) | min(wage) | type |
+-----------+-----------+-------------+
| 1500 | 780 | Unskilled |
| 1200 | 520 | Skilled |
| 1200 | 1200 | Semiskilled
(iv)
+---------+--------+
| wname | siteid |
+---------+--------+
| Jacob B | 101 |
| Ahmed J | 103 |
+---------+--------+
34.
(i) Select * from Articles order by price desc;
(ii) Select * from Articles where YEAR(DOC)= 2020;
(iii) DESC Artists;
(iv)
(a) Select Artists.Name from Articles Join Artists on Articles.A_Code=Artists.A_code Where Articles.Article='Painting';
(b) Select Name from Articles natural join artists where article = 'Painting';
SECTION - E
(i) Server should be placed in PSYCHIATRY Block, because it has the maximum number of computers
(ii) Switch
(iii)
Star Topology based on Server location
OR you can design using BUS topology for minimum distance
(iv) Router should be placed in PSYCHIATRY Block
(v)
(a) Telnet
(b) LAN
