Kerala Plus Two Question Paper 2022 Computer Application Commerce

Reg. No. : .....................................
Name : ..........................................
SY-46
SECOND YEAR HIGHER SECONDARY EXAMINATION, MARCH 2022

Part – III Time : 2 Hours
COMPUTER APPLICATION Cool-off time : 15 Minutes
COMMERCE
Maximum : 60 Scores

General Instructions to Candidates :
 There is a ‘Cool-off time’ of 15 minutes in addition to the writing time.
 Use the ‘Cool-off time’ to get familiar with questions and to plan your answers.
 Read questions carefully before answering.
 Read the instructions carefully.
 Calculations, figures and graphs should be shown in the answer sheet itself.
 Malayalam version of the questions is also provided.
 Give equations wherever necessary.
 Electronic devices except non-programmable calculators are not allowed in the
Examination Hall.

 
    15  ‘  ’ .
 ‘  ’    
 .
      .
    .
  , , ,   
.
   .
    .
     
    .

SY-46 1 P.T.O.

PART – I

A. Answer any five questions from 1 to 9. Each carries 1 score. (5  1 = 5)

1. Write an example for entry controlled loop in C++.

2. Accessing each elements of an array at least once is known as ________.

3. Name the built in function used to find the square root of a number.

4. Which tag is used to incude scripts in HTML page ?

5. Write an example for FTP client software.

6. IN RDBMS, Columns of a relation are called ________.

(Entity, Tuple, Attribute)

7. Pick the DDL command.

(CREATE, SELECT, GRANT)

8. Write an example for ERP package.

9. Name any one mobile operating system.

SY-46 2

PART – I

A. 1  9       .

1   (5  1 = 5)

1. C++       .

2.       
________  .

3.         
.

4. HTML      .

5. FTP     .

6. RDBMS-,    ________  .

(Entity, Tuple, Attribute)

7. DDL  .

(CREATE, SELECT, GRANT)

8. ERP    .

9.       .

SY-46 3 P.T.O.

B. Answer all questions from 10 to 13. Each carries 1 score. (4  1 = 4)

10. ______ statement is used to skip the current iteration of a loop.

(Break, Continue, Go to)

11. The port number used for HTTP is ________.

(80, 110, 443)

12. Name the tag used to divide the browser window.

13. Pick the CARTESIAN PRODUCT operator.

(U, X, n)

PART – II

A. Answer any two questions from 14 to 17. Each carries 2 scores. (2  2 = 4)

14. List the input and output functions to handle strings containing white spaces.

15. Briefly explain free hosting.

16. List 4 DML commands in SQL.

17. List out any four benefits of ERP system.

SY-46 4

B. 10  13     .

1  . (4  1 = 4)

10.      ______ 
.
(break, continue, go to)

11. HTTP-    ________.

(80, 110, 443)

12.      .

13. CARTESIAN PRODUCT  .

(U, X, n)

PART – II
A. 14  17       .
2  . (2  2 = 4)

14.       ,
   .

15.    .

16. SQL- 4 DML   .

17. ERP     .

SY-46 5 P.T.O.

B. Answer any two questions from 18 to 20. Each carries 2 scores. (2  2 = 4)
18. What are default arguments ?

19. What you mean by responsive web designing ?

20. Name any four aggregate functions in SQL.

PART – III

A. Answer any three questions from 21 to 24. Each carries 3 scores. (3  3 = 9)

21. Explain any three data types in C++.

22. List and explain any three attributes of <BODY> tag.

23. Explain any three Built – in Functions in JavaScript.

24. Explain any three database users.

B. Answer any two questions from 25 to 27. Each carries 3 scores. (2  3 = 6)

25. List and explain any three types of statements in C++.

26. What is an array ? Initialize an array with three elements.

27. Write HTML code to display the following :

(a) H2SO4

(b) a2 + b2 + 2ab

SY-46 6

B. 18  20      .

2   (2  2 = 4)

18.     ?

19.      
.

20. SQL-      .

PART – III
A. 21  24   3   .
3  . (3  3 = 9)
21. C++      .

22. <BODY>      .

23.   3  -   .

24.     .

B. 25  27   2   ,
3   (2  3 = 6)

25. C++        .

26.    ?       .

27.   HTML  
(a) H2SO4

(b) a2 + b2 + 2ab

SY-46 7 P.T.O.

PART – IV

A. Answer any three questions from 28 to 31. Each carries 4 scores. (3  4 = 12)

28. Explain any two looping statements in C++ with syntax.

29. Compare Call by value and call by reference methods used in C++ functions.

30. Write and explain any 4 text formatting tags in HTML.

31. Name any four category of operators in JavaScript, give one example for each.

B. Answer any one question from 32 to 33. Carries 4 scores. (1  4 = 4)

32. Write HTML code to generate the following nested list in a web page :

● Kerala

1. Alappuzha

2. Moonnar

● Karnataka

1. Bangalore

2. Mysore

33. Explain ICT Applications in business.

SY-46 8

PART – IV

A. 28  31   3   .

4  . (3  4 = 12)

28. C++       
.

29. C++        
  .

30. HTML-  4     .

31. JavaScript-  4    ,  
 .

B. 32  33   1   .

4 . (1  4 = 4)

32.        HTML 
.

● Kerala

1. Alappuzha

2. Moonnar

● Karnataka

1. Bangalore

2. Mysore

33.  ICT  .
SY-46 9 P.T.O.

PART – V

Answer any two questions from 34 to 36. Each carries 6 scores. (2  6 = 12)

34. Write the complete HTML code to display the following table in a web page

RollNo Name

1 Arya

2 Arun

35. List and explain the Advantages of DBMS.

36. (a) Write SQL query to create a table with following details : (3)

Attributes Type Description

AccNo Numeric Primary key

Name String 30 char

Gender Char Default ‘M’

Amount Numeric NOT NULL

(b) Write SQL query to display All the details from the table. (1)

(c) Write SQL query to display All Male customers in the table with amount>5000. (2)
__________

SY-46 10

PART – V

34  36   2   .

6  . (2  6 = 12)

34.        HTML
 .

RollNo Name

1 Arya

2 Arun

35. DBMS-  .

36. (a)       SQL
  : (3)

Attributes Type Description
AccNo Numeric Primary key
Name String 30 char
Gender Char Default ‘M’
Amount Numeric NOT NULL

(b)      SQL 
. (1)

(c)  >5000    
 SQL  . (2)
__________

SY-46 11 P.T.O.

SY-46 12