Plus Two Computer Application Previous Year Question Paper March 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 March 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.

Questions 1 – 5 Carry 1 Score each. Answer all questions. (5 × 1 = 5)

Question 1.
Name any two data type modifiers in C++
Answer:
short, long, signed, and unsigned (Any 2)

Question 2.
Define the term ‘array traversal’.
Answer:
Traversal: All the elements of an array is visited and processed is called traversal

Question 3.
Which tag is used for hyperlinking in HTML?
Answer:
<A> tag

Question 4.
What is SCM?
Answer:
Supply Chain Management (SCM): This is deals with moving raw materials from suppliers to the company as well as finished goods from the company to customers.

Question 5.
Write the full form of OFDMA.
Answer:
OFDMA(Orthogonal Frequency Division Multiple Access)

Questions 6 to 16 carry 2 score each. Answer any 9 questions. (9 × 2 = 18)

Question 6.
Write a C++ statement to declare and initialise an array in the following situations.
a) An array of 5 unit prices 18.50, 27.5, 19.00, 12.50, 10.75
b) An array with the letters ‘WELCOME’.
Answer:
float price[]={18.50, 27.5, 19.00, 12.50, 10.75};

Question 7.
Write the output of the following C++code
1) char S1[10], S2[10]=”welcome’;
strcpy(S1, S2);
cout<<S1;
2) char S1[20]=”welcome”;
char S2[20]=”toC++”;
strcat(S1, S2);
cout<<S1;
Answer:
1) welcome
2) welcome to C++

Question 8.
Differentiate ‘static’ and ‘dynamic’ webpages.
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 9.
Name any two attributes of <html>tag with the use
Answer:
Attributes of <HTML> are dir(direction ltr or rtl) and Language

Question 10.
What is the use of FTP client software?
Answer:
By using FTP client s/w we can transfer(upload) the files from our computer to the web server by using the ‘drag and drop’ method. The popular FTP client software is FileZilla, CuteFTP, SmartFTP, etc.

Question 11.
Define the following terms in DBMS

  1. Cardinality
  2. Domain

Answer:

  1. Cardinality – The number of rows in a table is the cardinality.
  2. Domain – The pool of possible values from which actual column values are drawn.

Question 12.
Categorise the following SQL commands into DDL and DML
[CREATE, INSERT, ALTER, UPDATE]
Answer:

DDL DML
CREATE
ALTER
INSERT
UPDATE

Question 13.
What is BPR?
Answer:
Business Process Re-engineering: In general BPR is the series of activities such as rethinking and redesign the business process to enhance the enterprise’s performance such as reducing the cost (expenses), improve the quality, prompt, and speed(time-bound) service.
BPR enhances the productivity and profit of an enterprise.

Question 14.
Explain the role of “System testing” in the implementation of ERP.
Answer:
Testing: This phase is very important. It determines whether the system produces a proper results. Errors in design and logic are identified.

Question 15.
What is the use of RFID?
Answer:
RFID(Radio Frequency Identification) tag and the reader. It is like the bar code. The RFID tag contains all the details of a product and it consists of a combination of a transmitter and a receiver. This tag is used in Vehicles as a prepaid tag and makes the payments easier in Toll booths. Similarly, it is useful to takeoff the Census of wild animals also.

Question 16.
Compare GPRS and EDGE technologies.
Answer:
GPRS (General Packet Radio Services): It is a packet-oriented mobile data service on the 2G on GSM. GPRS was originally standardized by European Telecommunications Standards Institute (ETSI) GPRS usage is typically charged based on the volume of data transferred. Usage above the bundle cap is either charged per megabyte or disallowed.

EDGE(Enhanced Data rates for GSM Evolution): It is three times faster than GPRS. It is used for voice communication as well as an internet connection.

Questions 17 to 27 carry 3 scores each. Answer any 9 questions. (9 × 3 = 27)

Question 17.
Write the output of the following code segment in C++.

int sum=0;
int a[]={1, 2, 3, 4, 5};
for(int i=0; i<5; i=i+2)
sum=sum+a[i];
cout<<sum;

Answer:
The output is 9. (The sum of 1, 3, and 5).

Question 18.
Explain the use of the following built-in functions in C++.
(i) abs()
(ii) sqrt()
(iii) pow()
Answer:
i) abs(): It returns the absolute value of the given number.
eg. abs(-23) returns 23.

ii) sqrt(): It returns the square root of the given number.
eg. sqrt(16) returns 4.

iii) pow(): It is used to find the power of a given number.
eg. pow(5, 2) returns 25.

Question 19.
Compare call by value and call by reference method in C++.
Answer:

Call by Value Call by Reference
1. Ordinary variables are used as a formal parameters. 1. Reference variables are used as formal parameters.
2. A copy of the original value is passed 2. The original value is passed
3. Any change made by the function will not affect the original value. 3. Any change made by the function will affect the original value.
4. Separate memory location is needed for actual and formal variables. 4. Memory of actual arguments is shared by formal arguments.

Question 20.
Write a short note on “Java Server Pages”.
Answer:
Java Server Pages (JSP)

  1. JSP introduced by Sun Micro System
  2. JSP stands for Java Server Page.
  3. An JSP file uses .jsp extension
  4. It is platform-independent
  5. It uses Apache Tomcat webserver
  6. JSP binds with Servlets (Servlets are Java codes run in Server to serve the client requests).

Question 21.
Name the three attribute of <MARQUEE> with its use
Answer:
Attributes of <MARQUEE> (Any Three)

Height – Sets the height of the Marquee text

Width – Sets the width of the Marquee text

Direction – Specifies the scrolling direction of the text such as up, down, left or right

Behavior – Specifies the type such as Scroll,
Slide(Scroll and stop) and alternate(to and fro).
<marquee behavior=”scroll”
scrollamount=”100″>hello</marquee>
<marquee behavior=”slide”
scrollamount=”100″>hello</manquee>
<marquee behavior=”alternate”
scrollamount=”100″>hello</manquee>

Scrolldelay – Specifies the time delay in seconds between each jump.

scrollamount – Specifies the speed of the text

loop – This specifies the number of times the marquee scroll. Default infinite.

bgcolor – Specifies the background colour.

Hspace – Specifies horizontal space around the marquee

Vspace – Specifies vertical space around the marquee

Question 22.
Consider the following JavaScript Code.

<SCRIPT language="JavaScript">
var i, s;
for (i=1; i<10; i++)
{
s=i*i;
document.write(s);
document.write("<BR>");
}
</SCRIPT>

a) What will be the output of the program.
b) What is the use of <SCRIPT> tag
c) Write the output statement used in the above code.
Answer:
a) The Output is
1
4
9
16
25
36
49
64
81
100
b) <SCRIPT> tag is used to write scripts
c) document.write(s) is the output statement used in the code.

Question 23.
Explain three types of “Web hosting”.
Answer:
Types of web hosting
Various types of web hosting services are available. We can choose the web hosting services according to our needs depends upon the storage space needed for hosting, the number of visitors expected to visit, etc.

1) Shared Hosting: This type of hosting shares 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 a 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, playground, etc) with everyone.

2) Dedicated Hosting: A web server and its resources are exclusively for one website that has a large volume of traffic means a large volume of requests by the visitors. Some Govt, departments, or large organizations require uninterrupted services for that round the clock power supply is needed. It is too expensive but it is more reliable and provides good service to the public.
Eg: It is similar to living in an Our own house. All the resources in your house are only for you. No one else’s account resides on the computer and would not be capable of tapping into your resources.

3) 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 less features than dedicated hosting.
Eg: It is similar to owning a Condo

Question 24.
Distinguish Alternate key and foreign key.
Answer:
Alternate key – A candidate key other than the primary key.
Foreign key – A single attribute or a set of attributes, which is a candidate key in another

Question 25.
Explain the different levels of data abstraction in DBMS.
Answer:
Levels of Database Abstraction:

  1. Physical Level (Lowest Level) – It describes how the data is actually stored in the storage medium.
  2. Logical Level (Next Higher Level) – It describes what data are stored in the database.
  3. View Level (Highest level) – It is closest to the users. It is concerned with the way in which the individual users viewthe data.

Question 26.
Explain any three-column constraints in SQL.
Answer:
Constraints are used to ensure database integrity.

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

Question 27.
Consider the table ITEM with the field Item code, Item name, Price, Write SQL queries.

  1. To Display the maximum and minimum price of items.
  2. To remove all records where priced < 1000
  3. To display the number of records in the table.

Answer:

  1. select max(Price), min(Price) from ITEM;
  2. delete from ITEM where Priced<1000;
  3. select count(*) from ITEM;

Questions from 28 – 30 carry 5 scores. Answer any 2 questions. (5 × 2 = 10)

Question 28.
Consider the C++ program to find the sum of the first 10 natural numbers and answer the following questions.

#include<iostream>
using namespace std;
int main()
{
int n, sum=0;
for(int i=1; i<=10; i++)
sum=sum+i;
cout<<"sum is="<<sum
}

a) Rewrite the above program using do-while loop.
b) What will be the output of the above program if we replace i++ with i=i+2 in the for loop
c) What is the purpose of #include<iostream>
Answer:

a) #include<iostream>
using namespace std;
int main()
{
int i=1 ,sum=0;
do
sum=sum+i; i++;
}
while(i<=10);
cout<<"sum is="<<sum;
}

b) The output is 25(Sum of odd numbers less than 10).
c) This statement is used to include the header file iostream in our program. This header file helps to include i/o operations on characters and strings in the programs.

Question 29.
a) Name the HTML tag to create checkbox, textbox, and radio box.
b) Write an HTML statement to create the textbox with a maximum length of 25 and size of 30.
c) Write an HTML statement to create a submit button with the caption “login”.
Answer:
a) checkbox-<inputtype=”checkbox>
text box-:<input type=”text”>
radio box-:<inputtype=”radio”>

b) <input type=”text” name-“Firstname” size=30 maxlength=”25″>

c) <input type=”button” value = “Login” onClick=”lengths()”>

Question 30.
Consider the javascript code to display the square of the first 10 numbers using the code answer the following.

<SCRIPT language="Javascript">
var i, s;
for (i=1; i<10; i++)
{
s=i*i;
document.write(s);
document.write("<BR>");
}
</SCRIPT>

a) Rewrite the above program using a while loop.
b) Modify the above program to print the first 10 even numbers.
Answer:

a) <SCRIPT language="Javascript">
var i, s; i=1;
while(i<=10)
{
s=i*i;
i++;
document.write(s);
document.write("<BR>");
}
</SCRIPT>

b) <SCRIPT language="Javascript">
var i;
for(i=2; i<=20; i+=2)
{
document.write(i);
document.write("<BR>");
}
</SCRIPT>