Plus Two Computer Application Previous Year Question Paper Say 2018

Kerala State Board New Syllabus Plus Two Computer Application Previous Year Question Papers and Answers.

Kerala Plus Two Computer Application Previous Year Question Paper Say 2018 with Answers

Board	SCERT
Class	Plus Two
Subject	Computer Application
Category	Plus Two Previous Year Question Papers

Time: 2 Hours
Cool off time : 15 Minutes

General Instructions to candidates

There is a ‘cool off time’ of 15 minutes in addition to the writing time of 2 hrs.
Your are not allowed to write your answers nor to discuss anything with others during the ‘cool off time’.
Use the ‘cool off time’ to get familiar with the questions and to plan your answers.
Read questions carefully before you answering.
All questions are compulsory and only internal choice is allowed.
When you select a question, all the sub-questions must be answered from the same question itself.
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.

Part – A

Answer all questions from 1 to 5. Each question carries 1 score. (5 × 1 = 5)

Question 1.
Write the name of the built-in function of C++ to convert the given character into its lower case.
Answer:
tolower()

Question 2.
Which is the tag used to create a line break in an HTML page?
Answer:

Question 3.
A candidate key that is not a primary key is called the _______ key.
Answer:
alternate key

Question 4.
Which is the keyword used in the SQL SELECT command to eliminate duplicate values in the selection.
Answer:
distinct

Question 5.
Expand the term CDMA.
Answer:
Code Division Multiple Access

Part – B

Answer any 9 questions from 6 to 16. Each question carries 2 scores. (9 × 2 = 18)

Question 6.
Write the function prototype for the following function:

A function sum( ) takes two integer arguments and returns integer value.
A function print() has no argements and nonreturn value.

Answer:

int sum(int, int);
void print();

Question 7.
Differentiate actual arguments and formal arguments in C++.
Answer:
The argument that present in the called function is called the formal argument and it is present in the calling function is called an actual argument. The data type of both is the same.

Question 8.
Write the output of the following HTML code:
<OL Type = “I” Start = “10”>
<LI> keyboard </LI>
<LI> mouse </LI>
<LI> light pen </LI>
Answer:
10. keyboard
11. mouse
12. light pen

Question 9.
Describe any four values of Type attributes of the <INPUT> Tag in HTML.
Answer:
<Input> It is used to create input controls. Its type of attribute determines the control type.
Main values of the type attribute are given below.

Text – To create a text box.
Password – To create a password text box.
Checkbox – To create a check box.
Radio – To create a radio button.
Reset – To create a Reset button.
Submit-To creates a submit button.
Button – To create a button

Question 10.
Write a short note on a virtual private server.
Answer:
Virtual Private Server (VPS): A VPS is a virtual machine sold as a service by an Internet hosting Service. A VPS runs its own copy of an OS (Operating System) and customers have super level access to that OS instance, so they can install almost any s/w that runs on that OS. This type is suitable for websites that require more features than shared hosting but fewer features than dedicated hosting.

Question 11.
Define primary key and alternate key.
Answer:
Primary key – It is a set of one or more attributes used to uniquely identify a row.
Alternate key – A candidate key other than the primary key.

Question 12.
Write a short note on UNION operation in Relational algebra.
Answer:
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.

Question 13.
Differentiate the data type CHAR and VARCHAR in SQL.
Answer:
Char – It is used to store a fixed number of characters. It is declared as char (size).
Varchar – It is also used to store characters but it uses only enough memory.
the char data type is fixed length. It allocates maximum memory and maybe there is a chance of memory wastage. But Varchar allocates only enough memory to store the actual size.

Question 14.
Write a short note on Supply Chain Management.
Answer:
Supply Chain Management (SCM): This deals with moving raw materials from suppliers to the company as well as finished goods from the company to customers. The activities include are inventory (raw materials, work in progress, and finished goods) management, warehouse management, transportation management, etc.

Question 15.
Write a short note on the mobile operating system.
Answer:
Mobile Operating System: It is an OS used in handheld devices such as smartphones, tablets, etc. It manages the hardware, multimedia functions, Internet connectivity, etc. Popular OSs are Android from Google, iOS from Apple, BlackBerry OS from BlackBerry, and Windows Phone from Microsoft.

Question 16.
Define the following term:

Answer:

The network is identified using the SIM (Subscriber Identity Module).
Multimedia Messaging Service (MMS): It allows sending Multi-Media (text, picture, audio, and video file) content using mobile phones. It is an extension of SMS.

Part – C

Answer any 9 questions from 17 to 27. Each carries 3 scores. (9 × 3 = 27)

Question 17.
Rewrite the following C++ code using the if…else statement:

switch (choice)
{
Case 1:
cout<<"one";
break;
case 0:
cout<<"zero";
break;
default;
cout<<"End"
break;
}
Answer:
if(choice==1)
cout<<“One”;
else if (choice==0)
cout<<“Zero”;
else
cout<<“End”;

Question 18.
Write the output of the following C++ code. Justify your answer.

for(i=1; i<5; i++)
{
cout<<“\t”<<i;
if(i==3)
break;
}

Answer:
This prints 1 2 3. This is because the value of i becomes ‘3’ then the break statement executes, it terminates the loop and hence the output.

Question 19.
Consider the following C++ code :
a) char name [20];
cin>>name;
cout<<name;
b) char name [20];
gets (name);
cout<<name;
Write the output in both cases if the string entered value is “NEW DELHI”. Justify your answer.
Answer:
a) The output is New. This is because of cin operator reads up to the delimiter space. The characters after space will not be read.
b) The output is New Delhi. This is because of the gets() function reads characters upto the user press the enter key, including space.

Question 20.
Define array traversal with an example.
Answer:
Traversal: All the elements of an array is visited and processed is called traversal
Eg:

#include<iostream>
using namespace std;
int main()
{
int n[10], i, sum=0;
for(i=0; i<10; i++)
{
cout<<“Enter value for number”<<i+1<<":";
cin>>n[i];
if(n[i]%5==0)
sum+=n[i];
}
cout<<"The sum of numbers which are exact multiple of 5 is "<<sum;
}

Question 21.
Consider the following function definition in C++:

void sum (int a, int b=10, int c=20)
{
int sum = a + b + c;
cout<<sum:
}

Write the output of the above code for the following function call:
(a) sum (1, 2, 3);
(b) sum (2, 3);
(c) sum (3);
Answer:
a) 6
Here a = 1, b = 2 and c = 3
So the answer is 6

b) 25
Here a = 2, b = 3 and c = 20 (The default value)
So the answer is 25

c) 33
Here a = 3, b = 10 and c = 20 (Default values for b and c)
So the answer is 33

Question 22.
Compare client-side scripting and server-side scripting.
Answer:

Client-Side Scripting	Server Side Scripting
The script is copied to the client browser	The script is copied to the webserver
Executed by the client	Executed by the server and result gets 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 on the type and version of the browser	It does not depend on the type and version of the browser

Question 23.
Write the HTML code to generate the following table:

Roll No	Name	Class
100	Vishnu	C1
101	Anupama	C2
102	Biju	A1

Answer:

<html>
<head>
<title>
Table creation
</title>
</head>
<body bgcolor="red">
<table border="1">
<tr align="center">
<th>Roll No</th>
<th> Name</th>
<th> Class</th>
</tr>
<tr align="center">
<td>100</td>
<td> Vishnu</td>
<td> C1</td>
</tr>
<tralign="center">
<td>101</td>
<td> Anupama</td>
<td> C2</td>
</tr>
<tralign="center">
<td> 102</td>
<td> Biju</td>
<td> A1 </td>
</tr>
</table>
</body>
</html>

Question 24.
Classify the following values in JavaScript into suitable data type:
“Hello”, False, 125.0, 148, “True”, True
Answer:
String – “Hello”, “True”
Numeric – 125.0,148
Boolean – False, True

Question 25.
What is Content Management System? Write any two popular CMS software.
Answer:
Content Management System(CMS): CMS is a collection of programs that is used to create, modify, update, and publish website contents. CMS can be downloaded freely and is useful to design and manage attractive and interactive websites with the help of templates that are available in CMS. WordPress, Joomla, etc. are examples of CMS.

Question 26.
Define the following terms:

Cardinality
Schema
Tuple

Answer:

Cardinality – The number of rows.
Schema – The structure of the table is called the schema.
Tuple means the rows.

Question 27.
Explain any three benefits of the ERP system.
Answer:
Benefits of ERP system
1. Improved resource utilization: Resources such as Men, Money, Material, and Machine are utilized maximum hence increase productivity and profit.

2. Better customer satisfaction: Without spending more money and time all the customer’s needs are considered well. Because the customer is the king of the market. Nowadays a customer can track the status of an order by using the docket number through the Internet.

3. Provides accurate information: Right information at the right time will help the company to plan and manage the future cunningly. A company can increase or reduce production based upon the right information hence increase productivity and profit.

4. Decision-making capability: Right information at the right time will help the company to take a good decisions.

5. Increased flexibility: A good ERP will help the company to adopt good things as well as avoid bad things rapidly. It denotes flexibility.

6. Information integrity: A good ERP integrates various departments into a single unit. Hence reduce the redundancy, inconsistency, etc.

Part – D

Answer any 2 questions from 28 to 30. Each question carries 5 scores. (2 × 5 = 10)

Question 28.
Consider the following HTML code and answer the following:
 COMPUTER 
 APPLICATION <HR>
(a) Name the tag used to make the text as italics and bold in the above code. (1)
(b) What is the purpose of <HR> tag? Explain its any two attributes. (2)
(c) Write the HTML statement to scroll the text given in from top to bottom. (2)
Answer:
a) for Italics or is used
for bold or is used
b) <HR> is used to draw a horizontal line. Its attributes are size, width, shade, and color.

c) <html>
<head>
<title>
Demo of Marquee
</title>
</head>
<body bgcolor="red">
<marquee direction="down">
<em>hi welcome to BVM</em>
</marquee>
</body>
</html>

Question 29.
Consider the following JavaScript code:

function print ()
{
var i,
for (i=1; i<=10; ++i)
{
document.write(i);
document.write("<<BR>");
}
}

(i) Write the output of the above code. (1)
(ii) Rewrite the above code using a while loop. (2)
(iii) Modify the above code to find the sum of first 10 counting numbers. (2)
Answer:
i) It prints 1 to 10 line by line

ii) function Print()
{
var i;
i=1;
while(i<= 10)
{
document.write(i);
document.write (" <BR> ");
i++;
}
}

iii) function Print()
{
var i, sum=0;
for(i=1; i<=10; i++)
sum=sum+i;
document.write("The sum of first 10 countimg numbers is "+sum);
}

Question 30.
Define constrain. Explain any four-column constraints.
Answer:
Constraints are used to ensure database integrity.

Not Null – It ensures that a column can never have NULL values.
Unique – It ensures that no two rows have the same value in a column.
Primary key – Similar to unique but it can be used only once in a table.
Default – We can set a default value.
Auto_increment – This constraint is used to perform auto_increment the values in a column. That automatically generates serial numbers. Only one auto_increment column per table is allowed.