Kerala Plus Two Question Paper 2024 Computer Application Commerce

Kerala Board

Question Paper
2024

Reg. No. : ......................................
SY-546 Name : ...........................................

SECOND YEAR HIGHER SECONDARY EXAMINATION, MARCH – 2024

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-546 1 P.T.O.

Answer any 5 questions from 1 to 6. Each carries 1 score. (5  1 = 5)
1. The insertion operator in C++ is ______.
(<, >, <<, >>)

2. The subscript of last element in the array A[10] is ______.

3. Which among the following is an empty tag ?
(<B>, <H1>, <HR>, <FONT>)

4. ______ is a JavaScript function used to display a text in a webpage.

5. GRANT is a ______ command.
(DDL, DML, DCL, None of these)

6. ERP stands for ______.

Answer any 9 questions from 7 to 18. Each carries 2 scores. (9  2 = 18)
7. Given
int M[ ]={10,20,30,40};
Write the output for the following C++ statements :
(a) cout<<M[0]; (1)
(b) cout<<M[1]+M[2]; (1)

8. (a) Expand DNS.
(b) Write the port number of DNS.

9. Compare static and dynamic web pages.

10. Classify the following Scripting languages into client side and server side :
JavaScript, PHP, ASP, VBScript

11. Write any four values of type attribute of the <INPUT> Tag in HTML.

12. Classify the following values in JavaScript into suitable data types :
“Hello”, false, 125.0, “True”

13. Compare shared hosting and dedicated hosting.

14. Write short note on Responsive web design.

15. List any four advantages of DBMS.
SY-546 2

1  6    5  .
1  . (5  1 = 5)
1. C++    ______.
(<, >, <<, >>)

2. A[10]       ?

3.   empty tag  ?
(<B>, <H1>, <HR>, <FONT>)

4.      ______   
.

5. GRANT , ______  .
(DDL, DML, DCL, )

6. ERP   .

7  18    9  .
2  . (9  2 = 18)
7. int M[ ]={10,20,30,40};
  C++   .
(a) cout<<M[0]; (1)
(b) cout<<M[1]+M[2]; (1)

8. (a) DNS   .
(b) DNS    .

9.     .

10.     ,  
 .
JavaScript, PHP, ASP, VBScript

11. HTML  <INPUT>  Type    
.
12.      
 .
“Hello”, false, 125.0, “True”
13.      .
14. Responsive web design     .

15. DBMS   4  .
SY-546 3 P.T.O.

16. What is Data Independence ? Which are the two levels of Data Independence.

17. Differentiate the data type CHAR and VARCHAR in SQL.

18. Write short note on SMS.

Answer any 9 questions from 19 to 29. Each carries 3 scores. (9  3 = 27)
19. Explain any three jump statements in C++.

20. (a) Define an array. Give one example. (1)
(b) Write declaration statement for an array “NAME” of size 25 to store the name of
a student. (1)
(c) Initialize an array “NAME” with value “Sachin”. (1)

21. Compare the function calling methods Call by value and Call by reference in C++.

22. Explain any three string functions in C++.

23. Write HTML code to display the following using list :
(1) CACHE (2) RAM (3) ROM

24. (a) Differentiate between <TD> and <TH>. (1½)
(b) List any four attributes of <TD> and <TH>. (1½)

25. Write the built-in function used in JavaScript to do the following :
(a) To find the character at a particular position. (1)
(b) To check whether the data stored in a variable is a number or not. (1)
(c) To convert the string “Covid” to “COVID”. (1)

26. Explain any three aggregate functions in SQL.

27. Write SQL query for
(a) Create a table student with the following fields :
name char(20), rollno integer, mark integer (1)
(b) Display name and rollno of all students (1)
(c) Display name and rollno of students having mark greater than 600 (1)

SY-546 4

16. Data Independence   ? Data Independence     ?

17. SQL  CHAR, VARCHAR       ?

18. SMS     .

19  29    9  .
3  . (9  3 = 27)
19. C++   3   .

20. (a)  .   . (1)
(b) “NAME”  25    
    . (1)
(c) “NAME”   “Sachin”   
 . (1)

21. C++    methods  Call by value, Call by reference 
 .

22. C++   3   .

23.     HTML  .
(1) CACHE (2) RAM (3) ROM

24. (a) <TD>, <TH>   . (1½)
(b) <TD>, <TH>      . (1½)

25.      built-in
 .
(a)     . (1)
(b)        
 . (1)
(c) “Covid”   “COVID”  . (1)

26. SQL   3   .

27. SQL  .
(a) name char(20), rollno integer, mark integer    student
  . (1)
(b)   name, rollno  . (1)
(c) 600   mark   name, rollno  . (1)

SY-546 5 P.T.O.

28. Explain any three benefits of ERP.

29. Explain any three Industrial Property Rights.

Answer any 2 questions from 30 to 32. Each carries 5 scores. (2  5 = 10)
30. (a) Identify the four components of following for loop :
for(count=1; count<=n; count++)
{
sum=sum+count;
}
cout<<“sum=” <<sum; (2)
(b) Rewrite the above code using while loop. (3)

31. (a) Explain any three text formatting Tags in HTML. (3)
(b) Write HTML code to display the following :
(i) H2O (1)
(ii) A2+2AB+B2 (1)

32. Consider the following relations :
Football
Name Age
Joseph 18
Anoop 17
Sachin 18

Cricket
Name Age
Fatima 18
Anoop 17
Vivek 16
(a) What is the degree and cardinality of the relation Football ? (1)
(b) Find the result of the following relational algebraic operations :
(i) Football U Cricket (2)
(ii) Football – Cricket (2)
______________

SY-546 6

28. ERP   3  .

29.  3   .

30  32    2  .
5  . (2  5 = 10)
30. (a)     .
for(count=1; count<=n; count++)
{
sum=sum+count;
}
cout<<“sum=” <<sum; (2)
(b)    while loop   . (3)

31. (a) HTML   3    . (3)
(b)    HTML   :
(i) H2O (1)
(ii) A2+2AB+B2 (1)

32.    .
Football
Name Age
Joseph 18
Anoop 17
Sachin 18

Cricket
Name Age
Fatima 18
Anoop 17
Vivek 16
(a) Football      . (1)
(b)      
.
(i) Football U Cricket (2)
(ii) Football – Cricket (2)
______________

SY-546 7 P.T.O.

SY-546 8

QUESTION PAPERS
GET PREVIOUS YEAR QUESTION PAPERS FOR ALL CLASSES FOR CBSE, ISCSE, ISC AND ALL ALL
STATE BOARDS HERE AT

Andhra Pradesh Board Question Papers
BOARD
WISE Assam Board Question Papers
Bihar Board Question Papers
Chhattisgarh Board Question Papers
Goa Board Question Papers
Gujarat Board Question Papers
Haryana Board Question Papers
Himachal Pradesh Board Question Papers
J&K State Board Question Papers
Jharkhand Board Question Papers
Karnataka Board Question Papers
Kerala Board Question Papers
Madhya Pradesh Board Question Papers
Maharashtra State Board Question Papers
Manipur Board Question Papers
Meghalaya Board Question Papers
Mizoram Board Question Papers
Nagaland Board Question Papers
Orissa Board Question Papers
Punjab Board Question Papers
Rajasthan Board Question Papers
Tamil Nadu Board Question Papers
Telangana State Board Question Papers
Tripura Board Question Papers
Uttarakhand Board Question Papers
Uttar Pradesh (UP) Board Question Papers
West Bengal (WB) Board Question Papers