Kerala Plus Two Computer Science Question Paper March 2024 with Answers

Reviewing Kerala Syllabus Plus Two Computer Science Previous Year Question Papers and Answers Pdf March 2024 helps in understanding answer patterns.

Kerala Plus Two Computer Science Previous Year Question Paper March 2024

Time: 2 Hours
Total Score: 60 Marks

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

Question 1.
Choose the indirection or value at operator used in C++ from the options given below.
(a) ++
(b) *
(c) &
(d) +
Answer:
(b) *

Question 2.
Which of the following is used for creating controls in a form in HTML?
(a) <TABLE>
(b) <OL>
(c) <INPUT>
(d) <FRAME>
Answer:
(c) <INPUT>

Question 3.
Name the type of web hosting in which client leases the entire Webserver and it’s resources.
Answer:
Dedicated hosting

Question 4.
The smallest unit of stored data in DBMS is called …………………….
Answer:
Field or Attribute

Question 5.
The full form of DML is ………………..
Answer:
Data Manipulation Language

Kerala Plus Two Computer Science Question Paper March 2024 with Answers

Question 6.
Legal right given to the creators for an original work is
(a) Geographical indication
(b) Trademark
(c) Copyright
(d) Industrial design
Answer:
(c) Copyright

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

Question 7.
Write the syntax for the following :
(a) Declaration of pointer variable in C++
(b) Dynamic memory allocation in C++
Answer:
(a) data_type*variable;
(b) pointer = new data_type;

Question 8.
Define the term self – referential structure, Give example.
Answer:
Self-referential structure: A structure contains an element that is a pointer to the same structure.

Question 9.
Write any two advantages of using OOP.
Answer:

  • OOP allows modularity
  • It is good for defining abstract data types.

Question 10.
Name any four operations on data structures.
Answer:
Traversing, Searching, Inserting, Deleting, Sorting, Merging (Write any four of them)

Question 11.
What do you mean by stack overflow and stack underflow?
Answer:
Stack overflow: If the stack is full and we try to add a new item into the stack means stack over flow.
Stack underflow: If the stack is empty and we try to delete an item from the stack makes the stack underflow.

Question 12.
Define the following terms:
(a) HTTPS
(b) Software ports
Answer:
(a) HTTPS (Hyper Text Transfer Protocol Secure): It is the technology used to protect data that are transferred from client to web server.

(b) Software port is used to connect a client computer to a server to access different types of services. For example HTTP, FTP, SMTP etc. Unique numbers are assigned to software ports to identify them.

Question 13.
Name any four attributes of <TD> tag.
Answer:
Align: Specifies horizontal alignment. Its value are left, right, centre or justify
Valign: Specifies vertical alignment. Its values are top, middle, bottom or baseline.
Bgcolor: Specifies border color for the cell.
Rowspan: Specifies the number of rows span for the cell.

Kerala Plus Two Computer Science Question Paper March 2024 with Answers

Question 14.
Write the HTML code for the following :
(a) To create an email hyperlink to
dhsekerala@qmail.com
(b) To insert a video file video 1. mp4 in the webpage
Answer:
(a) <a href=mailto:” dhsekerala@qmail.com”
> DHSE</a>

(b) <embed src=”video1 .mp4″>

Question 15.
Write the names of the following :
(a) Operator used for adding two strings in Java Script.
(b) Function used in JavaScript to convert string type data containing numbers to number data type.
Answer:
(a) +
(b) Number()

Question 16.
Define the term data independence. What are the different levels of data independence?
Answer:
Data Independence is the ability to modify the scheme definition in one level without affecting the scheme definition at the next higher level. There are two types of data independence

  • Physical Data Independence
  • Logical Data Independence

Question 17.
Write any two advantages of parallel computing.
Answer:

  • If one or more node fails, the entire system will not failed instead it works with reduced performance. This method is called fault tolerance.
  • Sharing the computing power and storage resources with each other.

Question 18.
Write short note on cloud computing.
Answer:
It is an emerging computing technology. Here with the uses of Internet and central remote servers to maintain data and applications. Example for this is Email service, Office Software graphic software etc. The information is placed in a central remote server just like clouds in the sky hence the name cloud computing.

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

Question 19.
Compare Arrays and Structures
Answer:

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

Question 20.
Define the following OOP terms :
(a) Data Abstraction
(b) Inheritance
(c) Function overloading
Answer:
(a) Data Abstraction: It refers to the act of representing essential features without including the background details. Abstraction supports data hiding so that only the relevant information is expressed to the user and the rest of information remains hidden from the user.

(b) Inheritance: It is the capability of one class of things to inherit properties from another class. The class from which attributes are inherited is called the base class. The inherited class is called derived class.

(c) Function overloading: Functions with same name and different signatures (the number of parameters or data types is different)

Question 21.
Write short note on :
(a) Linked list
(b) Circular Queue
(c) Stack
Answer:
(a) Linked List: It follows dynamic data structure method. It grows and shrinks as and when the new items are added and removed respectively.

(b) Circular Queue: It is linear data structure in which the operations are performed based on FIFO principle and the last position is connected back to the first position.

(c) Stack: A stack is a linear structure in which items can be added or removed only at one end called top. Add an item into the stack is called push and deleting an item from the stack is called pop.

Question 22.
Differentiate client side scripting and server side scripting.
Answer:

Client Side Scripting Server Side Scripting
Script is copied to client browser Script is copied to the web browser
Executed by the client Executed by the server and result is get 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 It is not possible to block
Client side scripts depends the type and version of the browser. It does not depefld the type and version of the browser.

Kerala Plus Two Computer Science Question Paper March 2024 with Answers

Question 23.
Write the HTML code to display the following list:
1. Input devices
• Keyboard
• Mouse
• Scanner
2. Output devices
• Monitor
• Printer
Answer:

<HTML>
<BODY>
<OL>
<LI> Input devices</LI>
<ULTYPE=”disc”>
<LI> Keyboard </LI>

<LI> Mouse </LI>
<LI> Scanner </LI>
</UL>
<LI> Output devices </LI>
<ULTYPE=”disc”>
<LI> Monitor </LI>
<LI> Printer </LI>
<UL>
</OL>
</BODY>
</HTML>

Question 24.
Name the following :
(a) Built-in function used in JavaScript to get the character at a particular position in a string.
(b) Built-in function in JavaScript used to check whether a value is number or not
(c) Data type used in JavaScript for repre-senting true or false values.
Answer:
(a) charAt()
(b) isNaN()
(c) Boolean

Question 25.
Consider the following JavaScript code to find the sum of numbers upto a given limit.
Fill the blanks.
__________ sum Limit ()
{
_________ sum = 0, i, limit;
limit =
___________ (document, frmSum.txtLimit, );
___________ (i = 1 ; i <=limit; i++)
sum + = i;
docuemt. frmSum.txtSum __________ = sum;
}
Answer:
function sumLimit()
{
var sum=0, i, limit;
limit=Number(document.frmSum.txtLimit. Value):
Number (i=1 ;i<=limit;i++)
sum+=i;
document.frmSum.txtSum.Value = sum;
}

Question 26.
Briefly explain the following terms :
(a) Free hosting
(b) CMS
(c) Responsive web design
Answer:
(a) Free hosting: The name implies it is free of cost service and the expense is met by the advertisements. Some service providers allow limited facility such as limited storage space, do not allow multimedia files.

(b) CMS (Content Management System) is a collection of programs that is used to create, modify, update and publish websites contents.

(c) Responsive web design- The home page is displayed differently according to the screen size of the browser window we used. By responsive web design, companies have to design only one website that suitably displayed according to the screen size of the devices.

Question 27.
Briefly explain any three aggregate or column functions is SQL
Answer:

  1. Sum() – find the total od a column
  2. Avg() – find the average of a column
  3. Min() – find the smallest value of a column

Question 28.
Write SQL queries for the following :
(a) To create a table with the following fields
Employee name
Designation
Basic pay
DA
Gross pay
(b) To display all employees whose Basic pay is more than 50,000
(c) To update .the DA of employees whose designation is manager to 20% of Basic pay.
Answer:
(a) CREATE TABLE
Employee (Employee_name
VARCHAR(70), Designation
VARCHAR(70), Basic_pay DEC(7,2),
DA DEC(7,2), Gross_pay DEC(7,2));

(b) SELECT *FROM Employee WHERE Basic_pay>50000;

(c) UPDATE Employee SET DA= Basic _pay*20/100 WHERE Designation =” Manager”;

Question 29.
Explain briefly about any three core data types in PHP.
Answer:
Integer – Two types -ve and +ve. PHP does not support unsigned integer data type. Eg: 8172,-22
Float/Double – Numbers with decimal point. Eg: 81.72, 7E-10, 123E12
String – Combination of characters enclosed in quotes. Eg: “BVM”, ‘HSS’ etc.

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

Question 30.
(a) Write the basic structure of an HTML document (3)
(b) Write the HTML code for the following
(i) To display a scrolling text “welcome to my webpage” with 5 second delay in scrolling. (1)
(ii) To display the text H<sub>2</sub>SO<sub>4</sub> (1)
Answer:
(a)

<HTML>
<HEAD>
<TITLE> Exampoint </TITLE>
</HEAD>
<BODY>
Body Section
</BODY>
</HTML>

(b) (i) <MARQUEE Scrolldelay=5000> welcome to my webpage</ MARQUEE>
(ii) H<SUB>2</ SUB> SO < SUB > 4</SUB>

Kerala Plus Two Computer Science Question Paper March 2024 with Answers

Question 31.
(a) Define the following terms in RDBMS :
(i) Primary Key (2)
(ii) Attributes (3)
(b) Briefly explain any three operations in relational algebra
Answer:
(a) (i) Primary Key: It is a set of one or more attributes used to uniquely identify a row.
(ii) Attributes: Attributes means columns.

(b

  1. Select Operation
  2. Project Operation
  3. Cartesian Product

Question 32.
(a) Define E-Govemance (2)
(b) W rite any four benefits of E-Govemance (3)
Answer:
(a) The integration of computers and communication technology for the benefit of government functions to the public is termed as E-Governance by this Govt, can serve the public in a convenient, efficient and transparent manner.

(b)

  1. It enables automation of Govt, services.
  2. It ensures the participation of citizens hence strengthen the democracy
  3. It ensures more transparency hence eliminates corruption
  4. It enhances responsibilities of various Govt. Departments’

Leave a Comment