Reviewing Kerala Syllabus Plus Two Computer Application Previous Year Question Papers and Answers Pdf March 2021 helps in understanding answer patterns.
Kerala Plus Two Computer Application Previous Year Question Paper March 2021
Time: 2 Hours
Total Score: 60 Marks
Answer the following questions from 1 to 44 upto a maximum score of 60.
Questions from (a) to (e) carry 1 score each. (5 × 1 = 5)
Question 1.
a) Write the keyword from the following :
i) area
ii) total
iii) break
iv) start
b) Name the built-in function used to copy one string into another.
c) Expand DNS.
d) A candidate key, that is not the primary key is called ____________ .
e) SIM is
i) Subscriber Identify Module.
ii) Subscriber Identify Mobile.
iii) Subscription Identification Module.
iv) Subscription Identification Mobile.
Answer:
(a) break;
(b) strcpy()
c) Domain Name System
d) Alternate Key
e) Subscriber Identity Module.
Questions from 2 to 21 carry 2 score each. (20 × 2 = 40)
Question 2.
Name any four tokens.
Answer:
Keywords, Identifiers, Literals, Punctuators, Operators (KILPO)
Question 3.
Write the syntax of for loop.
Answer:
for(initialization; test expression; update statement)
{
Body of loop;
}
Question 4.
Write any two rules for naming identifiers in C++.
Answer:
- Variable name starts with alphabet or under score.
- Digits can be used followed by a character
- Keywords cannot be used
- Special characters including white spaces cannot be used.
Question 5.
What is an array? Write the syntax to declare an array.
Answer:
An array is a collection of elements with same data type. With the same name we can store many elements. Syntax: data_type variable_name[size of the array];
Question 6.
Consider the following array:
int a[5]{4, 0, 7, 6, 1}
write the output of
i) cout <<a [2];
ii) cout <<a[4];
Answer:
1) 7
2) 1
Question 7.
Write the names of C++ built-in functions to :
i) Find the length of a string
ii) Combine two strings.
Answer:
i) strlen();
ii) strcat();
Question 8.
Name the header files needed for the functions pow() and isdigit().
Answer:
cmath and cctype
Question 9.
What is a container tag? Write an example.
Answer:
A container tag has both opening and closing tag.
Eg. <html>, <body> etc.
Question 10.
Classify the following into tags and attributes :
a) BR
b) WIDTH
c) LINK
d) IMG
Answer:
| Tags | Attributes |
| BR, IMG | WIDTH, LINK |
Question 11.
Write the purpose of <B> Tag and <U> Tag.
Answer:
<B> – To make the text bold
<U> – To make the text underline.
Question 12.
Name any two attributes of <FONT> Tag.
Answer:
Face, color, size.
Question 13.
What is a hyperlink? Which is the tag used to create a hyperlink in HTML document?
Answer:
Hyper links are used to connect two documents or two locations of the same document. <a> tag is used for the same.
Question 14.
Write the names of any two attributes of <TR> tag.
Answer:
Align, valign, bgcolor.
Question 15.
Write the names of tags used to create an ordered and un-ordered list.
Answer:
<OL> for ordered list and <UL> is used for unortlered list.
Question 16.
Write the names of any two datatypes in JavaScript.
Answer:
Number, String , Boolean(any 2)
Question 17.
What is the importance of <SCRIPT> tag in JavaScript. Write its main attribute.
Answer:
<script> tag is used to write scripts in html document. Its main attribute is lang.
Question 18.
Distinguish between CHAR and VARCHAR datatypes in SQL.
Answer:
Both are used to store characters. CHAR is used for fixed number of characters while VARCHAR is used for variable length of characters. No memory wastage in VARCHAR method.
Question 19.
Name any two constraints in SQL.
Answer:
Primary key, autoj’ncrement, not null, unique, default.
Question 20.
Write any two benefits of using ERP.
Answer:
Improved resource utilization, better customer satisfaction.
Question 21.
Explain any one cyber crime against individuals.
Answer:
Identity theft, harassment, violation of privacy, etc.
Questions from 22 to 41 carry 3 scores each. (20 × 3 = 60)
Question 22.
Write a C++ program to add two numbers.
Answer:
#include<iostream>
Using namespace std;
intmain()
{
int n1,n2,sum;
cout<<“Entertwo numbers:”;
cin>>n1>>n2;
sum=n1+n2;
cout<<“The sum of “<<n1<<“ and “<<n2<<“ is
“<<sum;
return 0;
}
Question 23.
What is the merit of using gets() function in C++ ? Which is the necessary header file to use it?
Answer:
gets() function is used to read a string with white spaces. The header file needed is cstdio.
Question 24.
Differentiate call by value and call by reference method of function calling.
Answer:
Methods of calling functions are two,
- Call by value: In call by value method the copy of the original value is passed to the function, if the function makes any change will not affect the original value.
- Call by reference: In call by reference method the address of the original value is passed to the function, if the function makes any change will affect the original value.
Question 25.
Compare static and dyngmic web pages.
Answer:
| Static web pages | Dynamic web pages |
| Content and layout is fixed | Content and layout is changed frequently |
| Never use database | Data base is used |
| Run by browser | It runs on the server and result get back to the client(browser) |
| Easy to develop | Not at all easy |
Question 26.
What are the differences between client side and server side scripts?
Answer:
| Client Side Scripting | Server Side Scripting |
| Script is copied to client browser | to the web server |
| Executed by the client | Executed by the server and result is get back to the browser window |
| Used for Client level validation | Connect to the database in the server |
| It is possible to block by the user | Cannot possible |
| Client side scripts depends the type and version of the browser | It does not depend the type and version of the browser |
Question 27.
Write the names of any three attributes of <BODY> tag.
Answer:
bgcolor, background, text, link, alink, vlink, left/right margin
Question 28.
What is a Script? Name any two server side scripting languages.
Answer:
Scripts are small programs embedded in html document. Eg.ASP,JSP, PHP
Question 29.
Which are the attributes of <OL> tag? Write their default values.
Answer:
Attributes of <OL> tags are type and start, its default value is 1.
Question 30.
Write any three attributes of <INPUT> tag.
Answer:
Attributes of input tag is name, type, value
Question 31.
What is a definition list? Which are the tags used to create definition list?
Answer:
It is used to create a list of terms and the corresponding definitions. The tags used are ,<DL>, <DT>and<DD>.
Question 32.
i) Predict the value of z in the following code :
var x, y;
x = “20”;
y = 30;
z = x + y;
ii) What are the two uses of *+’ operator in JavaScript?
Answer:
(i) here x is a string and y is an integer hence the values are concatenated. So the answer is 2030.
(ii) If one of the operands is a string then the operation is string concatenation otherwise arithmetic addition.
Question 33.
Write JavaScript functions to perform the following :
a) To check whether a value is number or not.
b) To return the upper case form of given string.
c) To return the character at a particular position.
Answer:
(a) isNaN().
(b) toUpperCase().
(c) charAt()
Question 34.
Write a short note on shared web hosting.
Answer:
Shared Hosting : This type of hosting sharing resources, like memory, disk space and CPU hence the name shared. Several websites share the same server. This is suitable for small websites that have less traffic and it is not suitable for large websites that have large bandwidth, large storage space and have large volume of traffic.
Eg: Shared hosting is very similar to living in an Apartment(Villas) complex. All residents are in the same location and must share the available resources(Car parking area, Swimming pool, Gymnasium, play ground, etc) with every one.
Question 35.
i) What is the use of FTP client software? (2)
ii) Write the name of any one FTP client software. (1)
Answer:
(i) It is used to transfer(upload) files from our computer to web server by using the ‘drag and drop’ method.
(ii) The popular FTP client soft wares are FileZilla, CuteFTP, SmartFTP, etc.
Question 36.
Describe any three advantages of using DBMS.
Answer:
Advantages of DBMS over conventional files Data Redundancy – It means duplication of data. DBMS eliminates redundancy. DBMS does not store more than one copy of the same data.
Inconsistency can be avoided – If redundancy Occurs there is a chance to inconsistency. If redundancy is removed then inconsistency cannot occur.
Efficient data access -: It stored huge amount of data efficiently and can be retrieved whenever a need arise. Data can be shared – The data stored in the database can be shared by the users or programs.
Standards can be enforced – The data in the database follows some standards. Eg: a field ‘Name’ should have 40 characters long. Some standards are ANSI, ISO, etc.
Security restrictions can be applied – The data is of great value so it must be kept secure and private. Data security means the protection of data against accidental or intentional disclosure or unauthorized destruction ormodifieation by unauthorized person. Integrity can be maintained – It ensures that the data is to be entered in the database is correct. Crash recovery – Some times all or a portion of the data is lost when a system crashes. A good DBMS helps to recover data after the system crashed.
Question 37.
Explain the different levels of data abstraction in DBMS.
Answer:
Levels of Database Abstraction –
- Physical Level (Lowest Level) – It describes how the data is actually stored in the storage medium.
- Logical Level (Next Higher Level) – It describes what data are stored in the database.
- View Level (Highest level) – It is closest to the users. It is concerned with the way in which the individual users view the data.
Question 38.
Write the names of three components of SQL.
Answer:
Components of SQL are DDL, DML and DCL.
Question 39.
Write the use of any three DML commands in SQL.
Answer:
DML commands(SUDI-Any 3)
- Select Used to select or display rows from a table. The keyword from is used with this. The Where clause is used to specify the condition.
- Update Used to modify the records in a table, the keyword used is set.
- Delete Used to delete records in a table.
- Insert Used to insert new records into a table. The keyword used is into.
Question 40.
Write the names of any three functional units of ERP.
Answer:
- Financial Module: It is the core. This is used to generate financial report such as balance sheet, general ledger, trial balance, financial statement etc.
- Manufacturing Module: It provides information for the production and capable to change the methods in manufacturing sector.
- Production planning Module : This module ensures the effective use of resources and helps the enterprise to enhance the productive hence increase the profit.
Question 41.
What are the specialities of second generation networks in mobile communication?
Answer:
It allowed voice and data transmission. Picture message and MMS were introduced. GSM and CDMA standards were also introduced by 2G.
Questions from 42 to 44 carry 5 scores each. (3 × 5 = 15)
Question 42.
Given a C++ code :
if (n = = ‘L’)
cout<<“Turn left”;
else if (n = = ‘R’)
cout<<“Turn Right”;
else
cout <<Go Straight”;
What will be the output if
i) Value of n is’R’ (1)
ii) Value of n is’S’ (1)
iii) Rewrite the code using switch case. (3)
Answer:
(i) Turn Right
(ii) Go Straight
(iii) switch(n)
{
case ‘L’:cout<<“Turn Left”;
break;
case ‘R’:cout<<“Turn Right”;
break;
default :cout<<“Go Straight”;
}
Question 43.
Write HTML program to create the following webpage:
| Name | Roll _No |
| ABC | 1 |
| PQR | 3 |
| XYZ | 4 |
Answer:
<html> <head> <title>Table creation</title> </head> <body bgcolor=”cyan”> <table border=”1"> <tr> <th>Name</th> <th>Roll_No</th> </tr> <tr> <td>ABC</td> <td>1 </td> </tr> <tr> <td>PQR</td> <td>3</td> </tr> <tr> <td>XYZ</td> <td>4</td> </tr> </table> </body> </html>
Question 44.
i) What is relational algebra in DBMS ? (2)
ii) Briefly explain about any three relational algebra operations. (3)
Answer:
i) It consists of a set of operations that takes one or two relations as input and produces a new relation as a result.
ii) A) SELECT operation
SELECT operation is used to select tuples in a relation that satisfy a selection condition. Greek letter σ (sigma) is used to denote the operation. Syntax,
σ<sub>condition</sub>(relati0n)
eg. σ<sub>salary < 10000</sub> (EMPLOYEE)-selects tuple whose salary is less than 10000 from EMPLOYEE relation.
B) PROJECT operation
PROJECT operation selects certain columns from the table and discards the other columns. Greek letter π(pi) is used to denote PROJECT operation. Syntax, π<sub>condition</sub>(relation)
eg. π<sub>name, salary</sub> (EMPLOYEE) displays only the name and salary of all employees
C) UNION operation
This operation returns a relation consisting of all tuples appearing in either or both of the two specified relations. It is denoted by U. duplicate tuples are eliminated. Union operation can take place between compatible relations only, i.e., the number and type of attributes in both the relations should be the same and also their order. e.g. SCIENCE U COMMERCE gives all the tuples in both COMMERCE and SCIENCE.