Plus Two Computer Science Model Question Paper 3

Kerala Plus Two Computer Science Model Question Paper 3

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 (5×1 = 5)

Question 1.
The blueprint or prototype that defines the properties and behavior of similar objects is called …………..

Question 2.
Write an example of a dynamic data structure.

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

Question 4.
The attribute .required in the tag for internal linking is ………..

Question 5.
SFTP stands for ………..

Answer any nine questions from 6 to 16 (9×2 = 18)

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

Question 7.
How can you create a dynamic array of size N, if N is inputted by the user ?

Question 8.
What is the advantages of circular queue over linear queue ?

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 = ........;
}

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

Question 12.
Write short notes on primary key and 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.
b. Select Pname and Quantity.

Question 14.
Why do we need PHP Script in web pages? What type of output is generated when a PHP script is processed ?

Question 15.
What is e-banking ? What are the areas where e-banking is effectively utilized?

Question 16.
What is GIS?

Answer any nine questions from 17 to 27 (9 x 3 = 27)

Question 17.
a. What is nested structure ?

b. Consider the following structure definition.

struct Student
{
int rno;
char Name[2o];
char dob;
}

How can you implement the concept of nested structure using the member ‘dob’ ?

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

Question 19.
Write an algorithm to remove an item from a Queue ?

Question 20.
List and explain any three attributes of TABLE tag in HTML.

Question 21.
What are the different ways to add JavaScript in a webpage ?

Question 22.
What is meant by web hosting ? Briefly explain any two stages of web hosting.

Question 23.
Explain different level of data abstraction in DBMS.

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.

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.
b. Write the PHP code to create these arrays to store the data.

Question 26.
What is meant by distributed computing ? Discuss any two distributed computing paradigms.

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

Answer any two questions from 28 to 30 (2 x 5 = 10)

Question 28.
a. Why do we need dynamic webpage ?
b. What is the role of web servers ?
c. Differentiate static webpage and dynamic webpage.

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.

<HTML>
<B0DY>
<TABLE>
<TR>
<TD ALIGN </TD>
</TR>
<TR>
<TD > Rollno </TD>
<TD > name </TD>
</TR>
<TR>
<TD>1</TD>
<TD>Arun</TD>
</TR>
</TABLE>
</BODY>
</HTML>

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

a. List EID and name of all employees.

b. Find all employees with Jobcode TA1 and salary greater than 39000.

c. Find all employees whose name begins with letter D.

d. Delete all employees with Jobcode ME3.

e. Display the details of employees in ascending order of salary.

Class

80

Href

Secured File Transfer Protocol

Array:

• It is a derived data type.
• A collection of same type of data.

Structure:

• It is a user-defined data type.
• A collection of different types of data.

int *ptr = new int[N];

We can overcome the drawbacks of queue, using circular queue. Imagine the worst situation that there is only one element at the last position of the queue. If we try an insertion operation in this queues, there will he overflow situation. This limitation of linear queue can be overcome by circular queue.

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

onClick() : This event occurs when the User clicks on the element.
onMousedown() : This event occurs when the user presses a mouse button over an element.

Primary key: It is a set of one or more attributes that can uniquely identify tuples within the relation. It cannot contain null value and duplicate value.
Foreign key: A key in a table can be called foreign key if it is a primary key in another table. Since a foreign key can be used to link two or more tables it is also called a reference key.

a. σ Quality>60  (PRODUCT)
b. πPname, Quality (PRODUCT)

PHP is needed to accept the data sup-plied through the clients and process them within the server computer and give results back to the clients. PHP returns html files after processing.

Internet banking and core banking help in transforming traditional banking into e-Banking. e-Banking or electronic banking is defined as the automated delivery of banking services directly to customers through electronic channel. E-Banking is utilized in ATMs, bill payments, Internet banking and core banking.

GIS is a computer system for capturing, storing, checking and displaying data related to various positions on earth’s surface. GIS can show many different kinds of data on a map.

struct Student
{
int rno;
char Name[20];
struct
{
int dd, mm, yy;
} dob;
};

Data abstraction: Refers to showing only the essential features of the application and hiding the details from outside world. Data abstraction separates interface and implementation. Implementation denotes how variables are declared, how functions are coded, etc. It is through interface (function header/function signature) a communication is send to the object as messages.
Encapsulation: An OOP concept that binds together the data and functions that manipulate the data, and keeps both data and function safe from outside interference and misuse. C++ implements encapsulation through the declaration of a class. A class can contain private, protected and public members.
Polymorphism refers to the ability of a programming language to process objects differently depending on their data type or class. More specifically, it is the ability to redefine methods for derived classes.

Algorithm: To perform DELETION operation in a queue
Consider an array QUEUE[N], where N is the maximum size of the array. FRONT and REAR keeps track of the front and rear position of the queue. VAL is a variable to be removed from the queue.

Start
1: If (FRONT > -1 AND FRONT < REAR)
Then // empty status checking
2: VAL = Q[FRONT]
3: FRONT = FRONT + 1
4: Else
5: Print “Queue underflow”
6: End of If
7: If (FRONT > REAR) Then
8: FRONT = REAR = -1
9: End of If
Stop

1. Border: It specifies the thickness of the border line around the table.
2. Bordercolor: It is used to assign colour to the table border.
3. Align: It specifies the position of the table inside the browser window.

1. Inside <BODY>: Placing scripts inside the <BODY> tag, the scripts will be executed while the contents of the web page is being loaded. The web page starts displaying from the beginning of the document. When the browser sees a script code in between, it renders the script and then the rest of the web page is displayed in the browser window.
2. Inside <HEAD>: It is a visual practice to include scripts in the head section of the web page. The main reason for this is that the body section of most of the HTML pages contains a large volume of text that specifies the contents to be displayed on the web page. Mixing a function definition also with this will create a lot of confusion for the web designer for making any kind of modification in the page.
3. External JavaScript file: We can place the scripts into an external file and then link to that file from within the HTML document. This file is saved with the extension ‘.js’. Placing JavaScripts in external files has some advantages. This is useful if the same scripts is used across multiple HTML page or a whole website.

Web hosting is the service of providing storage space in a web server to serve files for a website to be made available on the Internet.
The two stages of web hosting are:
1. Purchase of hosting space.
2. Registration of domain name.
Two types of web hosting are:
Shard web hosting: It is the most common type of web hosting. It is referred to as shared because many different websites are stored on one single web server and they share resources like RAM and CPU. The features available on shared web servers are generally basic and are not flexible to suit a website that require specific features. Dedicated web hosting: It is the hosting where the client leases the entire web server and all its resources. The web server is not shared with any other website. Dedicated servers provide guaranteed performance, but they are very expensive. Since the bandwidth is not shared with other websites, it speeds up the access of the website. If the client is allowed to place their own purchased web server in the service
providers facility, then it is called co-location.

1. Physical level: It is the lowest level of abstraction. The physical level describes complex lowlevel data structures in detail. We must decide what file organisations are to be used to store the relations and create auxiliary data structures, called indexes, to speed up data retrieved operations.
2. Logical level: It is is the next higher level of abstraction describes what data is stored in the database, and what relationship exist among those data. It describes the entire database in terms of a small number of relatively simple structures. The user of the logical level does not need to be aware of the complexity. Logical level is also referred as conceptual level.
3. View level: It is the highest level of database abstraction and is closest to the users. It is concerned with the way in which individual users view the data. It describes only a part of the entire database. Most of the users are not concerned with all the information that is contained in the database.

a. UNIQUE
b. AUTO_INCREMENT
c. NOT NULL

a. First case: Indexed array
Second case: Associative array

b. $arr1 = array(12, 36, 29, 34, 48);$arr2 = array (“Pen” =>35,“Pencil”
= >40, “Eraser”=>5, “Brush”=> 25);

Distributed computing is a method of computing in which large problems can be divided into many small problems which are distributed to many computers. It provides a way to reduce the time it takes to perform a large task.
Grid computing is described as a world in the computational power (resources, services, data) is readily available. Here users get access to computational power just like electricity through wall side with no care or consideration for where or how the electricity is actually generated. Computers on a grid have a program on them, that allows unused resources to be used by another computer on the grid.
Cluster computing is a form of computing in which a group of personal computers, storage devices etc. are linked together so that they can work like a single computer. The components of a cluster are connected to each other through fast local area networks. Clusters provide computational power through parallel processing. It is relatively low cost form of a parallel processing machine used for scientific and other applications.

i. Government to Government (G2G): It is the electronic sharing of data and/ or information among government agencies, departments or organizations. The goal of G2G is to support e- Governance initiatives by improving communication, data access and data sharing.
ii. Government to Citizens (G2C): If creates an interface between the government and citizens. Here the citizens enjoy a large range of public services. It increases the availability and accessibility of public services. It also improves the quality of services. Its primary purpose is to make the government citizen-friendly.
iii. Government to Business (G2B): e- Governance tools are used to aid the business community to interact with the government. The objective is to capitalism, save time, reduce operational costs and create a more transparent business environment while dealing with the government.
iv. Government to Employees (G2E): Government, being the biggest employer has to interact with its employees on a regular basis. This interaction is a two-way process between the government and the employees.

a. Dynamic web pages are required to display information retrieved from the database based on the input given through the client
eg., Web page that displays the results of class XI examinations.
b. A web server is a powerful computer which is always switched on and connected to a high bandwidth Internet connection. This will facilitate Internet users around the world to access the websites and services hosted by it at any point of time.
c. a. Static websites:
1. The content and layout of a web page is fixed.
2. Static web pages never use data-bases.
Dynamic websites:
1. The content and layout may change during run time.
2. Database is used to generate dynamic content through queries.

a. Colspan: It defines the number of columns occupied by that particular cell.
Rowspan: It defines the number of columns occupied by that particular cell

b. <HTML>
<BODY>
<TABLE Border = “1”>
<TR>
<TH Colspan="2"> Science</TH>
</TR>
<TR>
<TH > Roll No. </TH>
<TH > Name </TH>
</TR>
<TR>
<TD>1</TD>
<TD>Arun</TD>
</TR>
<TR>
<TD>2</TD>
<TD>Aliya</TD>
</TR>
</TABLE>