Kerala Plus Two Computer Application Model Question Paper 3
Time: 2 Hours
Cool off time: 15 Minutes
Maximum: 60 Scores
- There is a ‘cool off time’ of 15 minutes in addition to the writing time of 2 hrs.
- Use the ‘cool off time’ to get familiar with the questions and to plan your answers.
- Read questions carefully before you answering.
- Read the instructions carefully.
- Calculations, figures and graphs should be shown in the answer sheet itself.
- Malayalam version of the questions is also provied.
- Give equations wherever necessary.
- Electronic devices except non programmable calculators are not allowed in the Examination Hall.
Answer all questions from 1 to 5
Character array is also called ……………..
What is a Form handler?
What is the basic protocol followed in internet communication?
SAP stands for …………..
Define enterprise resource planning.
Answer any nine questions from 6 to 16
Write the output of the following web page and justify your answer.
var x, y, z;
x = “10”;
y = “20”;
z = x + y;
Categorize the following tags into container tags and empty tags.
Mention any two values of Type attribute and explain its use in the form.
How is responsive web design implement-ed?
a. What is responsive web design?
b. Why is it gaining importance recently?
Explain about sophisticated user.
What is the importance of primary key in a table?
Write a short note about any two ERP solution providers.
“Infomania has become a psychological problem”. Write your opinion.
What is a smart card? How it is useful?
What do you mean by big data in business? Explain big data analytics.
Answer any nine questions from 17 to 27
Consider the following program:
Using namespace std;
int main ( )
for (int i=1; i<10; i+ + )
if (i % 2 = = 0)
Predict the output of the program. Justify your answer?
Rewrite the following C++ code using switch statement.
else if (choice== ‘C’)
cout< <“ Commerce”;
else if (choice== ‘H’)
The prototype of p function is: W fun(int, int); The following function calls are invalid. Give reason for each.
Discuss the scope of global and local variables.
In HTML how can we divide a browser window?
Aliya wants to display three web pages (A.htm, B.htm, C.htm) on the same scre¬en horizontally at the ratio 20%, 40%, 40%. Write the HTML code for the same.
Write a note on procedures.
What are the advantages of views in MySQL
What is copyright? How does it differ from patent?
Write a function which accepts an integer value as an argument and calculate its factorial. Call this function from main ( ) and print the result in main ( ).
Answer any two questions from 28 to 30
Read the following C++ code segment and replace it with a looping statement:
What are scripts? Explain the different scripting languages.
A form handler is a program on the web server that manage the data sent through the form.
Systems, Applications and Products
Enterprise Resource Planning (ERP) is business process management software that allows an organization to use a system of integrated applications to manage the business and automate many back office functions related to technology, services and human resources.
It will display 1020. Operator + is used to add two strings. Adding two string means concatenating two strings. If the operands are numbers, it will add the numbers. If the operands are strings it will concatenate the strings. If + operator sees any one operand as string, it will treat both the operands as string type and concatenate the strings.
Empty tag: <FRAME>, <INPUT>
Container tag <FRAMESET>, <A>
Values of type attribute is radio, check box. Radio button: Used to select a single value from a group of values. Check box: It is useful for accepting Yes/ No inputs from the viewers.
It can be implemented using flexible grid layout, flexible images and media queries. Flexible grid layouts set the size of the en-tire web page to fit the
display size of the device. Flexible images and videos set the image/ video dimensions to the percentage of display size of the device. Media queries provide the ability to specify defferent styles for individual devices.
a. Responsive web design is the custom of building a website suitable to work on every device.
b. Today people visit websites using tablets and mobile phones/proper display of websites in devices.
Sophisticated users include engineers, scientists, business analysts and others who are thoroughly familiar with the facilities of the DBMS. They interact with the systems through their own queries (a re-quest to a database) to meet their complex requirements.
Primary key is a set of one or more attributes that can uniquely identify tuples within the relation. It cannot contain null value and duplicate value.
Oracle: Head quarters at Redwood shores, California, USA. Oracle was working for its database rather than ERP. Oracle is famous for its finance and accounting module. It also provide Customer Relationship Management (CRM) software and Supply Chain management software (SCM). Tally ERP: Indian company with head quarters at Banglore. Provide ERP solution for accounting, inventory and payroll.
Infomania may result in neglecting the .more important things like duties, family, etc. It is now treated as a psychological problem. Constantly checking e-mails, social networking sites, online news, etc. are the symptoms of infomania. Studies prove that people addicted to infomania lose concentration and sleep.
It is a plastic card with a computer chip or memory that stores and transacts data. A smart card (may be like an ATM card) reader used to store and transmit data. The advantages of smart card is that it is secure, intelligent and is easy to carry.
Big data analytics is the process of examining large data sets containing a variety of data types to uncover hidden patterns, market trends, customer preferences and useful business information. Big data analytics provide an opportunity for business firms to answer questions that were previously considered beyond their reach. This opened the doors to a new world of possibilities to interact effectively with the customer, with the knowledge of his preferences.
The output is 113579. continue statement is used for skipping over depart of the code within the loop-body anchforcing the next iteration.
case ‘S’: cout<<“Science”; break;
case ‘C’: cout<<“Commerce”; break;
case ‘H’: cout<<“Humanities”; break;
default : cout<<“lnvalid Option”;
a. The variable is not receive the value returned by fun( );
Correct is val = fun(2,4);
b. No arguments are used with function call.
c. Arguments in function call are not int type.
val = fun(2,3);
Scope of local variables:
- Declared within a function or a block of statements.
- Available only within that function or block.
- Memory is allocated when the function or block is active and freed when the execution of the function or block is completed.
Scope of global variables:
- Declared outside all the functions.
- Available to all the functions of the program.
- Memory is allocated just before the ex-ecution of the program and freed when the program stops execution.
The browser window can be divided into two or more panes to accommodate different pages simultaneously. HTML provides a facility called frameset to partition the browser window into different sections. Each section accommodates different HTML pages. Each individual section created by a frameset is called a frame. To create a frameset, we can use <FRAMESET> and <FRAME> tags.
<FRAMESET ROWS = “20%, 40%, 40%”>
<FRAME Src= “A.htm”>
<FRAME Src= “C.htm”>
Number: 67.4, .98
String: “Welcome’’, “123”, “true”, “hello”
Procedures refer to the instructions and rules that govern the design and use of database. The users of the system and the person that manages the database require documented procedures on how to use or run the system. These consist of instruction on how to:
- log onto the DBMS.
- use a particular DBMS facility or application program.
- start and stop the DBMS.
- make backup copies of the database or handle hardware or software failures.
- reorganise the database across multiple disks, improve performance or archive data to secondary storage.
- Without sparing extra storage space, we can use the same table as different tables (but virtual).
- The views implement sharing along with privacy.
- It also helps to reduce the complexity of conditions with WHERE clause while retrieving, updating or deleting records from tables.
Copyright: It is a legal right given to the creators for an original work, usually for a limited period of time. The general rule is that the copyright lasts for 60 years after the death of the last surviving author. Registration of copyright gives a legal status to a creative work.
Patents: It is the exclusive rights granted for an invention. The term of every patent India is 20 years from the date of patent application. Once a patent expires, the protection ends and an invention can be used by the public freely.
# include<iostream> using namespace std; int fact(int);
int main( )
int n, r;
cout«“Enter the value:”;
r = fact(n);
int fact(int N)
for(f = 1; N>0; N- -) f = f*N; return f;
# include <iostream> using namespace std; int main( )
int n, r, s = 0; cout<<“Enter the number: cin>>n; while(n!= 0)
r = n % 10; s = (s * 10)+ r; n = n/10;
cout«“The reverse of the number is”
Scripts are program codes written inside HTML pages. They are written using a text editor like notepad. Scripting languages are:
VBScript: It is a scripting language developed by Microsoft Corporation based on the popular programming language Visual Basic.
PHP: It is an open source general-purpose scripting language that is suited for web development and can be embedded into HTML code. It is a server side scripting tool. The main objective of PHP is to develop dynamic web pages at ease.
Java Server Pages (JSP): It is a technology provides a simple and fast way to create dynamic web content. It uses Java as programming language. JSP files have the extension .jsp. To run JSP,. Apache Tomcat web server is required
- Arithmetic operators: It contains +, -, *, /, %, + +, – -operators.
- Assignment operators: =, + = , -=, *=,/=,%= are assignment operators.
- Relational operators (Comparison operators): The relational operators are = = , !=, <, <=, >, >=. The result of a relational operation is either true or false. These operators compare the values on the two side of the operator and give the result accordingly.
- Logical operators: &&, ∥ ! are logi-cal operators.
- String addition operator (+): Opera-tor + is used to add two strings. Adding two string means concatenating two strings.