Plus Two Computer Science Model Question Papers Paper 1

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

Kerala Plus Two Computer Science Model Question Papers Paper 1 with Answers

 Board SCERT Class Plus Two Subject Computer Science 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.
• 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.

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

Question 1.
The blueprint or prototype that defines the properties and behaviour of similar objects is called ________
class

Question 2.
Write an example of dynamic data structure.
stack or queue or linked list

Question 3.
Which is the default port number of HTTP service?
80

Question 4.
The attribute required in the <A> tag for internal linking is ________
<a href=”#Top”>.
Here href is the attribute and # symbol is essential for internal linking.

Question 5.
SFTP stands for __________
Secure Shell File Transfer Protocol

Answer any nine questions from 6 to 16 (2 scores each)

Question 6.
What are the differences between array and structure in C++?

 Structure Array 1. It is a user-defined data type 1. Predefined data type 2. It is a collection of different types of logically related data under one name. 2. Collection of data elements of the same data type having a common name. 3. Elements referenced using dot operator(.) 3. Elements reference using its subscripts (position value) 4. When an element of a structure becomes another structure nested structure and complex structures are formed 4. When an element of another becomes another array, multidimensional arrays are formed. 5. Structure contains array as its elements. 5. Array of structure can be formed.

Question 7.
How can you create a dynamic array of size N, if N is inputted by the user?
int *ptr=new int[N];

Question 8.
What is the advantage of circular queue over linear queue?
As the name implies logically the shape of the circular queue is a shape of a circle, The linear queue has some limitations such as some occasions the capacity of the linear queue cannot be used fully. The limitation of the linear queue can overcome by circular queue. Circular queue is a queue in which the two endpoints are connected.

Question 9.

Question 10.
Correct the javascript code fragment given below to display the value entered in the text box.

<form Name =‘myform’>
<input a number <input type = “text” name=num>
<input type = “button” value = “check” .........>
</form>
function Myform()
{
num= .........;
}

The correct code is as follows:

<html>
<Script Language="JavaScript">
function Myform()
{
var num;
num=document.myform.num.value;
}
</script>
<body>
<center>
<form name="myform">
input a number
<inputtype="text" name="num">
<input type="button" value="check"
Click="Myform()">
</form>
</center>
</body>
</html>

Question 11.
Write any two mouse events in javascript and its description.

1. onClick() – This event occurs when the user clicks on an object by using mouse
2. onMouseEnter() – This event occurs when the mouse pointer is moved onto an object.

Question 12.
Write short notes on primary key and foreign key.
Primary key – It is a set of one or more attributes used to uniquely identify a row.
Foreign key – A single attribute or a set of attributes, which is a candidate key in another table is called a foreign key.

Question 13.
Consider the given table PRODUCT and answer the following questions in relational algebra.
a) Select all details of product where quantity is above 60 (1 score)
b) Select Pname and Quantity (1 score)

 PIN Pname Quantity Amount 1 Pen 20 40 2 Pencil 30 80 3 Eraser 70 90 4 Sharpner 90 120

a) σ Quantity > 60 (PRODUCT)
b) π Pname, Quantity (PRODUCT)

Question 14.
Why do we need a PHP script in Webpages? What type of output is generated when a PHP script is processed?
Client-side scripts(JavaScript) are run faster but it has some limitations. The limitations are we can view the source code hence it is less secure. On the other hand, PHP is executed on the server and the result is sent back to the client (browser) so it is impossible to view the source code.

Question 15.
What is e-banking? What are the areas where e-banking is effectively utilized?
E-banking (Electronic Banking): Through electronic channels doing all the banking activities at any time and place through the internet. Through this one can transfer funds from our account to another account, hence one can pay bills such as telephone, electricity, purchase tickets(Flight, Train, Cinema, etc).

Question 16.
What is GIS?
Geographical Information System: Geographic Information System(GIS) technology is developed from the digital cartography and Computer-Aided Design(CAD) database management system. GIS as the name implies capturing, storing for future reference, checking and displaying data related to various positions on the earth’s surface. GIS-can be applied in many areas such as soil mapping, agricultural mapping, forest mapping, e-Governance, etc.
GIS is used in development planning like strategic rural and urban planning, infrastructure planning, precision agriculture planning, etc.

Answer any nine questions from 17 to 27 (3 scores each)

Question 17.
a) What is the nested structure? (1 score)
b) Consider the following structure definition
struct Student
{
int rno;
char Name [20];
char dob;
}

How can you implement the concept of nested structure using the member ‘dob’?
If a structure declaration contains another structure as one of the members, it is called a nested structure.
struct date
{
short day, month, year;
};
struct Student
{
int rno;
charname[20];
date dob;
};

Question 18.
Explain any three concepts of object-oriented programming?

1. OOP allows modularity(divide the large programs into smaller ones)
2. It is good for defining abstract data types.
3. It allows data abstraction. That is it hides or protects data.
4. It allows code reusability
5. Real-life entities can be easily created
6. It supports creating new data types.

Question 19.
Write an algorithm to remove an item from a Queue?
Step 1: If front = Null then print “UNDERFLOW” and return
Step 2: Set item = Queue[front]
Step 3: If front = rear then
Set front = Null and rear = Null
Else if front = N then set front = 1
Else
Set front = front +1
End if
Step 4: stop

Question 20.
List and explain any three attributes of TABLE tag in HTML
<Table> Attributes (Any three)

1. Border – It specifies the thickness of the borderlines.
2. Border color – Colorful border lines.
3. Align – Specifies the table alignment in the window.
4. Bg-color – Specifies background colour.
5. Cellspacing – Specifies space between table cells.
6. Cellpadding – Specifies space between cell border and content.
7. Cols – Specifies the number of columns in the table.
8. Width – Specifies the table width.
9. Frame – Specifies the border lines around the table.
10. Rules – Specifies the rules (lines) and it overrides the border attribute.

Question 21.
What are the different ways to add javascript in a webpage?
Ways to add scripts to a web page.
1. Inside <BODY> section
Scripts can be placed inside the <BODY> section.

Scripts can be placed inside the <HEAD> section. This method is a widely accepted method

3. External (another) JavaScript file
We can write scripts in a file and save it as a separate file with the extension .js. The advantage is that this file can be used across multiple HTML files and can enhance the speed of page loading.

Question 22.
What is meant by web hosting? Briefly explain any two pages of web hosting?
Web hosting
Buying or renting storage space to store website in a web server and provide service(made available 24×7) to all the computers connected to the Internet. This is called web hosting. Such service providing companies are called web hosts. Programming languages used are PHP, ASP.NET, JSP.NET, etc.

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 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 23.
Explain the different levels of data abstraction in DBMS?
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 view the data.

Question 24.
Which constraints are used to define the following cases in SQL?
a) set a field to uniquely identify rows in a table.
b) increment the value of a field automatically.
c) set the value of a field to be not null
a) Primary key
b) auto increment
c) not null

Question 25.
Consider the data given below
Data in first array: 12, 36, 29, 34, 48
Data in Second array: Pen = 35, Pencil = 40, Eraser = 5, Brush = 25.
a) Name the suitable types of arrays to store these data. (1 score)
b) Write the PHP code to create these arrays to store the data. (2 scores)
a) first array – Indexed array
second array – Associated array

b) i) $mark=array(12, 36, 29, 34, 48); ii)$price=array(“Pen”=>”35″,”Pencil”=>”40″, “Eraser”=>”5”, “Brush”=>”25”);

Question 26.
What is meant by distributed computing? Discuss any two distributed computing Paradigms.
Distributed computing is a method of computing in which large problems can be divided into smaller ones and these smaller one are distributed among several computers. The solution for the smaller ones are computed separately and simultaneously. Finally, the results are assembled to get the desired overall solution.

1. Parallel computing
In Serial computation, the problem is divided into a series of instructions and these instructions are executed sequentially, i.e. one after another. Here, only one instruction is executed at a time. But in parallel computing, more than one instruction is executed simultaneously at a time.

2. Grid computing
It is a system in which millions of computers, smartphones, satellites, telescopes, cameras, sensors, etc. are connected to each other as a cyber world in which computational power (resources, services, data) is readily available like electric power. Any information at any time at any place can be made available at our fingertips. This is used in disaster management, weather forecasting, market forecasting, bio information, etc.

Question 27.
What are the different types of interaction between stakeholders in e-Governance?
e-Governance facilitates interaction between different stakeholders in governance

• Government to Government(G2G): Electronically exchanging data or information among Government agencies, departments or organizations.
• Government to Citizens(G2C): Exchange information between Government and Citizens Government to Business(G2B): Interaction between the Government and Businessmen.
• Government to Employees(G2E): The exchange of information between the Government and its employees

Answer any two questions from 28 to 30 (5 scores each)

Question 28.
a) Why do we need a dynamic webpage? Give an example.
b) What is the role ofwebservers?
c) Differentiate static webpage and dynamic webpage
a) Some pages are displaying the same content(same text, images, etc) every time. Its content is not changing. This type of web page is called a static page. Conventional web pages display static pages and have some limitations.
Advanced tools are used to create web pages dynamic, which means pages are more attractive and interactive. For this JavaScript, VBScript, ASP, JSP, PHP, etc are used.

b) A computer with high storage capacity, high speed, and processing capabilities is called a web server. Hence it is a powerful computer with a server operating system and software for providing services like www, e-mail, etc. Popular server operating systems are Redhat, OpenSUSE, Debian, Ubuntu, Sun Solaris, Microsoft Windows Server, etc.
c)

 Static web pages Dynamic web pages Content and layout is fixed Content and layout is changed frequently Never use database Run by browser The database is used It runs on the server and result get back to the client (browser) Easy to develop Not at all easy

Question 29.
a) What is the use of rowspan and colspan in a table in HTML?
b) Correct the given HTML code to get the output as shown in the figure

 Science Roll No. Name 1 Arun 2 Aliya
<html>
<body>
<table>
<tr>
<td align='centre'>science</td>
</tr>
<tr>
<td>Rollno</td?
<td>name</td>
</tr>
<tr>
<td>1</td>
<td>Arun</td>
</tr>
</table>
</body>
</html>

a) Colspan – Specifies the number of columns span for the cell.
Rowspan – Specifies the number of rows span for the cell.

b) <html>
<body>
<table border=''1">
<tr>
<td colspan=”2" align=”center”>Science</td>
</tr>
<tr>
<td>Rollno</td>
<td>name</td>
</tr>
<tr> <td>1</td>
<td>Arun</td>
</tr>
<tr>
<td>2</td>
<td>Aliya</td>
</tr>
</table>
</body
</html>

Question 30.
Write SQL queries based on the table EMPLOYEE given below.

 EID Name Job Code Salary 1876 Syam ME3 45000 1114 Abdu FA5 32000 1556 John TA1 39000 1354 Dhyana TA1 50000 1130 Dhanam ME3 42000
1. List EID and name of all employees
2. Find all employees with Job code TA1 and salary greater than 39000
3. Find all employees whose name begins with the letter D
4. Delete all employees with Job code ME3
5. Display the details of employees in ascending order of salary