Reviewing Kerala Syllabus Plus Two Computer Application Previous Year Question Papers and Answers Pdf Board Model Paper 2022 helps in understanding answer patterns.
Kerala Plus Two Computer Application Board Model Paper 2022 with Answers
Time: 2 Hours
Total Score: 60 Marks
Part – I
A. Answer any 5 questions from 1 to 9. Each carries 1 Score. (5 × 1 = 5)
Question 1.
__________ is an example of exit controlled loop.
Answer:
do – while loop
Question 2.
What is the size of array in the following C++ declaration statement?
Answer:
10
Question 3.
What will be the output of the following C++ statement?
Answer:
7
Question 4.
Write the keyword used to declare a variable in JavaScript.
Answer:
var
Question 5.
Give one example for FTP client software.
Answer:
Filezilla / CuteFTP / SmartFTP
Question 6.
The person who is responsible for controlling Database is _____________
Answer:
DBA: Database Administrator
Question 7.
Which of the following is not a DBMS package?
i) ORACLE
ii) SQL Server
iii) MySQL
iv) HTML
Answer:
iv) HTML
Question 8.
Write an example for ERP package?
Answer:
Oracle, SAP, Odoo, Tally, MS Dynamics(Any one)
Question 9.
____________ is a technology used to send multimedia data using mobile phones.
Answer:
MMS
B. Answer all questions from 10 to 13. Each carries 1 score. (4 × 1 = 4)
Question 10.
_____________ is a library function that helps us to terminate a C++ program.
Answer:
exit()
Question 11.
Write the full form of HTTP.
Answer:
Hyper Text Transfer Protocol
Question 12.
What is a nested list?
Answer:
A list contains another list completely.
Question 13.
In DBMS, storing of same data in multiple locations is called ___________ .
Answer:
Redundancy
Part – II
A. Answer any 2 questions from 14 to 17. Each carries 2 scores. (2 × 2 = 4)
Question 14.
What is array traversal? Give one example.
Answer:
Accessing each element of array at least once to perform any operation.
Eg : Sorting
Question 15.
Write down the names of any two web hosting methods.
Answer:
Shared hosting, dedicated hosting, Virtual Private Server(VPS)
Question 16.
What is meant by constraints? Give one example.
Answer:
It ensures the correct data is entered into the database.
Eg: unique, auto_increment, primary key, not null, default, check,… (Any one)
Question 17.
Explain any two benefits of ERP.
Answer:
Benefits of ERP system
1) Improved resource utilization : Resources such as Men, Money, Material and Machine are utilized maximum hence increase the productivity and profit.
2) Better customer satisfaction : Without spending more money and time all the customer’s needs are considered well. Because customer is the king of the market. Nowadays a customer can track the status of an order by using the docket number through Internet.
B. Answer any 2 questions from 18 to 20. Each carries 2 scores. (2 × 2 = 4)
Question 18.
Give names of two parameter passing techniques in C++.
Answer:
Call by Value
Call By Reference
Question 19.
What is Content Managements System (CMS)? Write one example.
Answer:
Content Management System is a web based software system used for creating,administering and publishing website contents. Eg : Joomla, Drupal, wordpress.
Question 20.
Using example, explain the use of ORDER BY Clause of SELECT command.
Answer:
ORDER BY is used for selecting rows(records) in a sorted form. It can be acsending order(asc) or descending order(desc).
Eg.Select * from STUDENT ORDER BY Tot_Mark;
Part – III
A. Answer any 3 questions from 21 to 24. Each carries 3 scores. (3 × 3 = 9)
Question 21.
Write the names of any three fundamental data types in C++.
Answer:
void, char, int, float, double
Question 22.
Compare static and dynamic web pages.
Answer:
| Static web page | Dynamic web page |
| The content and layout of a web page is fixed. | The content and layout may change during run time. |
| Static web pages never use databases. | Database is used to generate dynamic content through queries. |
| Static web pages directly run on the browser and do not require any server side application program. | Dynamic web page runs on the server side application program and displays the results. |
| Static web pages are easy to develop. | Dynamic web page development requires programming skills. |
Question 23.
Write the data types of following values in Java Script? Java Script?
i) true
ii) -300
iii) “School”
Answer:
i. Boolean
ii. Number
iii. String
Question 24.
Name any three fundamental operations in Relational Algebra. Give their symbols also.
Answer:
SELECT (σ)
PROJECT (π)
UNION (U)
CARTESIAN PRODUCT(X)
B. Answer any 2 Questions from 25 to 27. Carries 3 scores. (2 × 3 = 6)
Question 25.
Compare break and continue statements in C++.
Answer:
break: It is used for premature termination of the loop.
continue: The statement continue is used for bye passing or skipping over a, part of the code within the loop-body and continue the iteration with next value.
Question 26.
Read the following statements:
char name[20];
cin>name;
cout<<name
i) What will be the output if you input the string “Sachin Tendulkar”? (1)
ii) Justify your answer. (2)
Answer:
i. Sachin
ii. White space is a delimiter to cin. cin will not read characters given after white space. To read the string including space gets() is used.
Question 27.
Write port numbers for the following services: (3)
i) HTTP
ii) SMTP
iii) DNS
Answer:
i. 80
ii. 25
iii. 53
Part – IV
A. Answer any 3 questions from 28 to 31. Each carries 4 scores. (3 × 4 = 12)
Question 28.
What is token in C++? Name any three tokens.
Answer:
Tokens : Basic building blocks of C++ programs. There are five tokens in C++.
- Keywords
- Identifiers
- Literals
- PUNTUATORS
- OERATORS
Question 29.
List any four built in functions in C++.
Answer:
abs(), strcpy(), strcmpQ, sqrt(), etc..
Question 30.
Which are essential tags of HTML?
Answer:
<HTML> <HEAD> <TITLE> <BODY>
Question 31.
a) ___________ is an attribute of <SCRIPT> tag. (1)
b) Write the built in functions in JavaScript for the following:
i) to display a message on screen (1)
ii) to convert uppercase to lowercase (1)
iii) to find the character at a particular position (1)
Answer:
a. Language
b. i. alert()
ii. toLowerCase()
iii. chartAt()
B. Answer any one question from 32 to 33. Each carries 4 scores. (1 × 4 = 4)
Question 32.
Write down the uses of following tags:
i) <SELECT>
ii) <FIELDSET>
Answer:
i. used for making drop down list box(combo box)
ii. used for grouping form controls
Question 33.
Write short note on any two examples of Cyber Crimes against individuals.
Answer:
Cyber crimes against individuals
i) Identity theft: The various information such as personal details(name, Date of Birth, Address, Phone number etc), Credit / Debit Card details(Card number, PIN, Expiry Date, CW, etc), Bank details, etc. are the identity of a person. Stealing these information by acting as the authorized person without the permission of a person is called Identity theft. The misuse of this information is a punishable offence.
ii) Harassment: Commenting badly about a particular person’s gender, colour, race, religion, nationality, in Social Media is considered as harassment. This is done with the help of Internet is called Cyber stalking (Nuisance). This is a kind of torturing and it may lead to spoil friend ship, career, self image and confidence. Sometimes may lead to a big tragedy of a whole family or a group of persons.
iii) Impersonation and cheating: Fake accounts are created in Social Medias and act as the original one for the purpose of cheating or misleading others. Eg: Fake accounts in Social Medias (Facebook, Twitter,etc), fake smi, fake emails etc..
iv) Violation of privacy: Trespassing into another person’s life and try to spoil the life. It is a punishable offence. Hidden camera is used to capture the video or picture and black mailing them.
v) Dissemination of obscene material: With the help of hidden camera capture unwanted video or picture. Distribute or publish this obscene clips on Internet without the consent of the victims may mislead the people specifically the youngerones.
Part – V
Answer any 2 questions from 34 to 36. Each carries 6 scores. (2 × 6 = 12)
Question 34.
Write the HTML code to generate the following table:
| Roll | Name | Class |
| 100 | AB | C2 |
| 101 | PQ | C1 |
| 102 | XY | A1 |
Answer:
<HTML> <HEAD> <TITLE>TABLE</TITLE> <BODY bgcolor=”red”> <TABLE border= 1> <TR align=”center”> <TH> Roll </TH> <TH> Name </TH> <TH> Class </TH> </TR> <TR align=”center”> <TD> 100 </TD> <TD> AB <7TD> <TD> C2 </TD> </TR> <TR align=”center”> <TD> 101 </TD> <TD> PQ </TD> <TD> C1 </TD> </TR> <TR align=”center”> <TD> 102 </TD> <TD> XY </TD> <TD> A1 </TD> </TR> </TABLE> </BODY> </TABLE>
Question 35.
a) Define the following terms of RDBMS: (4)
i) Tuple
ii) Relation
iii) Degree
iv) Cardinality
b) Write down the Degree and Cardinality bf the following relation: (2)
| Regno | Name | Mark |
| 101 | Sachin | 380 |
| 103 | Fathima | 420 |
| 106 | Bincy | 400 |
| 108 | Joseph | 350 |
Answer:
tuple: record or row of a table
relation : table is known as a relation
degree (cd): number of columns or attributes in a table
cardinality (rc): number of rows or tuples in a table
b. Degree: 3
Cardinality; 4
Question 36.
a) Pick the odd one out from the following: Given reason also. (2)
i) CREATE
ii) SELECT
iii) UPDATE
iv) DELETE
b) Consider the given relation ITEMS.
| Itemcode | Name | Price |
| 001 | Pencil | 8.00 |
| 002 | Pen | 10.00 |
| 003 | Notebook | 15.00 |
| 004 | Pen | 12.00 |
i) Suggest a suitable primary key for the above relation. Give reason. (2)
ii) Write SQL statement to list all the items in the table. (1)
iii) Write SQL statement to list itemcode and name of all itmes. (1)
Answer:
a. CREATE:DDL command others are DML commands
b. i. Itemcode : it does not have duplicate values. Itemcode is unique.
ii. SELECT * FROM ITEMS;
iii. SELECT Itemcode, Name from ITEMS;