Category: Class 12

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Business Maths Guide Pdf Chapter 3 Integral Calculus II Miscellaneous Problems Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Business Maths Solutions Chapter 3 Integral Calculus II Miscellaneous Problems

Question 1.
A manufacture’s marginal revenue functional is given by MR = 275 – x – 0.3x². Find the increase in the manufactures total revenue if the production increased from 10 to 20 units.
Solution:
MR = 275 – x – 0.3x²
The increase in the manufactures total revenue 20
T.R = ∫MR dx = (275 – x – 0.3x²) dx

= [5500 – 200 – 0.1 (8000)] – [2750 – 50 – 0.1(1000)]
= [5500 – 200 – 800] – [2750 – 50 – 100]
= 4500 – 2600
= Rs 1900

Question 2.
A company has determined that marginal cost function for product of a particular commodity is given by MC = 125 + 10x – \(\frac { 8 }{3}\). Where C is the cost of producing x units of the commodity. If the fixed cost Rs 250 what is cost of producing 15 units.
Solution:
MC = 125 + 10x – \(\frac { x^2 }{9}\)
Fixed cos t K = Rs 250
C = ∫MC dx – ∫(125 + 10x – \(\frac { x^2 }{9}\)) dx
C = 125x + \(\frac { 10x^2 }{9}\) – \(\frac { x^3 }{9×3}\) + k
C = 125x + 5x² – \(\frac { x^3 }{27}\) + 250
when x = 15
C = 125(15) + 5(15)² – \(\frac { (15)^3 }{27}\) + 250
= 1875 + 1125 – 125 + 250
C = Rs 3,125

Question 3.
The marginal revenue function for a firm given by MR = \(\frac { 2 }{x+3}\) – \(\frac { 2x }{(x+3)^2}\) + 5. Show that the demand function is P = \(\frac { 2x }{(x+3)^2}\) + 5
Solution:

Question 4.
For the marginal revenue function MR = 6 – 3x² – x³, Find the revenue function and demand function
Solution:
MR = 6 – 3x² – x³
Revenue function R = ∫MR dx
R = ∫(6 – 3x² – x³)dx

Question 5.
The marginal cost of production of a firm is given by C'(x) = 20 + \(\frac { x }{20}\) the marginal revenue is given by R’(x) = 30 and the fixed cost is Rs 100. Find the profit function.
Solution:
C'(x) = 20 + \(\frac { x }{20}\)
Fixed cost k₁ = Rs 100
C(x) = ∫C₁(x) dx + k₁

Question 6.
The demand equation for a product is P_d = 20 – 5x and the supply equation is P_s = 4x + 8. Determine the consumers surplus and producer’s surplus under market equilibrium.
Solution:
P_d = 20 – 5x and P_s = 4x + 8
At market equilibrium
P_d = P_d
20 – 5x = 4x + 8 ⇒ 20 – 8 = 4x + 5x
9x = 12 ⇒ x = \(\frac { 12 }{9}\)
∴ x = \(\frac { 4 }{3}\)

Question 7.
A company requires f(x) number of hours to produce 500 units. lt is represented by f(x) = 1800x^-0.4. Find out the number of hours required to produce additional 400 units. [(900)^0.6 = 59.22, (500)^0.6 = 41.63]
Solution:
f(x) number of hours to produce 500
f(x) = 1800 x^-0.4
The number of hours required to produce additions

Question 8.
The price elasticity of demand for a commodity is \(\frac { p }{x^3}\). Find the demand function if the quantity of demand is 3, When the price is Rs 2.
Solution:
Price elasticity of demand

Question 9.
Find the area of the region bounded by the curve between the parabola y = 8x² – 4x + 6 the y-axis and the ordinate at x = 2.
Solution:
Equation of the parabola
y = 8x² – 4x + 6

The required region is bounded by the y-axis and the ordinate at x = 2.
∴ Required Area A = \(\int_{0}^{2}\)ydx

Question 10.
Find the area of the region bounded by the curve y² = 27x³ and the line x = 0, y = 1 and y = 2
Solution:
Equation of the curve is y² = 27x³
⇒ x³ = \(\frac { y^2 }{27}\) = \(\frac { y^3 }{3^3}\)
∴ x = \(\frac { (y)^{2/3} }{3}\)
Since the Area of the region bounded by the given curve and the lines x = 0, y = 1 and y = 2

Read Once:

IGL Pivot Point Calculator

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Business Maths Guide Pdf Chapter 3 Integral Calculus II Ex 3.3 Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Business Maths Solutions Chapter 3 Integral Calculus II Ex 3.3

Question 1.
Calculate consumer’s surplus if the demand function p = 50 – 2x and x = 20
Solution:
Demand function p = 50 – 2x and x = 20
when x = 20, p = 50 – 2(20)
p = 50 – 40 = 10
∴ p₀ = 10
CS = \(\int _{0}^{x}\) (demand function) dx – (Price × quantity demanded)
= \(\int _{0}^{20}\) (50 – 2x)dx – (10 × 20)
= [50x – 2(\(\frac { x^2 }{2}\))]\( _{0}^{20}\) – 200
= [50x – x²]\( _{0}^{20}\) – 200
= {50(20) – (20)² – [0]} – 200
= (1000 – 400) – 200
= 600 – 200
∴ C.S = 400 units

Question 2.
Calculate consumer’s surplus if the demand function p = 122 – 5x – 2x² and x = 6.
Solution:
Demand function p = 122 – 5x – 2x² and x = 6
when x = 6; p = 122 – 5(6) – 2(6)²
= 122 – 30 – 2 (36)
= 122 – 102 = 20
∴ p₀ = 20
C.S = \(\int _{0}^{x}\) (demand function) dx – (Price × quantity demanded)
= \(\int _{0}^{6}\)(122 – 5x – 2x²) dx – (20 × 6)

[732 – 5(18) – 2(72)] – 120
= 732 – 90 – 144 – 120
= 732 – 354 = 378
∴ CS = 378 units

Question 3.
The demand function p = 85 – 5x and supply function p = 3x – 3. Calculate the equilibrium price and quantity demanded. Also calculate consumer’s surplus.
Solution:
Demand function p = 85 – 5x
Supply function p = 3x – 35
W.K.T. at equilibrium prices p_d = p_s
85 – 5x = 3x – 35
85 + 35 = 3x + 5x
120 = 8x ⇒ x = \(\frac { 120 }{8}\)
∴ x = 15
when x = 15 p₀ = 85 – 5(15) = 85 – 75 = 10
C.S = \(\int _{0}^{x}\) f(x) dx – x₀p₀
= \(\int _{0}^{x}\) (85 – 5x) dx – (15)(10)

= 1275 – \(\frac { 1125 }{2}\) – 150
= 1275 – 562.50 – 150
= 1275 – 712.50
∴ CS = 562.50 units

Question 4.
The demand function for a commodity is p = e^-x. Find the consumer’s surplus when p = 0.5
Solution:
The demand function p = e^-x
when p = 0.5 ⇒ 0.5 = e^-x
\(\frac { 1 }{2}\) = \(\frac { 1 }{e^x}\) ⇒ e^x = 2
∴ x = log 2
∴ Consumer’s surplus
C.S = \(\int _{0}^{x}\) (demand function) dx – (Price × quantity demanded)

Question 5.
Calculate the producer’s surplus at x = 5 for the supply function p = 7 + x
Solution:
The supply function p = 7 + x
when x = 5 ⇒ p = 7 + 5 = 12
∴ x₀ = 5 and p₀ = 12
Producer’s surplus

Question 6.
If the supply function for a product is p = 3x + 5x². Find the producer’s surplus when x = 4
Solution:
The supply function p = 3x + 5x²
when x = 4 ⇒ p = 3(4) + 5(4)²
p = 12 + 5(16)= 12 + 80
p = 92
∴ x₀ = 4 and p₀ = 92
Producer’s Surplus

Question 7.
The demand function for a commodity is p = \(\frac { 36 }{x+4}\) Find the producer’s surplus when the prevailing market price is Rs 6.
Solution:
The demand function for a commodity
p = \(\frac { 36 }{x+4}\)
when p = 6 ⇒ 6 = \(\frac { 36 }{x+4}\)
x + 4 = \(\frac { 36 }{6}\) ⇒ x + 4 = 6
x = 2
∴ p₀ = 6 and x₀ = 2
The consumer’s surplus
C.S = \(\int _{0}^{x}\) f(x) dx – x₀p₀
= \(\int _{0}^{2}\) (\(\frac { 36 }{x+4}\)) dx – 2(6)
= 36 [log (x + 4)]\(_{0}^{2}\) – 12
= 36 [log (2 + 4) – log (0 + 4)] – 12
= 36 [log6 – log4] – 12
= 36[log(\(\frac { 6 }{4}\))] – 12
∴ CS = 36 log(\(\frac { 6 }{4}\)) – 12 units

Question 8.
The demand and supply functions under perfect competition are pd = 1600 – x² and p_s = 2x² + 400 respectively, find the producer’s surplus.
Solution:
pd = 1600 – x² and p_s = 2x² + 400
Under the perfect competition p_d = p_s
1600 – x² = 2x² + 400
1600 – 400 = 2x² + x² ⇒ 1200 = 3x²
⇒ x² – 400 ⇒ x = 20 or -20
The value of x cannot be negative, x = 20 when x₀ = 20;
p₀ = 1600 – (20)² = 1600 – 400
P₀ = 1200
PS = x₀p₀ – \(\int _{0}^{x_0}\) g(x) dx

Question 9.
Under perfect competition for a commodity the demand and supply laws are P_d = \(\frac { 8 }{x+1}\) – 2 and Ps = \(\frac { x+3 }{2}\) respectively. Find the consumer’s and producer’s surplus.
Solution:

16 – (x² + 3x + x + 3) = 2 [2(x + 1)]
16 – (x² + 4x + 3) = 4(x + 1)
16 – x² – 4x – 3 = 4x + 4
x² + 4x + 4x + 4 + 3 – 16 = 0
x² + 8x – 9 = 0
(x + 9) (x – 1) = 0 ⇒ x = -9 (or) x = 1
The value of x cannot be negative x = 1 when x₀ = 1
p₀ = \(\frac { 8 }{1+1}\) – 2 ⇒ p₀ = \(\frac { 8 }{2}\) – 2
p₀ = 4 – 2 ⇒ p₀ = 2
CS = \(\int _{0}^{x}\) f(x) dx – x₀p₀
= \(\int _{0}^{1}\) (\(\frac { 8 }{x+1}\) – 2) dx – (1) (2)
= {8[log(x + 1)] – 2x}\(\int _{0}^{1}\) – 2
= 8 {[log (1 + 1) – 2(1)] – 8 [log (0 + 1) – 2(0)]} – 2
= [8 log (2) – 2 – 8 log1] – 2
= 8 log(\(\frac { 8 }{2}\)) – 2 – 2
C.S = (8 log 2 – 4) units
P.S = x₀p₀ – \(\int _{0}^{x_0}\) g(x) dx

Question 10.
The demand equation for a products is x = \(\sqrt {100-p}\) and the supply equation is x = \(\frac {p}{2}\) – 10. Determine the consumer’s surplus and producer’s, under market equilibrium.
Solution:
p_d = \(\sqrt {100-p}\) and p_s = \(\sqrt {100-p}\)
Under market equilibrium, p_d = p_s
\(\sqrt {100-p}\) = \(\frac {p}{2}\) – 10
Squaring on both sides

36p = p² ⇒ p² – 36 p = 0
p (p – 36) = 0 ⇒ p = 0 or p = 36
The value of p cannot be zero, ∴p₀ = 36 when p₀ = 36
x₀ = \(\sqrt {100-36}\) = \(\sqrt {64}\)
∴ x₀ = 8

= 288 – [x² + 20x]\( _{0}^{8}\)
= 288 – { [(8)² + 20(8)] – [0]}
= 288 – [64 + 160]
= 288 – 224 = 64
PS = 64 Units

Question 11.
Find the consumer’s surplus and producer’s surplus for the demand function pd = 25 – 3x and supply function ps = 5 + 2x
Solution:
p_d = 25 – 3x and p_s = 5 + 2x
Under market equilibrium, p_d = p_s
25 – 3x = 5 + 2x
25 – 5 = 2x + 3x ⇒ 5x = 20
∴ x = 4
when x = 4
P₀ = 25 – 3(4)
= 25 – 12 = 13
p₀ = 13

= 52 – [5x + x²]\( _{0}^{4}\)
= 52 – (5(4) + (4)²) – (0)}
= 52 – [20 + 16]
= 52 – 36
∴ PS = 16 units

Read More:

• COROMANDEL Pivot Calculator

Tamilnadu State Board New Syllabus Samacheer Kalvi 12th Business Maths Guide Pdf Chapter 3 Integral Calculus II Ex 3.4 Text Book Back Questions and Answers, Notes.

Tamilnadu Samacheer Kalvi 12th Business Maths Solutions Chapter 3 Integral Calculus II Ex 3.4

Choose the most suitable answer from the given four alternatives:

Question 1.
Area bounded by the curve y = x (4 – x) between the limits 0 and 4 with x-axis is
(a) \(\frac { 30 }{3}\) sq.unit
(b) \(\frac { 31 }{2}\) sq.unit
(c) \(\frac { 32 }{3}\) sq.unit
(d) \(\frac { 15 }{3}\) sq.unit
Solution:
(c) \(\frac { 32 }{3}\) sq.unit
Hint:

Question 2.
Area bounded by the curve y = e^-2x between the limits 0 < x < ∞ is
(a) 1 sq.units
(b) \(\frac { 1 }{2}\) sq.units
(c) 5 sq.units
(d) 2 sq.units
Solution:
(b) \(\frac { 1 }{2}\) sq.units
Hint:

Question 3.
Area bounded by the curve y = \(\frac { 1 }{x}\) between the limits 1 and 2 is
(a) log 2 sq.units
(b) log 5 sq.units
(c) log 3 sq.units
(d) log 4 sq.units
Solution:
(a) log 2 sq.units
Hint:
Area = \(\int_{1}^{2} \frac{1}{x} d x\)
= \((\log x)_{1}^{2}\)
= log 2 – log 1
= log 2 (Since log 1 = 0)

Question 4.
If the marginal revenue function of a firm is MR = e^{\(\frac { -x }{10}\)} then revenue is
(a) 1 – e^-x/10
(b) e^-x/10 + 10
(c) 10(1 – e^-x/10)
(d) -10e^-x/10
Solution:
(c) 10(1 – e^-x/10)
Hint:
MR = e^{\(\frac { -x }{10}\)} then R = ∫MR dx
R = ∫e^-x/10 dx = \(\frac { e^{-x/10} }{(-1/10)}\) + k
R = -10e^-x/10 + k when x = 0, R = 0
⇒ 0 = -10e⁰ + k
0 = -10(1) + k
∴ k = 10
R = -10e^-x/10 + 10 = 10(1 – e^-x/10)

Question 5.
If MR and MC denotes the marginal revenue and marginal cost functions, then the profit functions is
(a) P = ∫(MR – MC) dx + k
(b) P = ∫(R – C) dx + k
(c) P = ∫(MR + MC)dx + k
(d) P = ∫(MR) (MC) dx + k
Solution:
(a) P = ∫(MR – MC) dx + k
Hint:
Profit = Revenue – Cost

Question 6.
The demand and supply functions are given by D(x) = 16 – x² and S(x) = 2x² + 4 are under perfect competition, then the equilibrium price x is
(a) 2
(b) 3
(c) 4
(d) 5
Solution:
(a) 2
Hint:
D(x) =16 – x² and S(x) = 2x² + 4
Under perfect competition D(x) = S(x)
16 – x² = 2x² + 4; 16 – 4 = 2x² + x²
3x² = 12 ⇒ x² = \(\frac { 12 }{3}\) = 4
∴ x = ± 2, x cannot be in negative
∴ x = 2

Question 7.
The marginal revenue and marginal coast functions of a company are MR = 30 – 6x and MC = -24 + 3x where x is the product, profit function is
(a) 9x² + 54x
(b) 9x² – 54x
(c) 54x – \(\frac { 9x^2 }{2}\)
(d) 54x – \(\frac { 9x^2 }{2}\) + k
Solution:
(d) 54x – \(\frac { 9x^2 }{2}\) + k
Hint:
Profit = ∫(MR – MC) dx + k
= ∫(30 – 60) – (-24 + 3x) dx + k
= ∫(54 – 9x) dx + k
= 54x – \(\frac{9 x^{2}}{2}\) + k

Question 8.
The given demand and supply function are given by D(x) = 20 – 5x and S(x) = 4x + 8 if they are under perfect competition then the equilibrium demand is
(a) 40
(b) \(\frac { 41 }{2}\)
(c) \(\frac { 40 }{3}\)
(d) \(\frac { 41 }{5}\)
Solution:
(c) \(\frac { 40 }{3}\)
Hint:
Under perfect competition D(x) = S(x)
20 – 5x = 4x + 8
20 – 8 = 4x + 5x ⇒ 9x = 12
x = \(\frac { 4 }{3}\)
when x = \(\frac { 4 }{3}\); D(x) = 20 – 5(\(\frac { 4 }{3}\)) = 20 – \(\frac { 20 }{3}\)
= \(\frac { 40 }{3}\)

Question 9.
If the marginal revenue MR = 35 +7x – 3x², then the average revenue AR is.
(a) 35x + \(\frac { 7x^2 }{2}\) – x³
(b) 35x + \(\frac { 7x }{2}\) – x²
(c) 35x + \(\frac { 7x }{2}\) + x²
(d) 35x + 7x + x²
Solution:
(c) \(\frac { 40 }{3}\)
Hint:
R = ∫MR dx = ∫(35 + 7x – 3x²) dx

Question 10.
The profit of a function p(x) is maximum when
(a) MC – MR = 0
(b) MC = 0
(c) MR = 0
(d) MC + MR = 0
Solution:
(a) MC – MR = 0
Hint:
P = Revenue – Cost
P is maximum when \(\frac{d p}{d x}\) = 0
\(\frac{d p}{d x}\) = R'(x) – C'(x) = MR – MC = 0

Question 11.
For the demand function p(x), the elasticity of demand with respect to price is unity then.
(a) revenue is constant
(b) a cost function is constant
(c) profit is constant
(d) none of these
Solution:
(a) Revenue is constant

Question 12.
The demand function for the marginal function MR = 100 – 9x² is
(a) 100 – 3x²
(b) 100x – 3x²
(c) 100x – 9x²
(d) 100 + 9x²
Solution:
(a) 100 – 3x²
Hint:
R = ∫(MR) dx + c₁
R = ∫(100 – 9x²) dx + c₁
R = 100x – 3x³ + c₁
When R = 0, x = 0, c₁ = 0
R = 100x – 3x³
Demand function is \(\frac{R}{x}\) = 100 – 3x²

Question 13.
When x₀ = 5 and p₀ = 3 the consumer’s surplus for the demand function p_d = 28 – x²
(a) 250 units
(b) \(\frac { 250 }{3}\) units
(c) \(\frac { 251 }{2}\) units
(d) \(\frac { 251 }{3}\) units
Solution:
(b) \(\frac { 250 }{3}\) units
Hint:

Question 14.
When x₀ = 2 and P₀ = 12 the producer’s surplus for the supply function P₀ = 2x² + 4 is
(a) \(\frac { 31 }{5}\) units
(b) \(\frac { 31 }{2}\) units
(c) \(\frac { 32 }{2}\) units
(d) \(\frac { 30 }{7}\) units
Solution:
(c) \(\frac { 32 }{2}\) units
Hint:
Producer’s Surplus

Question 15.
Area bounded by y = x between the lines y = 1, y = 2 with y = axis is
(a) \(\frac { 1 }{2}\) sq units
(b) \(\frac { 5 }{2}\) sq units
(c) \(\frac { 3 }{2}\) sq units
(d) 1 sq units
Solution:
(c) \(\frac { 3 }{2}\) sq units
Hint:

Question 16.
The producer’s surplus when supply the function for a commodity is p = 3 + x and x₀ = 3 is
(a) \(\frac { 1 }{2}\)
(b) \(\frac { 9 }{2}\)
(c) \(\frac { 3 }{2}\)
(d) \(\frac { 7 }{2}\)
Solution:
(b) \(\frac { 9 }{2}\)
Hint:
p = 3 + x and x₀ = 3
then p₀ = 3 + 3 = 6

Question 17.
The marginal cost function is MC = 100√x find AC given that TC = 0 when the out put is zero is
(a) \(\frac { 200 }{3}\) x^1/2
(b) \(\frac { 200 }{3}\) x^3/2
(c) \(\frac { 200 }{3x^{3/2}}\)
(d) \(\frac { 200 }{3x^{1/2}}\)
Solution:
(a) \(\frac { 200 }{3}\) x^1/2
Hint:
TC = ∫MC dx = ∫100√x dx = 100 ∫(x)^1/2 dx

Question 18.
The demand and supply function of a commodity are P(x) = (x – 5)² and S(x) = x² + x + 3 then the equilibrium quantity x₀ is
(a) 5
(b) 2
(c) 3
(d) 10
Solution:
(b) 2
Hint:
At equilibrium, P(x) = S(x)
⇒ (x – 5)² = x² + x + 3
⇒ x² – 10x + 25 = x² + x + 3
⇒ 11x = 22
⇒ x = 2

Question 19.
The demand and supply function of a commodity are D(x) = 25 – 2x and S(x) = \(\frac { 10+x }{2}\) then the equilibrium price P₀ is
(a) 2
(b) 2
(c) 3
(d) 10
Solution:
(a) 2
Hint:
At equilibrium, D(x) = S(x)
25 – 2x = \(\frac{10+x}{4}\)
⇒ 100 – 8x = 10 + x
⇒ x = 10
That is x₀ = 10
P₀ = 25 – 2(x₀) = 25 – 20 = 5

Question 20.
If MR and MC denote the marginal revenue and marginal cost and MR – MC = 36x – 3x² – 81, then maximum profit at x equal to
(a) 3
(b) 6
(c) 9
(d) 10
Solution
(c) 9
Hint:
Profit P = ∫(MR – MC) dx = ∫(36x – 3x² – 81) dx
P = [\(\frac { 36x^2 }{2}\) – \(\frac { 3x^3 }{3}\) – 81x] = 18x² – x³ – 81x
when p = 0; 18x² – x³ – 81x = 0 ⇒ x² – 18x + 81 = 0
(x – 9)² = 0 ⇒ x – 9 = 0
∴ x = 9

Question 21.
If the marginal revenue of a firm is constant, then the demand function is
(a) MR
(b) MC
(c) C(x)
(d) AC
Solution:
(a) MR
Hint:
MR = k (constant)
Revenue function R = ∫(MR) dx + c₁
= ∫kdx + c₁
= kx + c₁
When R = 0, x = 0, ⇒ c₁ = 0
R = kx
Demand function p = \(\frac{R}{x}=\frac{k x}{x}\) = k constant
⇒ p = MR

Question 22.
For a demand function p, if ∫\(\frac { dp }{p}\) = k ∫\(\frac { dx }{x}\) then k is equal to
(a) n_d
(b) -n_d
(c) \(\frac { -1 }{n_d}\)
(d) \(\frac { 1 }{n_d}\)
Solution:
(c) \(\frac { -1 }{n_d}\)

Question 23.
The area bounded by y = e^x between the limits 0 to 1 is
(a) (e – 1) sq.units
(b) (e + 1) sq.units
(c) (1 – \(\frac { 1 }{e}\)) sq.units
(d) (1 + \(\frac { 1 }{e}\)) sq.units
Solution:
(a) (e – 1) sq.units
Hint:
Area A = \(\int_{a}^{b}\)ydx = \(\int_{0}^{1}\)e^xdx = [e^x]\(_{0}^{1}\)
= [e^x – e°] = [e – 1]

Question 24.
The area bounded by the parabola y² = 4x bounded by its latus rectum is
(a) \(\frac { 16 }{3}\) sq units
(b) \(\frac { 8 }{3}\) sq units
(c) \(\frac { 72 }{3}\) sq units
(d) \(\frac { 1 }{3}\) sq units
Solution:
(b) \(\frac { 8 }{3}\) sq units
Hint:

y² = 4x ⇒ y = \(\sqrt { 4x}\) 2√x = 2(x)^1/2
In this parabola 4a = 4 ⇒ a = 1 and vertex V(0, 0)

Question 25.
The area bounded by y = |x| between the limits 0 and 2 is
(a) 1 sq.units
(b) 3 sq.units
(c) 2 sq.units
(d) 4 sq.units
Solution:
(c) 2 sq.units
Hint:
Area A = \(\int_{a}^{b}\)ydx = \(\int_{0}^{2}\)x dx = [ \(\frac { x^2 }{2}\) ]\(_{0}^{2}\)
= \(\frac { (2)^2 }{2}\) – (0) = \(\frac { 4 }{2}\) = 2

Must Try:

• CONCOR Pivot Calculator

Students can Download Tamil Nadu 12th Computer Science Model Question Paper 2 English Medium Pdf, Tamil Nadu 12th Computer Science Model Question Papers helps you to revise the complete Tamilnadu State Board New Syllabus, helps students complete homework assignments and to score high marks in board exams.

TN State Board 12th Computer Sceince Model Question Paper 2 English Medium

General Instructions:

1. The question paper comprises of four parts.
2. You are to attempt all the parts. An internal choice of questions is provided wherever applicable.
3. All questions of Part I, II, III and IV are to be attempted separately.
4. Question numbers 1 to 15 in Part I are Multiple Choice Questions of one mark each.
   These are to be answered by choosing the most suitable answer from the given four alternatives and writing the option code and the corresponding answer
5. Question numbers 16 to 24 in Part II are two-mark questions. These are to be answered in about one or two sentences.
6. Question numbers 25 to 33 in Part III are three-mark questions. These are to be answered in about three to five short sentences.
7. Question numbers 34 to 38 in Part IV are five-mark questions. These are to be answered in detail Draw diagrams wherever necessary.

Time: 3 Hours
Maximum Marks: 70

PART – 1

Choose the correct answer. Answer all the questions: [15 × 1 = 15]

Question 1.
Which of the following defines what an object can do?
(a) OS
(b) Computer
(c) Interface
(d) Interpreter
Answer:
(c) Interface

Question 2.
Identify the constructor from the following?
(a) City=makecity(name, lat, Ion)
(b) Getname (city)
(c) Getlat (city)
(d) Getlon (city)
Answer:
(a) City=makecity(name, lat, Ion)

Question 3.
Which of the following security technique that regulates who can use resources in a computing environment?
(a) Password
(b) Authentication
(c) Access control
(d) Certification
Answer:
(c) Access control

Question 4.
………………….. is an expression of algorithm in a programming language.
(a) Program
(b) Language
(c) Module
(d) Memory
Answer:
(a) Program

Question 5.
In selection sort, there will be ……………. exchange for every pass through the list.
(a) 0
(b) 1
(c) n
(d) n²
Answer:
(b) 1

Question 6.
………….. function is the alternative for bin ( ) function.
(a) Ord ( )
(b) Format ( )
(c) Binary ( )
(d) Bin ( )
Answer:
(b) Format ( )

Question 7.
Which command is used to remove the entire string variable?
(a) Remove
(b) Del
(c) Delete
(d) Strike
Answer:
(b) Del

Question 8.
Functions defined inside a class ………………..
(a) Functions
(b) Module
(c) Methods
(d) Section
Answer:
(c) Methods

Question 9.
In which database systems, transaction management is efficient?
(a) DBMS
(b) RDBMS
(c) ERDMS
(d) DMBS
Answer:
(b) RDBMS

Question 10.
When the command to run a python program is given to interpreter, code at ……………… indentation is executed ………………..
(a) level 0
(b) level 1
(c) level 2
(d) level 3
Answer:
(a) level 0

Question 11.
Which has a native library for sqlite?
(a) C
(b) C++
(c) Java
(d) Python
Answer:
(d) Python

Question 12.
Which table holds the key information about the database tables?
(a) Page
(b) Select
(c) Primary
(d) Master
Answer:
(d) Master

Question 13.
Pick the odd one out
(a) Dashboard
(b) Live graph
(c) Barplot
(d) Histogram
Answer:
(c) Barplot

Question 14.
Which function shows the percentage value in pie chart?
(a) Percent
(b) Percentage
(c) Slice
(d) Autopct
Answer:
(d) Autopct

Question 15.
Which of the following module is provided by Python to do several operations on the CSV files?
(a) Py
(b) Xls
(c) Csv
(d) Os
Answer:
(d) Os

PART – II

Answer any six questions. Question No. 21 is compulsory. [6 × 2 = 12]

Question 16.
Write note on Grant and Revoke command?
Answer:
Grant: Grants permission to one or more users to perform specific tasks.
Revoke: Withdraws the access permission given by the GRANT statement.

Question 17.
Name some clauses in SQL?
Answer:

1. DISTINCT
2. WHERE
3. GROUP BY
4. ORDER BY
5. HAVING

Question 18.
Define subroutine?
Answer:
Subroutines are the basic building blocks of computer programs. Subroutines are small sections of code that are used to perform a particular task that can be used repeatedly. In Programming languages these subroutines are called as Functions.

Question 19.
Write note on modules?
Answer:
A module is a part of a program. Programs are composed of one or more independently developed modules. A single module can contain one or several statements closely related each other. Modules work perfectly on individual level and can be integrated with other modules.

Question 20.
Write note on Exponent data?
Answer:
An Exponent data contains decimal digit part, decimal point, exponent part followed by one or more digits.

Question 21.
Write a program to check if year is leap or not?
Answer:
n=int(input(“Enter any year”1)) if(n % 4 == 0):
print “Leap Year”
else:
print “Not a Leap Year”

Question 22.
Write the syntax of if-else statements?
Answer:
Syntax:
if:
statements-block 1 else:
statements-block 2

Question 23.
Write note on list comprehension?
Answer:
List comprehension is a simplest way of creating sequence of elements that satisfy a certain condition.
Syntax:
List = [expression for variable in range]

Question 24.
What is the purpose of Destructor?
Answer:
Destructor is also a special method gets executed automatically when an object exit from the scope. It is just opposite to constructor. In Python, del ( ) method is used as destructor.

PART – III

Answer any six questions. Question No. 29 is compulsory. [6 × 3 = 18]

Question 25.
What are the two phases in the Analysis of algorithms and performance evaluation?
Answer:
(a) A Priori estimates:
This is a theoretical performance analysis of an algorithm. Efficiency of an algorithm is measured by assuming the external factors.

(b) A Posteriori testing:
This is called performance measurement. In this analysis, actual statistics like running time and required for the algorithm executions are collected.

Question 26.
Write note on Arithmetic operators?
Answer:
An arithmetic operator is a mathematical operator that takes two operands and performs a calculation on them. They are used for simple arithmetic. Most computer languages contain a set of such operators that can be used within equations to perform different types of sequential calculations.

Question 27.
Write note on comments?
Answer:
In Python, comments begin with hash symbol (#). The lines that begins with # are considered as comments and ignored by the Python interpreter. Comments may be single line or no multi-lines. The multiline comments should be enclosed within a set of:-
# as given below.
# It is Single line Comment
# It is multiline comment
which contains more than one line #

Question 28.
Give the flowchart for ‘for loop’ execution?
Answer:

Question 29.
What is the output of the following snippet?
Answer:
i=1
while True:
if i%3 =0:
break
print(i,end=”)
i +=1 Output:
12

Question 30.
Give the syntax for break, continue, pass?
Answer:
Syntax:
break

Syntax:
continue

Syntax:
pass

Question 31.
Fill the Table with appropriate values?

Answer:

Question 32.
Give the 3 different syntax formats for deleting the elements from a list?
Answer:
Syntax:
del List [index of an element]
# to delete a particular element
del List [index from: index to]
# to delete multiple elements del List
# to delete entire list

Question 33.
What is the output of the following program?
Answer:
class Sample:
_num=10
def disp(self):
print(self._num)
S=Sample( )
S.disp( )
print(S._num)
Output:
Error Sample has no attribute S._num
10

PART – IV

Answer all the questions. [5 × 5 = 25]

Question 34(a).
Describe in detail the procedure script mode programming?
Answer:
Basically, a script is a text file containing the Python statements. Python Scripts are reusable code. Once the script is created, it can be executed again and again without retyping. The Scripts are editable.

Creating Scripts in Python:
(I) Choose File —> New File or press Ctrl + N in Python shell window.

(II) An untitled blank script text editor will be displayed on screen

(III) Type the following code in Script editor

a =100
b = 350
c = a + b
print (“The Sum=”, c)

Saving Python Script:

(I) Choose File → Save or Press Ctrl + S

(II) Now, Save as dialog box appears on the screen

(III) In the Save As dialog box, select the location where you want to save your Python code, and type the file name in File Name box. Python files are by default saved with extension .py. Thus, while creating Python scripts using Python Script editor, no need to specify the file extension.

(IV) Finally, click Save button to save your Python script.

Executing Python Script:-
(I) Choose Run → Run Module or Press F5

(II) If your code has any error, it will be shown in red color in the IDLE window, and Python describes the type of error occurred. To correct the errors, go back to Script editor, make corrections, save the file using Ctrl + S or File → Save and execute it again.

(III) For all error free code, the output will appear in the IDLE window of python

[OR]

(b) Explain data types in python?
Answer:
Python Data types:
All data values in Python are objects and each object or value has type. Python has Built-in or Fundamental data types such as Number, String, Boolean, tuples, lists and dictionaries.

Number Data type:
The built-in number objects in Python supports integers, floating point numbers and complex numbers.

Integer Data can be decimal, octal or hexadecimal. Octal integer use O (both upper and lower case) to denote octal digits and hexadecimal integer use OX (both upper and lower case) and L (only upper case) to denote long integer.

Example :

A floating point data is represented by a sequence of decimal digits that includes a decimal point. An Exponent data contains decimal digit part, decimal point, exponent part followed by one or more digits.

Example :

Complex number is made up of two floating point values, one each for the real and imaginary parts.

Boolean Data type:
A Boolean data can have any of the two values: True or False.

Example :
Bool_var1=True
Bool_var2=False

String Data type:
String data can be enclosed with single quote or double quote or triple quote.

Example:
Char_data = ‘A’
String_data= “Computer Science”
Multiline_data= “““String data can be enclosed with single quote or double quote or triple quote.”””

Question 35(a).
Write a program to calculate the sum of numbers from 1 to 100?
Answer:
n = 100 sum = 0
for counter in range( 1 ,n+1):
sum = sum + counter
print(“Sum of 1 until %d: %d” % (n,sum))

Output:
Sum of 1 until 100: 5050

[OR]

(b) Write a program to replace a string with another string without replace ( )?
Answer:
s1 = input(“Enter the-string to be replaced : “)
s2 = input(“Enter the string to replace with “)
s1 = s2
print(“Replaced string is “, si)

Output:
Enter the string to be replaced: Computer
Enter the string to replace with: repcomputer
Replaced string is repcomputer

Question 36(a).
Write a program using class to accept 3 sides of a triangle and print its area?
Answer:
class Tr:
def init (self, a, b, c):
self.a = float(a)
self.b = float(b)
self.c = float(c)
def area(self):
s = (self.a + self.b + self.c)/2
return((s*(s-self.a) * (s-self.b) * (s-self.c) ** 0.5))
a = input(“Enter side 1:”)
b = input(“Enter side2:”)
c = input(“Enter side3:”)
ans=Tr(a,b,c)
print(ans.area())

Output:
Enter side 1 : 3 Enter side 2:4 Enter side 3 : 5

[OR]

(b) Explain different types of DBMS users?
Answer:
(I) Database Administrator:
Database Administrator or DBA is the one who manages the complete database management system. DBA takes care of the security of the DBMS, managing the license keys, managing user accounts and access etc.

(II) Application Programmers or Software Developers:
This user group is involved in developing and designing the parts of DBMS.

(III) End User:
End users are the one who store, retrieve, update and delete data.

(IV) Database designers:
Are responsible for identifying the data to be stored in the database for choosing appropriate structures to represent and store the data.

Question 37 (a).
Explain various components of DBMS?
Answer:
The Database Management System can be divided into five major components as follows:

1. Hardware
2. Software
3. Data
4. Procedures/Methods
5. Database Access Languages

1. Hardware:
The computer, hard disk, I/O channels for data, and any other physical component involved in storage of data

2. Software:
This main component is a program that controls everything. The DBMS software is capable of understanding the Database Access Languages and interprets into database commands for execution.

3. Data:
It is that resource for which DBMS is designed. DBMS creation is to store and utilize data.

4. Procedures/Methods:
They are general instructions to use a database management system such as installation of DBMS, manage databases to take backups, report generation, etc.

5. DataBase Access Languages:
They are the languages used to write commands to access, insert, update and delete data stored in any database.

[OR]

(b) Differentiate IN and NOTIN in SQL using sample commands? IN Keyword?
Answer:
The IN keyword is used to specify a list of values which must be matched with the record values. In other words it is used to compare a column with more than one value. It is similar to an OR condition.

For example :
SELECT Admno, Name, Place FROM Student WHERE Place IN (“Chennai”, “Delhi”);

Adm No	Name	Place
100	Ashish	Chennai
101	Adarsh	Delhi
103	Ayush	Delhi
104	Abinandh	Chennai
105	Revathi	Chennai
107	Hema	Chennai

NOT IN:
The NOT IN keyword displays only those records that do not match in the list.

For example:
SELECT Admno, Name, Place FROM Student WHERE Place NOT IN (“Chennai”, “Delhi”); will display students only from places other than “Chennai” and “Delhi”.

Question 38 (a).
Explain various python file modes?
Answer:

Adm No	Name	Place
102	Akshith	Bangalore
106	Devika	Bangalore

[OR]

(b) Explain getopt ( ) in python?
Answer:
Python getopt module:
The getopt module of Python helps you to parse (split) command-line options and arguments. This module provides two functions to enable command-line argument parsing, getopt.getopt method

This method parses command-line options and parameter list. Following is the syntax for this method
=getopt.getopt( argv, options, {long_options])
Here is the detail of the parameters –

getopt( ) method returns value consisting of two elements. Each of these values are stored separately in two different list (arrays) opts and args .Opts contains list of splitted strings like mode, path and args contains any string if at all not splitted because of wrong path or mode, args will be an empty array if there is no error in splitting strings by getopt( ). For example The Python code which is going to execute the C++ file p4 in command line will have the getopt Q method like the following one. opts, args = getopt.getopt (argv, “i:”,[‘ifile=’])

>>>print(args)
[ ]
Some more command for wrapping C++ code

if _name _==’_main_’;
main(sys.argv[l:])
_name_(A Special variable) in Python

Since there is no main( ) function in Python, when the command to run a Python program is given to the interpreter, the code that is at level 0 indentation is to be executed. However, before doing that, interpreter will define a few special variables. _name_ is one such special variable which by default stores the name of the file.

If the source file is executed as the main program, the interpreter sets the _name_ variable to have a value as ” main ” name is a built-in variable which evaluates to the name of the current module. Thus it can be used to check whether the current script is being run on its own.

For example consider the following
if_name_==’_main_’:
main(sys.argv[1:])
if the command line Python program itself is going to execute first, then _main_ contains the name of that Python program and the Python special variable _name_ also contain the Python program name. If the condition is true it calls the main which is passed with C++ file as argument.

Students can Download Tamil Nadu 12th Computer Science Model Question Paper 5 English Medium Pdf, Tamil Nadu 12th Computer Science Model Question Papers helps you to revise the complete Tamilnadu State Board New Syllabus, helps students complete homework assignments and to score high marks in board exams.

TN State Board 12th Computer Sceince Model Question Paper 5 English Medium

General Instructions:

1. The question paper comprises of four parts.
2. You are to attempt all the parts. An internal choice of questions is provided wherever applicable.
3. All questions of Part I, II, III and IV are to be attempted separately.
4. Question numbers 1 to 15 in Part I are Multiple Choice Questions of one mark each.
   These are to be answered by choosing the most suitable answer from the given four alternatives and writing the option code and the corresponding answer
5. Question numbers 16 to 24 in Part II are two-mark questions. These are to be answered in about one or two sentences.
6. Question numbers 25 to 33 in Part III are three-mark questions. These are to be answered in about three to five short sentences.
7. Question numbers 34 to 38 in Part IV are five-mark questions. These are to be answered in detail Draw diagrams wherever necessary.

Time: 3 Hours
Maximum Marks: 70

PART – 1

Choose the correct answer. Answer all the questions: [15 × 1 = 15]

Question 1.
Joining of two or more strings is called ……………….
(a) Append
(b) Repeating
(c) Concatenation
(d) Strike
Answer:
(c) Concatenation

Question 2.
What is the output of the following snippet?
T=1
while T:
print(True)
break
(a) False
(b) True
(c) 0
(d) No output
Answer:
(d) No output

Question 3.
………………… is an example for dynamic programming approach.
(a) Fibonacci
(b) Prime
(c) Factorial
(d) Odd, Even
Answer:
(a) Fibonacci

Question 4.
Match the following.
1. // – (I) Modulus
2. # – (II) Floor division
3. % – (III) Strings
4. ||| ||| – (IV) Comments
(a) 1-(II), 2-(IV), 3-(I), 4-(III)
(b) 1-(I), 2-(II), 3-(III), 4-(IV)
(c) 1-(IV) 2-(II) 3-(I) 4-(III)
(d) 1-(IV), 2-(I), 3-(III), 4-(II)
Answer:
(a) 1-(II), 2-(IV), 3-(I), 4-(III)

Question 5.
Lamda functions cannot be used in combination with ……………
(a) Filter
(b) Map
(c) Print
(d) Reduce
Answer:
(c) Print

Question 6.
What is stride?
(a) Index value of slide operation
(b) First argument of slice operation
(c) Second argument of slice operation
(d) Third argument of slice operation
Answer:
(d) Third argument of slice operation

Question 7.
function returns the length of the string?
(a) Strlen ( )
(b) Len (str)
(c) Length ( )
(d) Strlength ( )
Answer:
(b) Len (str)

Question 8.
Let setA={3,6,9}, setB={l,3,9}. What will be the result of the following snippet? print(setA|setB)
(a) {3,6,9,1,3,9}
(b) {3,9}
(c) {1}
(d) {1,3,6,9}
Answer:
(d) {1,3,6,9}

Question 9.
Which function is used to delete elements of a list if its index is unknown?
(a) Del
(b) Delete
(c) Remove( )
(d) Back space
Answer:
(c) Remove( )

Question 10.
The first argument of the class method is …………………..
(a) Class
(b) Func
(c) Def
(d) Self
Answer:
(d) Self

Question 11.
The …………………… command is used to insert, delete and update rows into the table.
(a) DCL
(b) DML
(c) DTL
(d) TCL
Answer:
(b) DML

Question 12.
What will be written inside the file test.csv using the following program
import csv
D = [[‘Exam’],[‘Quarterly’],[‘Halfyearly’]]
csv.register_dialect(‘M’,lineterminator = ‘\n’)
with open(‘c:\pyprg\chl3\line2.csv’, ‘w’) as f:
wr = csv.writer(f,dialect=’M’)
wr.writerows(D) f.close( )
(a) Exam Quarterly Halfyearly
(b) Exam Quarterly Halfyearly
(c) EQH
(d) Exam,Quarterly,Halfyearly
Answer:
(d) Exam,Quarterly,Halfyearly

Question 13.
The default mode when you open a file is ……………….
(a) r
(b) w
(c) x
(d) a
Answer:
(a) r

Question 14.
Which operator is used to access the functions of a imported value?
(a) +
(b) *
(c) .
(d) /
Answer:
(c) .

Question 15.
What will be the value assigned to the empty table if it is given Integer primary key?
(a) 0
(b) 1
(c) 2
(d) -1
Answer:
(b) 1

PART – II

Answer any six questions. Question No. 21 is compulsory. [6 × 2 = 12]

Question 16.
List some aggregate functions in SQL?
Answer:

1. COUNT( )
2. SUM( )
3. MIN( )
4. AVG( )
5. MAX( )

Question 17.
How recursive function works?
Answer:

1. Recursive function is called by some external code.
2. If the base condition is met then the program gives meaningful output and exits.
3. Otherwise, function does some required processing and then calls itself to continue recursion.

Question 18.
Write a short about the followings with suitable example?

1. Capitalize( )
2. Swapcase( )

Answer:

Question 19.
What is set in Python?
Answer:
In python, a set is another type of collection data type. A Set is a mutable and an unordered collection of elements without duplicates. That means the elements within a set cannot be repeated. This feature used to include membership testing and eliminating duplicate elements.

Question 20.
Write note on self?
Answer:
The class method must have the first argument named as self. No need to pass a value for this argument when we Call the method. Python provides its value automatically.

Even if a method takes no arguments, it should be defined with the first argument called self. If a method is defined to accept only one argument it will take it as two arguments i.e. self and the defined argument.

Question 21.
Differentiate data from Information.
Answer:

Question 22.
What does data manipulation means?
Answer:
By Data Manipulation we mean:

1. Insertion of new information into the database
2. Retrieval of information stored in a database.
3. Deletion of information from the database.
4. Modification of data stored in the database.

Question 23.
How will you sort more than one column from a csv file? Give an example statement?
Answer:
To sort by more than one column you can use itemgetter with multiple indices: operator 1
itemgetter (1,2).
#using operator module for sorting multiple columns
sortedlist =sorted (data, key=operator.itemgetter(l))

Question 24.
What are the different formats to create csv files?
Answer:

1. CSV file – data with default delimiter comma (,)
2. CSV file – data with Space at the beginning
3. CSV file – data with quotes
4. CSV file – data with custom Delimiters

PART – III

Answer any six questions. Question No. 29 is compulsory. [6 × 3 = 18]

Question 25.
Why access control is required?
Answer:

• Access control is a security technique that regulates who or what can view or use resources in a computing environment.
• It is a fundamental concept in security that minimizes risk to the object. In other words access control is a selective restriction of access to data.
• In Object oriented programming languages it is implemented through access modifies.
• Classical object-oriented languages, such as C++ and Java, control the access to class members by public, private and protected keywords.

Question 26.
How will you execute python script?
Answer:

1. If your code has any error, it will be shown in red color in the IDLE window, and Python describes the type of error occurred. To correct the errors, go back to Script editor, make corrections, save the file using Ctrl + S or File → Save and execute it again.
2. For all error free code, the output will appear in the IDLE window of Python.

Question 27.
Differentiate ceil( ) and floor( ) function?
Answer:

Question 28.
Give any 6 formatting characters with their usage?
Answer:

Question 29.
How will you access the list elements in reverse order?
Answer:

Question 30.
What are the advantages of Tuples over a list?
Answer:

1. The elements of a list are changeable (mutable) whereas the elements of a tuple are unchangeable (immutable), this is the key difference between tuples and list.
2. The elements of a list are enclosed within square brackets. But, the elements of a tuple are enclosed by paranthesis.
3. Iterating tuples is faster than list.

Question 31.
How will you create a set in python?
Answer:
A set is created by placing all the elements separated by comma within a pair of curly brackets.
The set( ) function can also used to create sets in Python.
Syntax:
Set_Variable = {E1, E2, E3 ……… En}
Example
>>> S1={ 1, 2, 3, ‘A’, 3.14}
>>>print(S1)
{1, 2, 3, 3.14, ‘A’}
>>> S2={1, 2,2, ‘A’, 3.14}
>>> print(S2)
{1, 2, ‘A’, 3.14}

Question 32.
Write a program that creates a list of numbers from 1 to 20 that are divisible by 4? Program to create a list of numbers from 1 to 20 that are divisible by 4?
Answer:
divBy4=[ ]
for i in range(21):
if (i%4= =0):
divBy4.append(i)
print(divBy4)

Output:
[0, 4, 8, 12, 16, 20]

Question 33.
Write the output for the program?
Answer:
class Sample:
def_init_(self, num):
print(“Constructor of class Sample…”)
self.num=num
print(“The value is num)
S=Sample(10)
Constructor of class sample…
The value is: 10

PART – IV

Answer all the questions. [5 × 5 = 25]

Question 34(a).
Explain the concept of Dynamic programming with suitable example?
Answer:
Dynamic programming:
Dynamic programming is an algorithmic design method that can be used when the solution to a problem can be viewed as the result of a sequence of decisions.

Dynamic programming approach is similar to divide and conquer. The given problem is divided into smaller and yet smaller possible sub-problems.

Dynamic programming is used whenever problems can be divided into similar sub-problems. So that their results can be re-used to complete the process.

Dynamic programming approaches are used to find the solution in optimized way. For every inner sub problem, dynamic algorithm will try to check the results of the previously solved sub-problems. The solutions of overlapped sub-problems are combined in order to get the better solution.

Steps to do Dynamic programming

• The given problem will be divided into smaller overlapping sub-problems.
• An optimum solution for the given problem can be achieved by using result of smaller sub-problem.
• Dynamic algorithms uses Memoization.

Fibonacci Series – An example:
Fibonacci series generates the subsequent number by adding two previous numbers. Fibonacci series starts from two numbers – Fib 0 & Fib 1. The initial values of fibO & fibl can be taken as 0 and 1.
Fibonacci series satisfies the following conditions:
Fibn = Fib_n-1 + Fib_n-2

Hence, a Fibonacci series for the n value 8 can look like this
Fib8 = 0 1 1 2 3 5 8 13

Fibonacci Iterative Algorithm with Dynamic programming approach

The following example shows a simple Dynamic programming approach for the generation of Fibonacci series.
Initialize f0 = 0, f1 =1

step-1: Print the initial values of Fibonacci f0 and f1
step-2: Calculate fibonacci fib ← f0 + f1
step-3: Assign f0 ← f1, f1 ← fib
step-4: Print the next consecutive value of fibanocci fib
step-5: Goto step-2 and repeat until the specified number of terms generated.

For example if we generate fibanocci series up to 10 digits, the algorithm will generate the series as shown below:
The Fibonacci series is : 0 1 1 2 3 5 8 13 21 34 55

[OR]

(b) List out the set operations supported by python?
Answer:
(I) Union:
It includes all elements from two or more sets.
In python, the operator | is used to union of two sets. The function union( ) is also used to join two sets in python.

Example: Program to Join (Union) two sets using union operator
set_A={2,4,6,8}
set_B={‘A’, ‘B’, ’C, ’D’}
U_set=set_A|set_B
print(U_set)
Output:
{2, 4, 6, 8, ‘A’, ‘D’, ‘C’, ‘B’}

(II) Intersection:
It includes the common elements in two sets
The operator & is used to intersect two sets in python. The function intersection ( ) is also used to intersect two sets in python.
Example: Program to insect two sets using intersection operator
set_A={‘A’, 2, 4, ‘D’}
set_B={‘A’, ‘B’, ‘C’, ‘D’}
print(set_A & set_B)
Output:
{A’, ‘D’}

(III) Difference:
It includes all elements that are in first set (say set A) but not in the second set (say set B)
The minus (-) operator is used to difference set operation in python.
The function difference() is also used to difference operation.
Example: Program to difference of two sets using minus operator
set_A={A’, 2, 4, ‘D’}
set_B={‘A’, ‘B’, ‘C’, ‘D’}
print(set_A – set_B)
Output:
{2,4}

(IV) Symmetric difference:
It includes all the elements that are in two sets (say sets A and B) but not the one that are common to two sets.
The caret (^) operator is used to symmetric difference set operation in python. The function symmetric_difference( ) is also used to do the same operation.
Example: Program to symmetric difference of two sets using caret operator
set_A={‘A’, 2, 4, ‘D’}
set_B={‘A’, ‘B’, ‘C’, ‘D’}
print(set_A ^ set_B)
Output:
(2, 4, ’B’, ‘C’}

Question 35(a).
Write a python program using list to read marks of six subjects and to print the marks scored in each subject and show the total marks?
Answer:
marks=[ ]
subjects=[‘Tamil’, ‘English’, ‘Physics’, ‘Chemistry’, ‘Comp. Science’, ’Maths’]
for i in range(6):
m=int(input(“Enter Mark = “))
marks.append(m)
for j in range(len(marks)):
print(“{ }. { } Mark= { } “.format(j1+,subjects[j],marks[j]))
print(“Total Marks = “, sum(marks))

Output
Enter Mark = 45
Enter Mark = 98
Enter Mark = 76
Enter Mark = 28
Enter Mark = 46
Enter Mark = 15

1. Tamil Mark = 45
2. English Mark = 98
3. Physics Mark = 76
4. Chemistry Mark = 28
5. Comp. Science Mark = 46
6. Maths Mark =15 Total Marks = 308

[OR]

(b) Write a class with two private class variables and print the sum using a method?
Answer:
class Sample:
def_init_(self, n1, n2):
self._n1=n1
self._n2=n2
def display(self):
print(“class variable 1:”, self._n1)
print(“class variable 2:”, self._n2)
print(“sum self._n1+ self._n2)
s = sample(10, 20)
s.display( )

Output:
class variable 1 : 10
class variable 2 : 20
sum : 30

Question 36 (a).
Explain the characteristics of DBMS?
Answer:
Characteristics of Database Management System?

[OR]

(b) Write any three DDL commands?
Answer:
(a) CREATE TABLE Command:
You can create a table by using the CREATE TABLE command.
CREATE TABLE Student
(Admno integer),
Name char(20), \
Gender char(1),
Age integer,
Place char(10),
);

(b) ALTER COMMAND:
The ALTER command is used to alter the table structure like adding a column, renaming the existing column, change the data type of any column or size of the column or delete the column from the table. Alter table Student add address char;

(c) DROP TABLE:
Drop table command is used to remove a table from the database.
DROP TABLE Student;

Question 37 (a).
What are the functions performed by DDL?
Answer:

1. It should identify the type of data division such as data item, segment, record and database file.
2. It gives a unique name to each data item type, record type, file type and data base.
3. It should specify the proper data type.
4. It should define the size of the data item.
5. It may define the range of values that a data item may use.
6. It may specify privacy locks for preventing unauthorized data entry.

[OR]

(b) Write the different methods to read a File in Python? Read a CSV File Using Python?
Answer:
There are two ways to read a CSV file.

1. Use the csv module’s reader function
2. Use the DictReader class.

(I) CSV Module’s Reader Function:
You can read the contents of CSV file with the help of csv.reader( ) method. The reader function is designed to take each line of the file and make a list of all columns. Then, you just choose the column you want the variable data for. Using this method one can read data from csv files of different formats like quotes (” “),pipe (|) and comma(,).

The syntax for csv.reader( ) is
csv. readert(fileobject, delimiter,fmtparams)

where:-
File object:- passes the path and the mode of the file
Delimiter:- An optional parameter containing the standard dilects like, I etc can be omitted.
Fmtparams:- Optional parameter which help to override the default values of the dialects like skipinitialspace,quoting etc can be omitted.

(II) Reading CSV File Into A Dictionary:
To read a CSV file into a dictionary can be done by using DictReader class of csv module which works similar to the reader( ) class but creates an object which maps data to a dictionary.

The keys are given by the fieldnames as parameter. DictReader works by reading the first line of the CSV and using each comma separated value in this line as a dictionary key. The columns in each subsequent row then behave like dictionary values and can be accessed with the appropriate key (i.e. fieldname).

If the first row of your CSV does not contain your column names, you can pass a fieldnames parameter into the DictReader’s constructor to assign the dictionary keys manually.

The main difference between the csv.reader( ) and DictReader( ) is in simple terms csv. reader and csv. writer work with list/tuple, while csv.DictReader and csv.DictWriter work with dictionary. csv.DictReader and csv.DictWriter take additional argument fieldnames that are used as dictionary keys.

Question 38 (a).
Write a python program to read a csv file and store it in a list? Read A CSV File And Store It In A List?
Answer:
In this topic you are going to read a CSV file and the contents of the file will be stored as a list. The syntax for storing in the List is
list = [ ]                           # Start as the empty list
list.append(element)      # Use append( ) to add elements
For example all the row values of “sample.csv” file is stored in a list using the following
program
import csv
# other way of declaring the filename
inFile= ‘c:\ \pyprg\\sample.csv’
F=open(inFile,’r’)
reader= csv.reader(F)
# declaring array array Value = [ ]
# displaying the content of the list for row in reader:
array Value.append(row)
print(row)
F.close( )

[OR]

(b) Explain OR, AND and NOT operator in SQL?
Answer:
The WHERE clause can be combined with AND, OR, and NOT operators. The AND and OR operators are used to filter records based on more than one condition. In this example you
are going to display the details of students who have scored other than ‘A’. or ‘B’ from the “student table”

Example for WHERE WITH NOT Operator
import sqlite3
connection= sqlite3 ,connect(” Academy.db”)
cursor = connection.cursor( )
cursor.execute(“SELECT *FROM student where grade< >’A’ and Grade< >’B'”)
result = cursor. fetchall( )
print(*result,sep=”\n”)

OUTPUT
(3, ’BASKAR’, ‘C, ‘M’, 75.2, ‘1998-05-17’)
(7, ‘TARUN’, ’D’, ‘M’, 62.3, ‘1999-02-01’)

Example for WHERE WITH AND Operator:-
In this example we are going to display the name, Rollno and Average of students who have scored an average between 80 to 90% (both limits are inclusive) import sqlite3
connection = sqlite3.connect(” Academy.db”)
cursor = connection.cursor( )
cursor.execute(“SELECT Rollno, Same, Average FROM student WHERE (Average>=80 AND Average<=90)”)
result = cursor. fetchall( )
print(*result,sep=”\n”)

OUTPUT
(1, ’Akshay’, 87.8)
(5, ’VARUN’, 80.6)

Example for WHERE WITH OR Operator:-
In this example we are going to display the name and Rollno of students who have not scored an average between 60 to 70% import sqlite3
connection = sqlite3.connect(” Academy.db”)
cursor = connection.cursor( )
cursor.execute(“SELECT Rollno,sname FROM student WHERE (Average<60 OR
Average> 70)”)
result = cursor. fetchall( )
print(*result,sep=”\n”)

OUTPUT
(1, ‘Akshay’)
(2, ‘Aravind’)
(3, ‘BASKAR’)
(4, ‘SAJINI’)
(5, ‘VARUN’)
(6, ‘PRIYA’)

Students can Download Tamil Nadu 12th Computer Science Model Question Paper 1 English Medium Pdf, Tamil Nadu 12th Computer Science Model Question Papers helps you to revise the complete Tamilnadu State Board New Syllabus, helps students complete homework assignments and to score high marks in board exams.

TN State Board 12th Computer Sceince Model Question Paper 1 English Medium

General Instructions:

1. The question paper comprises of four parts.
2. You are to attempt all the parts. An internal choice of questions is provided wherever applicable.
3. All questions of Part I, II, III and IV are to be attempted separately.
4. Question numbers 1 to 15 in Part I are Multiple Choice Questions of one mark each.
   These are to be answered by choosing the most suitable answer from the given four alternatives and writing the option code and the corresponding answer
5. Question numbers 16 to 24 in Part II are two-mark questions. These are to be answered in about one or two sentences.
6. Question numbers 25 to 33 in Part III are three-mark questions. These are to be answered in about three to five short sentences.
7. Question numbers 34 to 38 in Part IV are five-mark questions. These are to be answered in detail Draw diagrams wherever necessary.

Time: 3 Hours
Maximum Marks: 70

PART – 1

Choose the correct answer. Answer all the questions: [15 × 1 = 15]

Question 1.
The duration for which a variable is alive is ………………..
(a) Scale
(b) Life time
(c) Static
(d) Function
Answer:
(b) Life time

Question 2.
………………. describes the lower bound of an algorithm.
(a) Big Ω
(b) Big Θ
(c) Big O
(d) Big ⊗
Answer:
(a) Big Ω

Question 3.
How many types of operators are there?
(a) 2
(b) 3
(c) 4
(d) 5
Answer:
(d) 5

Question 4.
The keys in python, dictionary is specified by ……………..
(a) =
(b) ;
(c) +
(d) :
Answer:
(d) :

Question 5.
…………….. is used to access an element in a list.
(a) Element
(b) i
(c) Index
(d) Tuple
Answer:
(c) Index

Question 6.
The command to delete a table is ………………..
(a) Drop
(b) Delete
(c) Delete all
(d) Alter table
Answer:
(a) Drop

Question 7.
‘skipinitialspace’ is used for removing ……………….. after delimiter.
(a) White spaces
(b) Double quotes
(c) Comma
(d) Colon
Answer:
(a) White spaces

Question 8.
List literals are written using ………………
(a) [ ]
(b) ( )
(c) { }
(d) <>
Answer:
(a) [ ]

Question 9.
What does ……………… name ………………. contains?
(a) C++ file name
(b) Main ( ) name
(c) Python file name
(d) OS module name
Answer:
(c) Python file name

Question 10.
Which of the following clause avoid the duplicates?
(a) Distinct
(b) Remove
(c) Where
(d) Group by
Answer:
(a) Distinct

Question 11.
Which function returns the smallest value of the selected columns?
(a) Min ( )
(b) Minimum ( )
(c) Small ( )
(d) Least ( )
Answer:
(a) Min ( )

Question 12.
Which is a python package used for 2D graphics?
(a) Matplotlib.pyplot
(b) Matplotlib.pip
(c) Matplotlib.numpy
(d) Matplotlib.plt
Answer:
(a) Matplotlib.pyplot

Question 13.
Skipping of first row heading in CSV file is given by ………………
(a) Skip
(b) Next
(c) Forward
(d) More
Answer:
(b) Next

Question 14.
Which mode is used when dealing with non-text files like images or exe files?
(a) Text
(b) Word
(c) Binary
(d) Exe
Answer:
(c) Binary

Question 15.
In python _ del _ ( ) method is used as …………….
(a) Delete
(b) Drop
(c) Truncate
(d) Destructor
Answer:
(d) Destructor

PART – II

Answer any six questions. Question No. 21 is compulsory. [6 × 2 = 12]

Question 16.
Who is an Algorist?
Answer:

1. A person skilled in the design of algorithms are called as Algorist.
2. An algorithmic artist.

Question 17.
What is a repeating operator?
Answer:
The multiplication operator (*) is used to display a string in multiple number of times.

Question 18.
Write note on dictionary comprehensions?
Answer:
In Python, comprehension is another way of creating dictionary. The following is the syntax of creating such dictionary.
Syntax
Dict = { expression for variable in sequence [if condition] }

Question 19.
What is the output of the following snippet?
T=1
while T:
print(True)
break
(a) False
(b) True
(c) 0
(d) No output
Answer:
(d) No output

Question 20.
List the control structures in python?
Answer:
There are three important control structures

1. Sequential
2. Alternative or Branching
3. Iterative or Looping

Question 21.
Pick the correct one to execute the given statement successfully, if_: print(x, ” is a leap year”)
(a) x % 2 = 0
(b) x % 4 = = 0
(c) x/4 = 0
(d) x % 4 = 0
Answer:
(b) x % 4 = = 0

Question 22.
What are the 4 types of function arguments?
Answer:

1. Required arguments
2. Keyword arguments
3. Default arguments
4. Variable-length arguments

Question 23.
Find output:
C = 65
Print (chr (C))
Answer:
Output:
A

Question 24.
Give the positive and negative index for list [10, 23, 41]
Answer:
Positive: 0 1 2
Negative: -3 -2 -1

PART – III

Answer any six questions. Question No. 29 is compulsory. [6 × 3 = 18]

Question 25.
Write a python program to check smallest of 3 numbers?
Answer:
num1 = int (input(“Enter first number : “))
num2 = int (input(“Enter second number : “))
num3 = int (input(“Enter third number : “))
if (num1 < num2) and (num1 < num3):
smallest=num1
elif (num2 < num1) and (num2 < num3):
smallest=num2
else:
smallest=num3
print(” The smallest number is”, smallest)

Output:
Enter first number : 12
Enter second number : 7
Enter third number : 15
The smallest number is 7

Question 26.
Write a note on count ( ) function?
Answer:

Question 27.
What are the advantages of user – defined functions?
Answer:

1. Functions help us to divide a program into modules. This makes the code easier to manage.
2. It implements code reuse. Every time you need to execute a sequence of statements, all you need to do is to call the function.
3. Functions, allows us to change functionality easily, and different programmers can work on different functions.

Question 28.
Write note on min ( ), max ( ), sum ( ) functions?
Answer:

Question 29.
What is the use of append ( ) and extend ( ) functions in python?
Answer:
In Python, append() function is used to add a single element and extend() function is used to add more than one element to an existing list.

Syntax:
List.append (element to be added)
List.extend ([elements to be added])

Question 30.
Define Nested list, give example for it?
Answer:
In the below example, Mylist contains another list as an element. This type of list is known as “Nested List”.
Nested list is a list containing another list as an element.
Example: Mylist = [ “Welcome”, 3.14, 10, [2, 4, 6] ]

Question 31.
Define list. How will you represent rational numbers with list?
Answer:
List is constructed by placing expressions within square brackets separated by commas. Such an expression is called a list literal. List can store multiple values. Each value can be of any type and can even be another list. Example for List is [10, 20].

Representing Rational Numbers Using List:
You can now represent a rational number as a pair of two integers in pseudo code: a numerator and a denominator
rational(n, d):
return [n, d]
numer(x):
return x[0]
denom(x):
return x[l]

Question 32.
Define memoization?
Answer:
Memoization or memoisation is an optimization technique used primarily to speed up computer programs by storing the results of expensive function calls and returning the cached result when the same inputs occur again.

Question 33.
Mention any 6 keywords?
Answer:

1. False
2. None
3. True
4. And
5. As
6. Assert

PART – IV

Answer all the following questions. [5 × 5 = 25]

Question 34 (a).
Explain the pseudo code to do Binary search?
Answer:
(I) Start with the middle element:

• If the search element is equal to the middle element of the array i.e., the middle value = number of elements in array/2, then return the index of the middle element.
• If not, then compare the middle element with the search value.
• If the search element is greater than the number in the middle index, then select the elements to the right side of the middle index, and go to Step-1.
• If the search element is less than the number in the middle index, then select the elements to the left side of the middle index, and start with Step-1.

(II) When a match is found, display success message with the index of the element matched.

(III) If no match is found for all comparisons, then display unsuccessful message.

[OR]

(b) Give the pseudo code for insertion sort?
Answer:
Step 1 – If it is the first element, it is already sorted.
Step 2 – Pick next element.
Step 3 – Compare with all elements in the sorted sub-list.
Step 4 – Shift all the elements in the sorted sub-list that is greater than the value to be sorted
Step 5 – Insert the value
Step 6 – Repeat until list is sorted

Question 35 (a).
Explain input function with example?
input( ) function:
Answer:
In Python, input( ) function is used to accept data as input at run time. The syntax for input( ) function is,
Variable = input (“prompt string ’’)

Where, prompt string in the syntax is a statement or message to the user, to know what input can be given. If a prompt string is used, it is displayed on the monitor; the user can provide expected data from the input device. The input( ) takes whatever is typed from the keyboard and stores the entered data in the given variable. If prompt string is not given in input( ) no message is displayed on the screen, thus, the user will not know what is to be typed as input.

Example: input( ) with prompt string
>>> city=input (“Enter Your City: ”)
Enter Your City: Madurai
>>> print (“I am from”, city)
I am from Madurai

Example: input( ) without prompt string
>>> city=input( )
Rajarajan
>>> print (“I am from”, city)
I am from Rajarajan

Note that in example-2, the input( ) is not having any prompt string, thus the user will not know what is to be typed as input. If the user inputs irrelevant data as given in the above example, then the output will be unexpected. So, to make your program more interactive, provide prompt string with input( ).

The input ( ) accepts all data as string or characters but not as numbers. If a numerical value is entered, the input values should be explicitly converted into numeric data type.

The int ( ) function is used to convert string data as integer data explicitly. We will learn about more such functions in later chapters.

Example:
x = int (input(“Enter Number 1: ”))
y = int (input(“Enter Number 2: ”))
print (“The sum = ”, x+y)
Output:
Enter Number 1 : 34
Enter Number 2 : 56
The sum = 90

Example: Alternate method for the above program
x,y=int (input(“Enter Number 1 :”)),int(input(“Enter Number 2:”))
print (“X = “,x,” Y = “,y)
Output:
Enter Number 1:30
Enter Number 2:50
X = 30 Y = 50

[OR]

(b) Explain various types of Relationships in dBMS?
Answer:
Following are the types of relationships used in a database.

1. One-to-One Relationship
2. One-to-Many Relationship
3. Many-to-One Relationship
4. Many-to-Many Relationship

1. One-to-One Relationship
In One-to-One Relationship, one entity is related with only one other entity. One row in a table is linked with only one row in another table and vice versa.
For example: A student can have only one exam number

2. One-to-Many Relationship
In One-to-Many relationship, one entity is related to many other entities.
One row in a table A is linked to many rows in a table B, but one row in a table B is linked to only one row in table A.
For example: One Department has many staff members.

3. Many-to-One Relationship
In Many-to-One Relationship, many entities can be related with only one in the other entity. For example: A number of staff members working in one Department.
Multiple rows in staff members table is related with only one row in Department table.

4. Many-to-Many Relationship
A many-to-many relationship occurs when multiple records in a table are associated with multiple records in another table.

Example 1: Customers and Product
Customers can purchase various products and Products can be purchased by many customers.

Example 2: Students and Courses A student can register for many Courses and a Course may include many students.

Example 3: Books and Student.
Many Books in a Library are issued to many students.

Question 36 (a).
Write a menu driven program that keeps record of books available in school library?
Answer:
class Library:
def init (self):
self.bookname=” ”
self.author=””

def getdata(self):
self.bookname = input(“Enter Name of the Book: “)
self.author = input(“Enter Author of the Book: “)

def display(self):
print(“Name of the Book: “,self.bookname)
print(“Author of the Book: “,self.author)
print(“\n”)

book=[ ] #empty list
ch = ‘y’

while(ch==’y’):
print(” 1. Add New Book \n 2.Display Books”)
resp = int(input(“Enter your choice : “))

if(resp==1):
L=Library( )
L.getdata( )
book.append(L)

elif(resp=2):
for x in book:
x.display( )

else:
print(“Invalid input….”)
ch = input(“Do you want continue….”)

Output:

1. Add New Book
2. Display Books Enter your choice : 1

Enter Name of the Book: Programming in C++
Enter Author of the Book: K. Kannan
Do you want continue….y

1. Add New Book
2. Display Books Enter your choice : 1

Enter Name of the Book: Learn Python
Enter Author of the Book: V.G.Ramakrishnan
Do you want continue….y

1. Add New Book
2. Display Books

Enter your choice : 1
Enter Name of the Book: Advanced Python
Enter Author of the Book: Dr. Vidhya
Do you want continue….y

1. Add New Book
2. Display Books

Enter your choice : 1
Enter Name of the Book: Working with OpenOffice
Enter Author of the Book: N.V.Gowrisankar
Do you want continue….y

1. Add New Book
2. Display Books

Enter your choice : 1
Enter Name of the Book: Data Structure
Enter Author of the Book: K.Lenin
Do you want continue….y

1. Add New Book
2. Display Books

Enter your choice : 1
Enter Name of the Book: An Introduction to Database System
Enter Author of the Book: R.Sreenivasan
Do you want continue….y

1. Add New Book
2. Display Books

Enter your choice : 2
Name of the Book: Programming in C++
Author of the Book: K. Kannan
Name of the Book: Learn Python
Author of the Book: V.G.Ramakrishnan
Name of the Book: Advanced Python
Author of the Book: Dr. Vidhya
Name of the Book: Working with OpenOffice
Author of the Book: N.V.Gowrisankar
Name of the Book: Data Structure
Author of the Book: K.Lenin
Name of the Book: An Introduction to Database System
Author of the Book: R.Sreenivasan
Do you want continue….n

[OR]

(b) Write a program to accept a string and print the number of upper case, vowels, consonants and spaces in the giving string?
Answer:
class String:
def _init_(self):
self.uppercase=0
self.lowercase=0
self.vowels=0
self.consonants=0
self.spaces=0
self.string=””

def getstr(self):
self.string=str(input(“Enter a String: “))

def countupper(self):
for ch in self.string:
if (ch.isupper()):
self.uppercase+=1

def count_lower(self):
for ch in self.string:
if (ch.islower()):
self.lowercase+= 1

def count_vowels(self):
for ch in self.string:
if (ch in (‘A’, ‘a’, ‘e’, ‘E’, ‘i’, T, ’o’, ‘O’, T, ‘L’)):
self.vowels+=1

def countconsonants(self):
for ch in self.string:
if (ch not in (‘A’, ’a’, ‘e’, ‘E’, ‘i’, T, ‘o’, ‘O’, T, ’L’)):
self.consonants+= 1

def countspace(self):
for ch in self.string:
if (ch=””):
self.spaces+=1

def execute(self):
self.count_upper( )
self.count_lower( )
self. count_vowels( )
self.count_consonants( )
self.count_space( )

def display(self):
print(“The given string contains…”)
print(“%d Uppercase letters”%self.uppercase)
print(“%d Lowercase letters”%self.lowercase)
print(“%d Vowels”%self. vowels)
print(“%d Consonants”%self.consonants)
print(“%d Spaces”%self.spaces)
S = String( )
S.getstr( )
S.execute( )
S.display( )

Output:
Enter a String: Welcome To Learn Computer Science
The given string contains…
5 Uppercase letters
24 Lowercase letters
13 Vowels
20 Consonants
4 Spaces

Question 37(a).
Explain python getopt module?
Answer:
The getopt module of Python helps you to parse (split) command-line options and arguments. This module provides two functions to enable command-line argument parsing.
getopt.getopt method
This method parses command-line options and parameter list. Following is the syntax for this method –
<opts> ,<args>=getopt.getopt (argv, options, [long options])
Here is the detail of the parameters –

argv – This is the argument list of values to be parsed (splited). In our program the complete command will be passed as a list.
options – This is string of option letters that the Python program recognize as, for input or for output, with options (like ‘i’ or ‘o’) that followed by a colon (:). Here colon is used to denote the mode.

longoptions – This parameter is passed with a list of strings. Argument of Long options should be followed by an equal sign (‘=’). In our program the C++ file name will be passed as string and ‘i’ also will be passed along with to indicate it as the input file.

getopt( ) method returns value consisting of two elements. Each of these values are stored separately in two different list (arrays) opts and args. Opts contains list of splitted strings like mode, path and args contains any string if at all not splitted because of wrong path or mode. args will be an empty array if there is no error in splitting strings by getopt( ).

For example The Python code which is going to execute the C++ file p4 in command line will have the getopt() method like the following one.
opts, args = getopt.getopt (argv, “i:”,[‘ifile=’])

In our examples since the entire command line commands are parsed and no leftover argument, the second argument args will be empty [ ]. If args is displayed using print( ) command it displays the output as [ ].
>>>print(args)
[ ]

[OR]

(b) Write a sql code using where clause to display the different grades scored by male students from student table?
Answer:
The WHERE clause is used to extract only those records that fulfill a specified condition. In this example we are going to display the different grades scored by male students from “student table” import sqlite3
connection = sqlite3.connect(“Academy.db”)
cursor = connection.cursor( )
cursor.execute(” SELECT DISTINCT (Grade) FROM student where gender=’M”‘)
result = cursor.fetchall( )
print(*result,sep=”\n”)
OUTPUT
(‘B’,)
(‘A’,)
(C’,)
(D’,)

Question 38 (a).
Write a program that accept data using python input ( ) command and write it in the Table called person?
Answer:
In this example we are going to accept data using Python input() command during runtime and then going to write in the Table called “Person”

Example:
# code for executing query using input data import sqlite3
# creates a database in RAM
con =sqlite3.connect(” Academy, db”)
cur =con.cursor( )
cur.execute(“DROP Table person”)
cur.execute(“create table person (name, age, id)”)
print(“Enter 5 students names:”)
who =[input( ) for i in range(5)]
print(“Enter their ages respectively:”)
age =[int(input()) for i in range(5)]
print(“Enter their ids respectively:”)
p_id =[int(input())for i in range(5)]
n =len(who)
for i in range(n):
# This is the q-mark style:
cur.execute(“insert into person values (?, ?, ?)”, (who[i], age[i], p_id[i]))
# And this is the named style: cur.execute(“select * from person”)
# Fetches all entries from table
print(“Displaying All the Records From Person Table”)
print (*cur.fetchall( ), sep-\n’)

Output:
Enter 5 students names:
RAM
KEERTHANA
KRISHNA
HARISH
GIRISH

Enter their ages respectively:
28
12
21

Enter their ids respectively:
1
2
3
4
5

Displaying All the Records From Person Table
(‘RAM’, 28, 1)
(’KEERTHANA’, 12, 2)
(’KRISHNA1, 21,3)
(‘HARISH’, 18,4)
(‘GIRISH’, 16, 5)

You can even add records to the already existing table like “Student” Using the above coding with appropriate modification in the Field Name. To do so you should comment the create table statement

[OR]

(b) Write a CSV file with a line terminator?
Answer:
A Line Terminator is a string used to terminate lines produced by writer. The default value is \r or \n. We can write csv file with a line terminator in Python by registering new dialects using csv.register_dialect( ) class of csv module.
For Example
import csv
Data = [[‘Fruit’, ‘Quantity’], [‘Apple’, ‘5’], [‘Banana’, ‘7’], [‘Mango’, ‘8’]]
csv.register_dialect(‘myDialect’, delimiter = ‘|’, lineterminator = ‘\n’)
with open(‘c:\\pyprg\\chl3\\line.csv’, ‘w’) as f:
writer = csv.writer(f, dialect=‘myDialect’)
writer.writerows(Data)
f.close( )
When we open the line.csv file, we get following output with spacing between lines:

In the above code, the new dialect “myDialect uses the delimiter=‘|’ where a | (pipe) is considered as column separator. The line terminator=‘\r\n\r\n’ separates each row and display the data after every two lines.

Students can Download Tamil Nadu 12th Computer Science Model Question Paper 4 English Medium Pdf, Tamil Nadu 12th Computer Science Model Question Papers helps you to revise the complete Tamilnadu State Board New Syllabus, helps students complete homework assignments and to score high marks in board exams.

TN State Board 12th Computer Sceince Model Question Paper 4 English Medium

General Instructions:

1. The question paper comprises of four parts.
2. You are to attempt all the parts. An internal choice of questions is provided wherever applicable.
3. All questions of Part I, II, III and IV are to be attempted separately.
4. Question numbers 1 to 15 in Part I are Multiple Choice Questions of one mark each.
   These are to be answered by choosing the most suitable answer from the given four alternatives and writing the option code and the corresponding answer
5. Question numbers 16 to 24 in Part II are two-mark questions. These are to be answered in about one or two sentences.
6. Question numbers 25 to 33 in Part III are three-mark questions. These are to be answered in about three to five short sentences.
7. Question numbers 34 to 38 in Part IV are five-mark questions. These are to be answered in detail Draw diagrams wherever necessary.

Time: 3 Hours
Maximum Marks: 70

PART – 1

Choose the correct answer. Answer all the questions: [15 × 1 = 15]

Question 1.
Why is the function random( ) is a impure function?
(a) It gives different outputs for same function call
(b) It gives different outputs when 0 is given
(c) It will not give different output
Answer:
(a) It gives different outputs for same function call

Question 2.
The process of subdividing a computer program into separate sub-programs is called ……………….
(a) Procedural Programming
(b) Modular programming
(c) Event Driven Programming
(d) Object oriented Programming
Answer:
(b) Modular programming

Question 3.
If a problem can be broken into subproblems which are reused several times, the problem possesses which property?
(a) Overlapping subproblems
(b) Optimal substructure
(c) Memoization
(d) Greedy
Answer:
(a) Overlapping subproblems

Question 4.
Ox represents ………………. integer.
(a) Binary
(b) Hexadecimal
(c) Decimal
(d) Octal
Answer:
(b) Hexadecimal

Question 5.
Which amongst this is not a Jump Statement?
(a) For
(b) Goto
(c) Continue
(d) Break
Answer:
(a) For

Question 6.
Which is the optional part in range?
(a) Start
(b) Stop
(c) Step
(d) Iner
Answer:
(c) Step

Question 7.
Which function is used to change all occurances of a particular character in a string?
(a) Replace ( )
(b) Change ( )
(c) Edit ( )
(d) Append( )
Answer:
(a) Replace ( )

Question 8.
The default value of stride is …………………
(a) 0
(b) 1
(c) n
(d) n-1
Answer:
(b) 1

Question 9.
The mixed collection of elements are called ………………
(a) List
(b) Tuples
(c) Sets
(d) Dictionary
Answer:
(d) Dictionary

Question 10.
Class members are accessed through ……………. operators
(a) &
(b) .
(c) #
(d) %
Answer:
(b) .

Question 11.
Find the wrong pair.
(a) Union U
(b) Project π
(c) Select σ
(d) Cartesian product P
Answer:
(d) Cartesian product P

Question 12.
The update command specifies the rows to be changed using …………………
(a) Where
(b) Why
(c) What
(d) How
Answer:
(a) Where

Question 13.
In open command, file name can be represented in ………………..
(a) ” ”
(b) ‘ ‘
(c) $
(d) both (a) & (b)
Answer:
(d) both (a) & (b)

Question 14.
Which command of OS module executes the exe files?
(a) Run
(b) System ( )
(c) Main
(d) Name
Answer:
(b) System ( )

Question 15.
The SQL commands have to be defined with ………………… quotes.
(a) Single
(b) Double
(c) Triple
(d) No quote
Answer:
(c) Triple

PART – II

Answer any six questions. Question No. 21 is compulsory. [6 × 2 = 12]

Question 16.
Write the inference you get from X:=78 ?
Answer:
Value 78 being bound to the name X.

Question 17.
Write note on Definitions?
Answer:
Definitions bind values to names, Definitions are not expressions, Definitions are distinct syntactic blocks. Definitions can have expressions nested inside them, and vice-versa.

Question 18.
What is a Pair? Give an example?
Answer:
Pair is a compound structure which is made up of list or Tuple. lst[(0, 10), (1,20)] -where

Any way of bundling two values together into one can be considered as a pair. Lists are a common method to do so. Therefore List can be called as Pairs.

Question 19.
Define fixed part in the space complexity?
Answer:
A fixed part is defined as the total space required to store certain data and variables for an algorithm. For example, simple variables and constants used in an algorithm.

Question 20.
Name the different types of alternative statements in Python?
Answer:
Python provides the following types of alternative or branching statements:

1. Simple if statement
2. if..else statement
3. if.elif statement

Question 21.
Find output:

1. abs (-25 + 12.0)
2. abs (-3.2).

Answer:
Output:

1. 13
2. 3.2

Question 22.
Give the syntax for passing parameters in functions?
Answer:
Parameters or arguments can be passed to functions.
Syntax:
def function_name (parameters) separated by comma):

Question 23.
Differentiate del with remove( ) function of List?
Answer:
There are two ways to delete an element from a list viz. del statement and remove() function, del statement is used to delete known elements whereas remove() function is used to delete elements of a list if its index is unknown. The del statement can also be used to delete entire list.

Question 24.
What is instantiation?
Answer:
Once a class is created, next you should create an object or instance of that class. The process of creating object is called as “Class Instantiation”.
Syntax:
objectname = class_name( )

PART – III

Answer any six questions. Question No. 29 is compulsory. [6 × 3 = 18]

Question 25.
What are class members? How do you define it?
Answer:
In Python, a class is defined by using the keyword class. Every class has a unique name followed by a colon (:).
Syntax:
class class name:
statement_1
statement_2
statement
…….
……
statement_n
Where, statement in a class definition may be a variable declaration, decision control, loop or even a function definition. Variables defined inside a class are called as “Class Variable” and functions are called as “Methods”. Class variable and methods are together known as members of the class. The class members should be accessed through objects or instance of class. A class can be defined anywhere in a Python program.

Example: Program to define a class
class Sample:
x, y = 10, 20 # class variables
In the above code, name of the class is Sample and it has two variables x and y having the initial value 10 and 20 respectively. To access the values defined inside the class, you need an object or instance of the class.

Question 26.
What is meant by data model?
Answer:

• A data model describes how the data can be represented and accessed from a software after complete implementation
• It is a simple abstraction of complex real world data gathering environment.
• The main purpose of data model is to give an idea as how the final system or software will look like after development is completed.

Question 27.
Write the use of Savepoint command with an example?
Answer:
SAVEPOINT command:
The SAVEPOINT command is used to temporarily save a transaction so that you can rollback to the point whenever required. The different states of our table can be saved at anytime using different names and the rollback to that state can be done using the ROLLBACK command.
SAVEPOINT savepoint_name;
UPDATE Student SET Name = ‘Mini ’ WHERE Admno=105;
SAVEPOINT A;

Question 28.
Write a program to count the number of male and female students from the student table?
Example:
Answer:
import sqlite3
connection= sqlite3.connect(“Academy.db”)
cursor = connection. cursor( )
cursor. execute(” SELECT gender,count(gender) FROM student Group BY gender”)
result = cursor. fetchall( )
print(*result,sep=”\n”)

Output:
(‘F’, 2)
(‘M’, 5)

Question 29.
What will be the output of the given python program?
Answer:
str1 = “welcome”
str2 = “to school”
str3 = str 1 [: 2]+str2 [len(str2)-2:]
print(str3)

Output:
weool

Question 30.
Write any 6 delimiters in python?
Answer:

Question 31.
What are string literals? Explain?
Answer:
In Python a string literal is a sequence of characters surrounded by quotes. Python supports single, double and triple quotes for a string. A character literal is a single character surrounded by single or double quotes. The value with triple-quote is used to give multi-line string literal.

strings = “This is Python”
char = “C”
multilinestr = ‘”This is a multiline string with more than one line code.'”

Question 32.
Give an example program for Ternary operator?
Answer:
# Program to demonstrate conditional operator
a, b = 30, 20
# Copy value of a in min if a < b else copy b
min = a if a < b else b
print (“The Minimum of A and B is “,min)
# End of the Program

Output:
The Minimum of A and B is 20

Question 33.
Write a note about count( ) function in python?
Answer:

PART – IV

Answer all the questions. [5 × 5 = 25]

Question 34(a).
Write the Output for the given program?
Answer:

[OR]

(b) Write a python program to check whether the given number is odd or even?
Example: #Program to check if the accepted number odd or even?
Answer:
a = int(input(“Enter any number :”))
if a%2==0:
print (a, ” is an even number”)
else:
print (a, ” is an odd number”)

Output 1:
Enter any number :56 56 is an even number

Output 2:
Enter any number :67 67 is an odd number

Question 35(a).
Explain while loop with sample program?
Answer:
Syntax:
while <condition>:
statements block 1
[else:
statements block 2]

In the while loop, the condition is any valid Boolean expression returning True or False. The else part of while is optional part of while. The statements blockl is kept executed till the condition is True. If the else part is written, it is executed when the condition is tested False. Recall while loop belongs to entry check loop type, that is it is not executed even once if the condition is tested False in the beginning.

Example: program to illustrate the use of while loop – to print all numbers from 10 to 15

Output:
10 11 12 13 14 15

[OR]

(b) Explain the following built-in functions?
Answer:

Question 36 (a).
Evaluate the following function and write the output?

1. forinat(66, ‘c’)
2. format(10, ‘x’)
3. format(10, ‘X’)
4. format(0bll0, ‘d’)
5. format(0xa, ‘d’)

Answer:

1. B
2. a
3. A
4. 6
5. 10

[OR]

(b) Write a program to swap two strings?
Answer:
print(“Enter ‘x’ for exit.”)
string 1 = input(“Enter first string : “)
if string 1 = = ‘x’: exit));
else:
string2 = input(“Enter second string : “)
print(” \n Both strings before swap : “)
print(“First string = ” , string1)
print(” Second string = ” , string2)
temp = string1 string1 = string2
string2 = temp
print(“\n Both strings after swap : “)
print(“First string = ” , string1)
print(” Second string = “, string2)

Output:
Enter ‘X’ for exit
Enter first string : code
Enter second string : python
Both strings before swap:
First string = code Second string = python Both strings after swap:
First string = python Second string = code

Question 37 (a).
Write a program to create a list of numbers in the range 1 to 20. Then delete all the numbers from the list that are divisible by 3?
Answer:
num = [ ]
for x in range(1, 21):
num.append(x)
print(“The list of numbers from 1 to 20 =”, num) for index, i in enumerate(num):
if(i % 3 == 0)
del num[index]
print(“The list after deleting numbers”, num)

Output:
The list of numbers from 1 to 20 = [1,2,3,4… 20]
The list after deleting numbers[l, 2, 4, 5, 7, 8, 10, 11, 13, 14, 16, 17, 19, 20]

[OR]

(b) Write a program using class to store name and marks of students in list and print total marks?
Answer:
class stud:
def_init_(self):
self.name=” ”
self.m1=0
self.m2=0
self.tot=0
def gdata(self):
self.name = input(“Enter your name”)
self.m1 = int(input(“Enter marks 1”))
self.m2 = int(input(“Enter marks2”))
self, tot = self.m1 + self.m2
def disp(self):
print(self.name)
print(self.m1)
print(self.m2)
print(self.tot)
mlist = [ ]
st = stud( )
st.gdata( )
mlist.append(st)
for x in mlist:
x.disp( )

Output:

Question 38.
Write the different types of constraints and their functions?
Answer:
Constraints ensure database integrity, therefore known as database integrity constraints.

(I) Unique Constraint:
This constraint ensures that no two rows have the same value in the specified columns. For example UNIQUE constraint applied on Admno of student table ensures that no two students have the same admission number and the constraint can be used as:

CREATE TABLE Student
(
Admno integer NOT NULL UNIQUE → Unique constraint
Name char (20) NOT NULL,
Gender char (1),
Age integer,
Place char (10),
);

The UNIQUE constraint can be applied only to fields that have also been declared as NOT NULL.

When two constraints are applied on a single field, it is known as multiple constraints. In the above Multiple constraints NOT NULL and UNIQUE are applied on a single field Admno, the constraints are separated by a space and at the end of the field definition a comma(,) is added. By adding these two constraints the field Admno must take some value i.e. will not be NULL and should not be duplicated.

(II) Primary Key Constraint:
This constraint declares a field as a Primary key which helps to uniquely identify a record. It is similar to unique constraint except that only one field of a table can be set as primary key. The primary key does not allow NULL values and therefore a field declared as primary key must have the NOT NULL constraint.
Example showing Primary Key Constraint in the student table:
CREATE TABLE Student
(
Admno integer NOT NULL PRIMARY KEY, → Primary Key constraint
Name char(20)NOT NULL,
Gender char(I),
Age integer,
Place char(10),
);

In the above example the Admno field has been set as primary key and therefore will help us to uniquely identify a record, it is also set NOT NULL, therefore this field value cannot be empty,

(III) DEFAULT Constraint:
The DEFA ULT constraint is used to assign a default value for the field. When no value is given for the specified field having DEFA ULT constraint, automatically the default value will be assigned to the field.
Example showing DEFAULT Constraint in the student table:
CREATE TABLE Student
(
Admno integer NOT NULL PRIMARY KEY,
Name char(20) NOT NULL,
Gender char(1),
Age integer DEFAULT = “17”, → Default Constraint Place char(10),
); –
In the above example the “Age” field is assigned a default value of 17, therefore when no
value is entered in age by the user, it automatically assigns 17 to Age.

(IV) Check Constraint:
This constraint helps to set a limit value placed for a field. When we define a check constraint on a single column, it allows only the restricted values on that field.
Example showing check constraint in the student table:
CREATE TABLE Student
(
Admno integer NOT NULL PRIMARY KEY
Name char(20)NOT NULL,
Gender char(1),
Age integer (CHECK<=19), → Check Constraint Place char(10),
);
In the above example the check constraint is set to Age field where the value of Age must be less than or equal to 19.

Note:
The check constraint may use relational and logical operators for condition.

(V) TABLE CONSTRAINT:
When the constraint is applied to a group of fields of the table, it is known as Table constraint. The table constraint is normally given at the end of the table definition. Let us take a new table namely Student 1 with the following fields Admno, Firstname, Lastname, Gender, Age, Place:

CREATE TABLE Student 1
(
Admno integer NOT NULL,
Firstname char(20),
Lastname char(20),
Gender char(1),
Age integer,
Place char(10),
PRIMARY KEY (Firstname, Lastname) → Table constraint
);
In the above example, the two fields, Firstname and Lastname are defined as Primary key which is a Table constraint.

[OR]

(b) Write a C++ program to print boundary elements of a matrix and name the file as Border.cpp. Write a python program to execute the Border.cpp?
Answer:
Select File → New in Notepad and type the C++ program.
#include<iostream>
#include<bits/stdc++.h>
using namespace std;
const int MAX = 100;
void printBoundary(int a[ ][max], int m, int n)
{
for (int i=0; i < m; i++)
{
for(int j=0; j < n; j++)
{
if(i= =0 || j= =0 || i= =n-l || j= =n-1)
cout<<a[i][j] <<” ”
else
cout« ” ”
cout« ” ”
}
cout<<” \n”;
}}
int main( )
{
inta[4][MAX] = { {1 ,2, 3, 4}, {5, 6, 7, 8}, {1, 2, 3, 4}, {5, 6, 7, 8}};
print Boundary(a, 4, 4);
return 0;
}
save it as Border.cpp
open a New notepad file and type the python program to execute border.cpp
#python border.py -i border.cpp
import sys,os,getopt
def main(argv):
cppfile =” exe_file =”
opts, args = getopt.getopt(argv, “i:”,[‘ifile=’])
for o, a in opts: if o in(“-i”, “-ifile”):
cppfile =a+ ‘.cpp’
exefile = a+ ‘.exe’
run(cpp file, exe file)
def run(cpp_file, exe file):
print(“Compiling” + cppfile) os.system(‘g++’+ cpp file + ‘-o ‘+ exe file)
print(“Running” + exefile)
print(” “)
print
os.system(exe_file)
print
if name =’ main ‘:
main(sys.argv[l:])
Output:

Students can Download Tamil Nadu 12th Computer Science Model Question Paper 3 English Medium Pdf, Tamil Nadu 12th Computer Science Model Question Papers helps you to revise the complete Tamilnadu State Board New Syllabus, helps students complete homework assignments and to score high marks in board exams.

TN State Board 12th Computer Sceince Model Question Paper 3 English Medium

General Instructions:

1. The question paper comprises of four parts.
2. You are to attempt all the parts. An internal choice of questions is provided wherever applicable.
3. All questions of Part I, II, III and IV are to be attempted separately.
4. Question numbers 1 to 15 in Part I are Multiple Choice Questions of one mark each.
   These are to be answered by choosing the most suitable answer from the given four alternatives and writing the option code and the corresponding answer
5. Question numbers 16 to 24 in Part II are two-mark questions. These are to be answered in about one or two sentences.
6. Question numbers 25 to 33 in Part III are three-mark questions. These are to be answered in about three to five short sentences.
7. Question numbers 34 to 38 in Part IV are five-mark questions. These are to be answered in detail Draw diagrams wherever necessary.

Time: 3 Hours
Maximum Marks: 70

PART – 1

Choose the correct answer. Answer all the questions: [15 × 1 = 15]

Question 1.
Sin (0) = 0 is an example for function.
(a) Impure
(b) Pure
(c) Interface
(d) Instruction
Answer:
(b) Pure

Question 2.
Write the output (value stored in b)
1. a:=5
2. b:=a
(a) 0
(b) 3
(c) 5
(d) 2
Answer:
(c) 5

Question 3.
Which of the following shortcut is used to create new Python Program?
(a) Ctrl + C
(b) Ctrl + F
(c) Ctrl + B
(d) Ctrl + N
Answer:
(d) Ctrl + N

Question 4.
Escape sequences can be given using ……………………. parameter in print( ) function.
(a) Ret
(b) Let
(c) End
(d) Sep
Answer:
(c) End

Question 5.
Pick the correct one to execute the given statement successfully,
if_: print(x,” is a leap year”)
(a) x % 2 = 0
(b) x % 4 = = 0
(c) x/4 = 0
(d) x % 4 = 0
Answer:
(b) x % 4 = = 0

Question 6.
Find the wrong statement from the following.
(i) Slice a single character from a string
(ii) Slice a substring
(iii) Slice a substring without specifying beginning index
(iv) Slice a substring without specifying end index
(a) (i), (ii)
(b) (ii), (iii), (iv)
(c) All are wrong
(d) All are correct
Answer:
(d) All are correct

Question 7.
Write the output.
list = [34, 45, 48]
list.append(90)
(a) [34, 45, 48, 90]
(b) [90, 34, 45, 48]
(c) [34, 90, 45, 48]
(d) [34, 45, 90, 48]
Answer:
(a) [34, 45, 48, 90]

Question 8.
Match the following.
1. constructor – (I) def process(self)
2. Destructor – (II) S.x
3. method – (III) _del_(self)
4. object – (IV) _init_(self, num)
(a) 1-(IV) 2-(III) 3-(I) 4-(II)
(b) 1 -(I) 2-(II) 3-(III) 4-(IV)
(c) 1-(IV) 2-(II) 3-(I) 4-(III)
(d) 1 -(I) 2-(III) 3-(IV) 4-(II)
Answer:
(a) 1-(IV) 2-(III) 3-(I) 4-(II)

Question 9.
Match the following
1. Relational – (I) Classes
2. Object model – (II) Mainframe
3. ER model – (III) Key
4. Hierarchical – (IV) Entity
(a) 1-(III), 2-(I), 3-(IV), 4-(II)
(b) 1-(I), 2-(II), 3-(III), 4-(IV)
(c) 1-(IV), 2-(III), 3-(I), 4-(II)
(d) 1-(IV), 2-(II), 3-(I), 4-(III)
Answer:
(a) 1-(III), 2-(I), 3-(IV), 4-(II)

Question 10.
Identify which statement is given wrongly?
(a) DDL statement should specify the proper data type
(b) DDL should not identify the type of data division
(c) DDL may define the range of values
(d) DDL should define the size of the data item
Answer:
(b) DDL should not identify the type of data division

Question 11.
(I) csv.writer work with list/tuple
(II) csv.Dictwriter work with dictionary
(III) csv.DictReader work with list/tuple/dictionary.
(a) (I), (II) – True (III) – False
(b) (I) -True (II), (III) – False
(c) (I), (II), (III) – True
(d) (I), (II), (III) – False
Answer:
(a) (I), (II) – True (III) – False

Question 12.
Pick the odd one out.
(a) Perl
(b) Ruby
(c) Tel
(d) Java
Answer:
(d) Java

Question 13.
Match the following related to OS module.
1. g++ – (I) Name of C++ file
2. variable namel – (II) General compiler
3. mode – (III) Input output mode
4. variable_name2 – (IV) Name of exe file
(a) 1-(I), 2-(II), 3-(III), 4-(IV)
(b) 1-(II), 2-(I), 3-(III), 4-(IV)
(c) 1-(IV), 2-(III), 3-(II), 4-(I)
(d) 1-(IV), 2-(I), 3-(III) , 4-(II)
Answer:
(b) 1-(II), 2-(I), 3-(III), 4-(IV)

Question 14.
Assertion (A): Query result can be stored in csv file.
Reason (R): To display the query output in a tabular form.
(a) R is the reason for A
(b) R is wrong
(c) A is wrong
(d) Both are not related
Answer:
(a) R is the reason for A

Question 15.
Identify the Incorrect pair
1. Group – (i) Aggregate functions
2. Order by – (ii) Sortind data
3. Having – (iii) Filter data
4. Where – (iv) max, min
(a) (2)
(b) (1)
(c) (4)
(d) (3)
Answer:
(c) (4)

PART – II

Answer any six questions. Question No. 21 is compulsory. [6 × 2 = 12]

Question 16.
Write note on keyword argument?
Answer:
Keyword arguments will invoke the function after the parameters are recognized by their parameter names. The value of the keyword argument is matched with the parameter name and so, one can also put arguments in improper order (not in order).

Question 17.
What is composition in functions?
Answer:
The value returned by a function may be used as an argument for another function in a nested manner. This is called composition. For example, if we wish to take a numeric value or an expression as a input from the user, we take the input string from the user using the function input( ) and apply eval( ) function to evaluate its value.

Question 18.
Write note on len (str)?
Answer:
Syntax : len(str)
Description: Returns the length (no of characters) of the string.
Example: >>> A=”Corporation”
>>> print(len(A))
11

Question 19.
Define sequence data type?
Answer:
Python programming language has four collections of data types such as List, Tuples, Set – and Dictionary. A list in Python is known as a “sequence data type” like strings. It is an ordered collection of values enclosed within square brackets [ ].

Question 20.
Give example for modifying variable outside a function?
Answer:
Example:
let y: = 0
(int) inc (int) x
y: = y + x;
return (y)

Question 21.
Define ADT?
Answer:
Abstract Data type (ADT) is a type (or class) for objects whose behavior is defined by a set of value and a set of operations.

Question 22.
Write note on Boolean data type?
Answer:
A Boolean data can have any of the two values: True or False.
Example :
Bool_varl=True
Bool_var2=False

Question 23.
Write note on column, table constraint?
Answer:
Column constraint: Column constraint apply only to individual column.
Table constraint: Table constraint apply to a group of one or more columns.

Question 24.
What are the two ways of passing arguments in variable length method?
Answer:

1. Non keyword variable arguments
2. Keyword variable arguments

PART – III

Answer any six questions. Question No. 29 is compulsory. [6 × 3 = 18]

Question 25.
Explain print ( ) in python?
Answer:
In Python, the print( ) function is used to display result on the screen. The syntax for print( ) is as follows:
Example:
print (“string to be displayed as output ”) print (variable)
print (“String to be displayed as output ”, variable)
print (“Stringl ”, variable, “String 2”, variable, “String 3” )

Question 26.
Give the rules for variables?
Answer:
An Identifier is a name used to identify a variable, function, class, module or object.

1. An identifier must start with an alphabet (A..Z or a..z) or underscore (_).
2. Identifiers may contain digits (0 .. 9)
3. Python identifiers are case sensitive, i.e., uppercase and lowercase letters are distinct.
4. Identifiers must not be a python keyword.
5. Python does not allow punctuation character such as %,$, @ etc., within identifiers.

Question 27.
Explain commands and their functions in SQL?
Answer:
Tables are the only way to store data, therefore all the information has to be arranged in the form of tables. The SQL provides a predetermined set of commands to work on databases.

Keywords:
They have a special meaning in SQL. They are understood as instructions.

Commands:
They are instructions given by the user to the database also known as statements.

Clauses:
They begin with a keyword and consist of keyword and argument.

Arguments:
They are the values given to make the clause complete.

Question 28.
Write note on abs ( ), Ord ( ), Chr ( )?
Answer:

Question 29.
Write a pure function to find Gcd of 2 numbers?
Answer:
let rec gcd a b :=
if b < > 0 then gcd b (a mod b) else return a;;
output
gcd 13 27;;
-: int = 1
gcd 20536 7826;;
-: int = 2
In the above example program ‘gcd’ is the name of the function which recursively called till the variable ‘b’ becomes ‘O’. Remember b and (a mod b) are two arguments passed to ‘a’ and ‘b’of the gcd function.

Question 30.
Write the use of Savepoint command with an example?
Answer:
SAVEPOINT command:
The SAVEPOINT command is used to temporarily save a transaction so that you can rollback to the point whenever required. The different states of our table can be saved at anytime using different names and the rollback to that state can be done using the ROLLBACK command.

SAVEPOINT savepoint name;
UPDATE Student SET Name = ‘Mini’WHERE Admno=105;
SAVEPOINT A;

Question 31.
Find output:
str1 = input (“Enter a string: “)
index= -1
while index >= -(len(str1)):
print (“Subscriptf”,index,”] : ” + str1 [index])
index += -1
Answer:
Output:
Enter a string: welcome
Subscript [ -1 ] : e
Subscript [ -2 ] : m
Subscript [ -3 ] : o
Subscript [ -4] : c
Subscript [ -5 ] : 1
Subscript [ -6 ] : e
Subscript [ -7 ] : w

Question 32.
Name some functions where lambda 0 is used?
Answer:
filter ( ), map ( ), reduce

Question 33.
Find output:
Answer:
def
printinfo (name, sal=500):
print (name)
print (sal)
return
print info (“mani”)
Output:
Mani
500

PART – IV

Answer all the questions. [5 × 5 = 25]

Question 34 (a).
Explain, various data types in SQL?
Answer:

[OR]

(b) Compare DBMS with RDBMS?
Answer:

Question 35 (a).
Explain various characteristics of modules?
Answer:

1. Modules contain instructions, processing logic, and data.
2. Modules can be separately compiled and stored in a library.
3. Modules can be included in a program.
4. Module segments can be used by invoking a name and some parameters.
5. Module segments can be used by other modules.

[OR]

(b) Explain Alter command in SQL?
Answer:
The ALTER command is used to alter the table structure like adding a column, renaming the existing column, change the data type of any column or size of the column or delete the column from the table. It is used in the following way:

ALTER TABLE <table-name> ADD <column-name> <data type> <size>;
To add a new column “Address” of type ‘char’ to the Student table, the command is used as:-

ALTER TABLE Student ADD Address char;
To modify existing column of table, the ALTER TABLE command can be used with MODIFY clause like wise:

ALTER <table-name> MODIFY<column-name> <data type> <size>;
ALTER TABLE Student MODIFY Address char (25);

The above command will modify the address column of the Student table to now hold 25 characters. The ALTER command can be used to rename an existing column in the following way:

ALTER <table-name> RENAME old-column-name TO new-column-name;
For example to rename the column Address to City, the command is used as:

ALTER TABLE Student RENAME Address TO City;
The ALTER command can also be used to remove a column or all columns, for example to remove a particular column, the DROP COLUMN is used with the ALTER TABLE to remove a particular field, the command can be used as:

ALTER <table-name> DROP COLUMN <column-name>;
To remove the column City from the Student table, the command is used as:
ALTER TABLE Student DROP COLUMN City;

Question 36(a).
Consider the following employee table. Write SQL commands for the qtns.(i) to (v)?

1. To display the details of all employees in descending order of pay.
2. To display all employees whose allowance is between 5000 and 7000.
3. To remove the employees who are mechanic.
4. To add a new row.
5. To display the details of all employees who are operators.

Answer:
Output:

1. SELECT * FROM employee ORDER BY DESC;
2. SELECT * FROM employee WHERE ((allowance >= 5000) AND (allowance <=7000));
3. DELETE FROM employee WHERE desig = “Mechanic”;
4. INSERT INTO employee(Empcode, Name, desig, pay, allowance) VALUES(‘M1006’, ‘RAM’, ‘Mechanic’,22000, 8000);
5. SELECT * FROM employee WHERE desig = ‘operator’;

[OR]

(b) How will you write data into different types in CSV files?
Answer:
As you know Python provides an easy way to work with CSV file and has csv module to read and write data in the csv file. In the previous topics, You have learned how to read CSV files • in Python. In similar way, You can also write a new or edit an existing CSV files in Python.

1. Creating A New Normal CSV File
2. Modifying An Existing File
3. Writing On A CSV File with Quotes
4. Writing On A CSV File with Custom Delimiters
5. Writing On A CSV File with Lineterminator
6. Writing On A CSV File with Quotechars
7. Writing CSV File Into A Dictionary
8. Getting Data At Runtime And Writing In a File

Question 37 (a).
Write a sample program to illustrate private and public variables using classes?
Answer:
class Sample:
def_init_(self, n1, n2):
self._n1=n1
self._n2=n2
def display(self):
print(“Class variable 1 = “, self.n1)
print(“Class variable 2 = “, self._n2)
S=Sample(12, 14)
S.display( )
print(“Value 1 = “, S.n1)
print(“Value 2 = “, S._n2)
In the above program, there are two class variables n1 and n2 are declared. The variable nl is a public variable and n2 is a private variable. The display( ) member method is defined to show the values passed to these two variables.

The print statements defined within class will successfully display the values of n1 and n2, even though the class variable n2 is private. Because, in this case, n2 is called by a method defined inside the class. But, when we try to access the value of n2 from outside the class Python throws an error. Because, private variable cannot be accessed from outside the class.

Output:
Class variable 1 = 12 Class variable 2=14 Value 1 = 12
Traceback (most recent call last):
File “D:/Python/Class-Test-04.py”, line 12, in <module> print(“Value 2 = “, S._n2)
AttributeError: ‘Sample’ object has no attribute ‘n2’

[OR]

(b) Explain updating and deleting Tuple with example?
Answer:
As you know a tuple is immutable, the elements in a tuple cannot be changed. Instead of altering values in a tuple, joining two tuples or deleting the entire tuple is possible.
Example:
# Program to join two tuples
Tup 1 = (2, 4, 6, 8, 10)
Tup 2 = (1,3,5,7,9)
Tup 3 = Tup1 + Tup2
print(Tup3)

Output:
(2, 4, 6, 8, 10, 1, 3, 5, 7, 9)
To delete an entire tuple, the del command can be used.
Syntax: del tuple_name
Example:
Tup1 =(2, 4, 6, 8, 10)
print(“The elements of Tup1 is “, Tup1)
del Tup1
print (Tup1)

Output:
The elements of Tupl is (2, 4, 6, 8, 10)
Traceback (most recent call last):
File “D:/Python/Tuple Examp l.py”, line 4, in <module>
print (Tupl)
NameError: name ‘Tup1’ is not defined
Note that, the print statement in the above code prints the elements. Then, the del statement deletes the entire tuple. When you try to print the deleted tuple, Python shows the error.

Question 38 (a).
Explain nested If -elif – else statement with example?
Answer:
When we need to construct a chain of if statement(s) then ‘elif’ clause can be used instead of ‘else’.
Syntax:
if <condition-l>:
statements-block 1

elif <condition-2>:
statements-block 2

else:
statements-block n

In the syntax of if.elifi.else mentioned above, condition-1 is tested if it is true then statements- block 1 is executed, otherwise the control checks . condition-2, if it is true statements-block2 is executed and even if it fails statements-block n mentioned in else part is executed.

‘elif’ clause combines ifi.else-ifi.else statements to one if..elif…else, ‘elif’ can be considered to be abbreviation of ‘else if’. In an ‘if’ statement there is no limit of ‘elif’ clause that can be used, but an ‘else’ clause if used should be placed at the end.

Example:
Program to illustrate the use of nested if statement

m1=int (input(“Enter mark in first subject: ”))
m2=int (input(“Enter mark in second subject: ”))
avg= (m1+m2)/2
if avg>=80:
print (“Grade : A”)
elif avg>=70 and avg<80:
print (“Grade : B”)
elif avg>=60 and avg<70:
print (“Grade : C”)
elif avg>=50 and avg<60:
print (“Grade : D”)
else:
print (“Grade : E”)

Output 1:
Enter mark in first subject: 34 Enter mark in second subject: 78 Grade : D

Output 2 :
Enter mark in first subject: 67

[OR]

(b) Explain how to pass parameters in functions?
Answer:
Parameters or arguments can be passed to functions:-

deffunction_name (parameters) separated by comma):

Let us see the use of parameters while defining functions. The parameters that you place in the parenthesis will be used by the function itself. You can pass all sorts of data to the functions. Here is an example program that defines a function that helps to pass parameters into the function.

# assume w = 3 and h = 5
def area(w,h):
return w * h
print (area (3,5))

The above code assigns the width and height values to the parameters w and h. These parameters are used in the creation of the function “area”. When you call the above function, it returns the product of width and height as output. The value of 3 and 5 are passed to w and h respectively, the function will return 15 as output.

Subject Matter Experts at SamacheerKalvi.Guide have created Samacheer Kalvi Tamil Nadu State Board Syllabus New Paper Pattern 12th Economics Model Question Papers 2020-2021 with Answers Pdf Free Download in English Medium and Tamil Medium of TN 12th Standard Economics Public Exam Question Papers Answer Key, New Paper Pattern of HSC 12th Class Economics Previous Year Question Papers, Plus Two +2 Economics Model Sample Papers are part of Tamil Nadu 12th Model Question Papers.

Let us look at these Government of Tamil Nadu State Board 12th Economics Model Question Papers Tamil Medium with Answers 2020-21 Pdf. Students can view or download the Class 12th Economics New Model Question Papers 2021 Tamil Nadu English Medium Pdf for their upcoming Tamil Nadu HSC Board Exams. Students can also read Tamilnadu Samcheer Kalvi 12th Economics Guide.

TN State Board 12th Economics Model Question Papers 2020 2021 English Tamil Medium

Tamil Nadu 12th Economics Model Question Papers English Medium 2020-2021

• Tamil Nadu 12th Economics Model Question Paper 1 English Medium
• Tamil Nadu 12th Economics Model Question Paper 2 English Medium
• Tamil Nadu 12th Economics Model Question Paper 3 English Medium
• Tamil Nadu 12th Economics Model Question Paper 4 English Medium
• Tamil Nadu 12th Economics Model Question Paper 5 English Medium

Tamil Nadu 12th Economics Model Question Papers Tamil Medium 2020-2021

• Tamil Nadu 12th Economics Model Question Paper 1 Tamil Medium
• Tamil Nadu 12th Economics Model Question Paper 2 Tamil Medium
• Tamil Nadu 12th Economics Model Question Paper 3 Tamil Medium
• Tamil Nadu 12th Economics Model Question Paper 4 Tamil Medium
• Tamil Nadu 12th Economics Model Question Paper 5 Tamil Medium

12th Economics Model Question Paper Design 2020-2021 Tamil Nadu

Types of Questions	Marks	No. of Questions to be Answered	Total Marks
Part-I Objective Type	1	20	20
Part-II Very Short Answers (Totally 10 questions will be given. Answer any Seven. Any one question should be answered compulsorily)	2	7	14
Part-Ill Short Answers (Totally 10 questions will be given. Answer any Seven. Any one question should be answered compulsorily)	3	7	21
Part-IV Essay Type	5	7	35
Marks			90
Internal Assessment			10
Total Marks			100

Tamil Nadu 12th Economics Model Question Paper Weightage of Marks

Purpose	Weightage
1. Knowledge	30%
2. Understanding	40%
3. Application	20%
4. Skill/Creativity	10%

It is necessary that students will understand the new pattern and style of Model Question Papers of 12th Standard Economics Tamilnadu State Board Syllabus according to the latest exam pattern. These Tamil Nadu Plus Two 12th Economics Model Question Papers State Board Tamil Medium and English Medium are useful to understand the pattern of questions asked in the board exam. Know about the important concepts to be prepared for TN HSLC Board Exams and Score More marks.

We hope the given Samacheer Kalvi Tamil Nadu State Board Syllabus New Paper Pattern Class 12th Economics Model Question Papers 2020 2021 with Answers Pdf Free Download in English Medium and Tamil Medium will help you get through your subjective questions in the exam.

Let us know if you have any concerns regarding the Tamil Nadu Government 12th Economics State Board Model Question Papers with Answers 2020 21, TN 12th Std Economics Public Exam Question Papers with Answer Key, New Paper Pattern of HSC Class 12th Economics Previous Year Question Papers, Plus Two +2 Economics Model Sample Papers, drop a comment below and we will get back to you as soon as possible.

Students can Download Tamil Nadu 12th Accountancy Model Question Paper 2 English Medium Pdf, Tamil Nadu 12th Accountancy Model Question Papers helps you to revise the complete Tamilnadu State Board New Syllabus, helps students complete homework assignments and to score high marks in board exams.

TN State Board 12th Accountancy Model Question Paper 2 English Medium

Instructions:

1. The question paper comprises of four parts.
2. You are to attempt all the parts. An internal choice of questions is provided wherever applicable.
3. All questions of Part I, II. III and IV are to be attempted separately.
4. Question numbers 1 to 20 in Part I are Multiple Choice Questions of one mark each. These are to be answered by choosing the most suitable answer from the given four alternatives and writing the option code and the corresponding answer.
5. Question numbers 21 to 30 in Part II are two-mark questions. These are to be answered in about 50 words.
6. Question numbers 31 to 40 in Part III are three-mark questions. These are to be answered in about 150 words.
7. Question numbers 41 to 47 in Part IV are five-mark questions. These are to be answered in about 250 words. Draw diagrams wherever necessary.

Time: 2.30 Hours
Max Marks: 90

PART-I

Answer all the questions. Choose the correct answer. [Answers are in bold] [20 × 1 = 20]

Question 1.
In case of net worth method of single entry system profit is ascertained by
(a) Comparing the capital in the beginning of the accounting period and the capital at the end of the accounting period
(b) Preparing profit and loss account
(c) Preparing a balance sheet
(d) Representative Personal Account
Answer:
(a) Comparing the capital in the beginning of the accounting period and the capital at the end of the accounting period

Question 2.
Profit = capital at the end + ? – capital introduced – capital in the beginning ………
(a) Sales
(b) Drawing
(c) Net purchases
(d) Revenue expenditure
Answer:
(b) Drawing

Question 3.
From the incomplete records, it is possible to prepare…………
(a) Ledger Accounts
(b) Trial Balance
(c) Statement of Affairs
(d) Personal Account
Answer:
(c) Statement of Affairs

Question 4.
Which of the following is to be recorded in an income and expenditure account?
(а) Purchase of a fixed asset
(б) Capital expenditure incurred in a fixed asset
(c) Profit on the sale of fixed asset
(d) Sale of a fixed assets
Answer:
(c) Profit on the sale of fixed asset

Question 5.
Subscription due but not yet earned is considered as an…………
(a) Asset
(b) Liability
(c) Income
(d) Expenditure
Answer:
(a) Asset

Question 6.
In India partnership firms are governed by the Indian Partnership act ………….
(a) 1932
(b) 1930
(c) 1992
(d) 1986
Answer:
(a) 1932

Question 7.
The maximum number of partners in a partnership firm is……….
(a) 25
(b) 10
(c) 30
(d) 50
Answer:
(d) 50

Question 8.
The monetary value of such advantage is termed as………..
(a) Goodwill
(b) Bank overdraft
(c) Capital
(d) Cash
Answer:
(a) Goodwill

Question 9.
Goodwill helps in earning more profit and attracts more…………
(a) Customers
(b) Producers
(c) Competitors
(d) Suppliers
Answer:
(a) Customers

Question 10.
When are unrecorded liabilities is brought into books is results in …………
(a) Profit
(b) loss
(c) income
(d) expense
Answer:
(b) loss

Question 11.
The revaluation profit or loss is transferred to the old partner’s capital accounts in their……..
(a) Old ratio
(b) New ratio
(c) Sacrifice ratio
(d) Gain ratio
Answer:
(a) Old ratio

Question 12.
A partner who retires from the firm is called an……….
(a) outgoing partner
(b) admitted partner
(c) death of a partner
(d) none of these
Answer:
(a) outgoing partner

Question 13.
Profits and loses of previous years which are not distributed to the partners are known as ………
(a) Accumulated profit and losses
(b) General reserve
(c) Reserve fund
(d) Workmen compensation fund
Answer:
(a) Accumulated profit and losses

Question 14.
The money raised by issuing shares is called………
(a) Share capital
(b) Dividend
(c) Equity capital
(d) Share application
Answer:
(a) Share capital

Question 15.
Profits are distributed among the shareholders in the form of………..
(a) Share
(b) Dividends
(c) Both
(d) None of these
Answer:
(b) Dividends

Question 16.
Which statements are involve personal judgements in certain cases?
(a) Financial statements
(b) Income statements
(c) Profit and loss account statements
(d) None of these
Answer:
(a) Financial statements

Question 17.
Different tools are used for analysing the…………
(a) Balance sheet
(b) Financial statement
(c) Income statement
(d) None of these
Answer:
(b) Financial statement

Question 18.
If the two items in a ratio are from income statement it is classified as ………….
(a) Balance sheet ratio
(b) Income statement ratio
(c) Inter-statement ratio
(d) None of these
Answer:
(b) Income statement ratio

Question 19.
If a ratio is computed with one item from income statement and another item from balance sheet it is called ……….
(a) Inter-statement ratio
(b) Balance sheet ratio
(c) Income statement ratio
(d) None of these
Answer:
(a) Inter-statement ratio

Question 20.
Transactions are to be recorded through………….
(a) Journal entries
(b) Voucher entries
(c) Accounting entries
(d) None of these
Answer:
(b) Voucher entries

PART – II

Answer any seven questions in which question no. 30 is compulsory. [7 × 2 = 14]

Question 21.
What are the possible reasons for keeping in complete records?
Answer:
(i) Simple method:
Proprietor, who do not have the proper knowledge of accounting principles. Find it much convenient and easier to maintain their business records under this system.
(ii) Less expensive:
It is an economical mode of maintaining records as there is no need to appoint specialised accountant.

Question 22.
What are the features of not- for-profit organisation?
Answer:

1. They are the organisations which function without any profit motive.
2. Their main aim is to provide services to a specific group or the public at large.
3. They do not undertake business or trading activities.

Question 23.
Mannan and Ramesh share profit and losses 3 : 1. The capital of Rs 80,000 and Rs 60,000 and their current accounts show a credit balance of Rs 10,000 and Rs 5,000 respectively. Calculate interest on capital at 5% p.a. for the year ending 31st march 2018 and show the journal entries.
Answer:
Interest on capital = amount of capital × rate of interest
Interest of Mannan’s capital = 80,000 × \(\frac{5}{100}\) = Rs 4,000
Interest of Ramesh’s capital = 60,000 × \(\frac{5}{100}\) = Rs 3,000
Note:
Balance of current account will not be considered for calculation of interest on capital.

Question 24.
The following are the profit of a firm in the last five years 2014 – Rs 8,000, 2015 – Rs 6,000, 2016 – Rs 10,000, 2017 – Rs 9,000, 2018 – Rs 7,000. Calculate the value of goodwill at 3 years purchase of average profits of five year.
Answer:
Goodwill = Average profit × No. of years of purchase

Goodwill = Average profit × No. of years of purchase
= Rs 8,000 × 3
Goodwill = Rs 24,000

Question 25.
What is the journal entries of transferring of accumulated profit and reserves?
Answer:

Question 26.
Kiran, vinoth and vimal are partners sharing profits in the ratio 5 : 3 : 2. Kiran retires and the new profit sharing ratio between vinoth and vimal is 2 : 1. Calculate the gaining ratio.
Answer:
Share gained = New share – Old Share

Question 27.
What is the journal entry forfeiture of shares?
Answer:
Journal Entry

Question 28.
What is analysis of Financial statement?
Answer:

1. Methodical classification of the data given in the financial statement.
2. Explaining the meaning and significance of the relationship between various financial factor,
3. Comparison of these relationship.

Question 29.
Calculate quick ratio of Ananth construction ltd from the following given below. Total current liabilities Rs 1,00,000, Inventories Rs 50,000,
Total current assets Rs 25,000, prepaid expenses Rs 15,000.
Answer:

= Current assets – Inventories – Prepaid expenses
= 2,50,000 – 50,000 – 15,000
= Rs 1,85,000

Question 30.
What are accounting reports?
Answer:
Accounting report is a compilation of accounting information that are derived from the accounting records of a business concern. Accounting reports may be classified as routine reports and special purpose reports.

PART – III

Answer any seven questions in which question No. 40 is compulsory. [7 × 3 = 21]

Question 31.
Following are the balances in the books of Thomas as on 31st march 2019.

Answer:

Question 32.
From the following particulars of Tamil Educational society. Prepare Receipts and payments account for year ended 31st march 2019.

Answer:

Question 33.
Mr A and B started a business on 1.4.2014 with capital of Rs 60,000, Rs 50,000 respectively. On 1st July 2014 Mr A withdrawal of Rs 8000 from his capital. Mr. B introduced additional capital Rs 10,000 on 30.9.2014. Calculate interest on capital at 5% p.a. for the year ending 31.03.2015.
Answer:

Question 34.
A firm has decided to value its goodwill at 3 years purchase of the average profits of 4 years using weighted average methods. Profits of past 4 years & respective weights are as follows.

compute the value of good will.
Answer:

Goodwill = Weighted Average profit × Number of years of purchase
= 24,800 × 3 = Rs 74,400

Question 35.
Sri Ram and Raj are partners sharing profit and losses in the ratio of 2 : 1. Nelson joins as a partner on 1.4.17.
The following adjustments are to be made.
(i) Increase the value of stock Rs 5,000
(ii) Bring into record investments of Rs 7,000, which had not been recorded in the books of the firm.
(iii) Reduce the value of office equipment by Rs 10,000.
(iv) A provision would also be made for outstanding wages for Rs 9,500. Give the journal entries.
Answer:
Journal Entries

Question 36.
Rahul, Ravi and Rohit are partners, sharing profits and loss in the ratio of 5 : 3 : 2. Rohit retires and the share is taken by Rahul and Ravi in the ratio of 3 : 2. Find out the new profit sharing ratio and gaining ratio.
Answer:
Rohit share = \(\frac{2}{10}\)
Share gained = Retiring partner share × Proportion of share gained

New share of continuing partners = old share + share gained

Question 37.
Anu company forfeited 200 equity shares of Rs 10 each issued at par held by thiyagu for non-payment of the final call of Rs 3 per share. The shares were reissued to laxman at Rs 6 per share, show the journal entries.
Answer:
In the books of Anu Company Journal entries

Question 38.
From the following prepare comparative income statement of Tharun & Co. Ltd.

Answer:
Comparative incomp statement of Tharun Co. Ltd. for the year ended 31st March 2017 and 31st March 2018

Tutorial note: Computation of percentage increase for revenue from operations.

Question 39.
Calculate operating profit ratio under the following cases,
Case 1: Revenue from operation Rs 20,00,000 operating profit Rs 3,00,000
Case 2: Revenue from operation Rs 30,00,000 operating cost Rs 24,00,000
Case 3: Revenue from operation Rs 40,00,000 gross profit 30% on revenue from
operations expenses Rs 8,00,000.
Answer:

Operating profit = Revenue from operation – operating cost
= 30,00,000 – 24,00,000 = Rs 6,00,000

Operating profit = Gross profit – Operating expenses
= 12,00,000 – 8,00,000 = Rs 4,00,000

Question 40.
What are the salient features of computerised Accounting system?
Answer:
(i) Simplicity:
They are easy to set up and simple to us.
(ii) Speed:
They are capable to generation instant and accurate report.
(iii) Power:
They are capable of maintaining accounts of multiple companies and with unlimited levels of classification.
(iv) Flexibility:
They provide flexibility to generate instant reports for giving period.

PART – IV

Answer all the following questions. [7 × 5 = 35]

Question 41(a).
From the following particulars calculate total purchase.

Answer:
Bills payable account

Total Purchases = Cash purchases + credit Purchase
= 7 3,20,000 + 74,80,000 = 7 8,00,000

[OR]

(b) From the following receipts and payments account of yercaud youth Association. Prepare income and expenditure Account for the year ended 31st march 2019 and the balance sheet as on that date.

Additional information:
(i) Opening capital fund Rs 20,000
(ii) Stock of books on 1.4.2018 Rs 9,200
(iii) Subscription due but not received Rs 1,700
(iv) Stock of stationery on 1.4.2018 Rs 1,200; stock of stationery on 31.3.2019 Rs 2,000.
Answer:
Income and Expenditure Account for the year ended 31.3.2019

Question 42(a).
Miss. Soniya sport equipment does not keep proper records from the following informations. Find out profit or loss and also prepare balance sheet for the year ended 31st December 2017.

Drawing Rs 10,000 per month for personal use, additional capital introduced during the year Rs 2,00,000. A bad debts Rs 2,000 and a provision of 5% to be made in debtors. Outstanding salary Rs 2,600 prepaid insurance Rs 700 depreciation changed as furniture at 10% P.a.
Answer:
Statement of affairs as on 31st December 2016

Balance sheet as on 31.3.2017

[OR]

(b) From the following Receipts and Payment account of Neyveli Science Club for the year ended 31st December 2018.

Additional information:
(i) Opening capital fund Rs 6,400
(ii) Subscription includes Rs 600 for the year 2019
(iii) Science equipment as on 1.1.2018 Rs 5,000
(iv) Surplus on account of exhibition should be kept in reserve for new auditorium.
Prepare income and expenditure account for the year ended 31st December 2018 and the balance sheet as on that date.
Answer:
Income and Expenditure Account for the year ended 31st Dec. 2018

Question 43(a).
Arulappan and Nallasamy are partners sharing profit and losses in the ratio 4 : 1. On 1st January 2018 their capitals were Rs 20,000 and Rs 10,000 respectively. The partnership deed specifies the following.
(а) Interest on capital is to he allowed at 5%P.a
(b) Interest on drawings charged to Arulappan and Nallasamy are Rs 200 and Rs 300 respectively.
(c) The net profit of the firm before considering interest on capital and interest on drawings amounted to Rs 18,000.
Give the journal entries and prepare profit and loss appropriation account for the year ending 31st December 2018. Assume that the capitals are fluctuating.
Answer:
Journal Entries

[OR]

(b) From the following information compute the value of goodwill by super profit method & capitalising method
(i) Capital employed is Rs 4,00,000
(ii) Normal rate of return is 10%
(iii) Profit for 2016 : Rs 62,000; 2017 : Rs 61,000 and 2018 : Rs 63,000
(iv) Super profit method:
Answer:

Normal profit = capital employed × Normal rate of return
= 400000 × \(\frac{10}{100}\)
= 40000
Super profit = Average profit – Normal profit = Rs 62,000 – 40,000
= Rs 22,000

Goodwill = Total capitalised value of the average profit – Capital employed = Rs 6,20,000 – 4,00,000
= Rs 22,000

Question 44(a).
Calculate the value of goodwill of the partnership firm of 2 partners
(а) At the 3 years purchase of average profits
(b) At the 3 years purchase of super profits
(c) On the basis of capitalisation of super profits
(d) On the basis of capitalisation of average profits
(i) Average capital employed Rs 7,00,000
(ii) Net trading results of the firm 2014 – Rs 1,47,600, 2015 – Loss Rs 1,48,100, Profit for 2016 – Rs 4,48,700
(iii) Interest on capital @ 18%
(iv) Remuneration Rs 500 per month.
Answer:
Calculation of Average profit and super profit
Total profit = Rs 1,47,600 – Rs 1,48,100 + Rs 4,48,700 = Rs 4,48,200

Super profit = Average profit – Normal profit
= 1,37,400 – 1,26,000
Super profit = Rs 11,400
(a) Average profit method:
Average profit × No. of years purchase
= Rs 1,37,400 × 3 = Rs 4,12,200
(b) Super profit method:
Super profit × No. of years purchase
= Rs 11,400 × 3 = Rs 34,200

[OR]

(b) Sri Ram and Raj are partners sharing profits in the ratio 2 : 1. Nelson joins as a partner on 1st April 2017. The following adjustments are to be made.
(i) Increase the value of Rs 10,000
(ii) Bring into record investment of Rs 14,000 which had not been recorded in the books of the firm.
(iii) Reduce the value of office equipment by Rs 20,000
(iv) A provision would also be made for outstanding wages for Rs 19,000. Give journal entries and prepare revaluation account.
Answer:
Journal Entries

Question 45(a).
Raj an and selva are partners sharing profit and losses in the ratio of 3:1. sheet as on 31st march 2017.

On 1.4.2017 they admit Ganesan as a new partner on the following arrangements
(i) Ganesan brings 10,000 as capital for 1/5 share of profit.
(ii) Stock and furniture is to be reduced by 10% a reserve of 5% on debtors for doubtful debts is to be created.
(iii) Appreciate building by 20%
Prepare revaluation account, partners capital account and the balance sheet of the firm after admission.
Answer:

[OR]

(b) The balance sheet of Rekha and mary on 31.12.2018 as

They share the profit and losses in the ratio 3 : 1. They agreed to admit kavitha into the partnership firm for 1/4 share of profits which she gets entirely gets from Rekha. Following are the conditions,
(i) Kavitha has to bring Rs 20,000 as capital. Her share of goodwill is valued at 4,000. She could not bring cash towards goodwill.
(ii) Depreciate buildings by 10%
(iii) Stock to be the revalued at Rs 6,000
(iv) Create provision for doubtful debts @ 5% on debito?
Prepare necessary ledger accounts and the balance sheet after admission.
Answer:

Question 46(a).
Charles, Muthu and sekar are partners sharing profits in the ratio 3 : 4 : 2. Their balance sheet as on 31st december 2018 is as under.

(i) On 1.1. 2019 Charles retired from the partnership firm on the following arrangements. Stock to be appreciated by 10%
(ii) Furniture to be depreciated by 5%
(iii) To provide Rs 1000 for bad debts
(iv) There is an outstanding repair of Rs 11,000 not yet recorded.
(v) The final amount due to Charles was paid.
Prepare revaluation account, capital account and the balance sheet of partner’s frim after the retirement.
Answer:

Balance sheet

[OR]

(b) Thangam Ltd issued 50,000 shares of Rs 10 each at a premium of Rs 2 per share payable as follows.
On application Rs 5, on allotment Rs 5 (including premium) on first and final call Rs 2.
Issue was fully subscribed and the amounts due were received except priya to whom 500 shares were allotted who faded to pay the allotment money and first and final call money. Her shares were forfeited. All the forfeited shares were reissued to devi Rs 8 per share. Pass journal entries.
Answer:
Journal Entries

Question 47(a).
Compute trend percentage for the following particular of Boomi Ltd.

Answer:

[OR]]

(b) Calculate-
(i) inventory turnover ratio
(ii) Trade receivable turnover
(iii) Trade payable turnover ratio
(iv) Fixed assets turnover ratio
(v) Gross profit ratio from the following,

Additional information:
Revenue from operations for the year Rs 10,50,000
Purchases for the year Rs 4,50,000
Cost of revenue from operations RS 6,00,000
Assume that sales and purchase are for credit
Answer:


Gross profit = Revenue from operations – Cost of revenue from operations
= 10,50,000 – 6,00,000
= 7 4,50,000