Class 12 Information Technology 802 Previous Year Question Paper 2023 – Solution

by

Series ƩFGHE
Question Paper Code 326 Set 4

INFORMATION TECHNOLOGY – SOLUTION
(Session 2022-23)

Time allowed : 3 hours
Maximum Marks : 60

General Instructions :

  1. Please read the instructions carefully.
  2. This question paper consists of 24 questions in two Sections : Section A and Section B.
  3. Section A has Objective type questions whereas Section B contains Subjective type questions.
  4. Out of the given (6 + 18) = 24 questions, a candidate has to answer (6 + 11) = 17 questions in the allotted (maximum) time of 3 hours.
  5. All questions of a particular section must be attempted in the correct order.
  6. Section A : Objective Type Questions (30 marks) :
    • This section has 6 questions.
    • There is no negative marking.
    • Do as per the instructions given.
    • Marks allotted are mentioned against each question/part.
  7. Section B : Subjective Type Questions (30 marks) :
    • This section has 18 questions.
    • A candidate has to do 11 questions.
    • Do as per the instructions given.
    • Marks allotted are mentioned against each question/part.

Section A (Objective Type Questions) (30 Marks)

1. Answer any 4 questions out of the given 6 questions on Employability Skills. (4×1=4)

(i) An individual’s motivations, inspired by others or events is known as ____.
Answer: extrinsic motivation

(ii) What is stress ?
Answer: Stress is when you feel worried, upset, or tense because of things happening around you. It’s like a feeling of pressure or being overwhelmed by problems or challenges. Stress can make your body feel uneasy, and it can affect your emotions and how you think.

(iii) A ____ is rectangle shaped box, where row and column meet in a spreadsheet.
Asnwer: cell

(iv) Decisiveness is one of the entrepreneurial competencies. State True/False.
Answer: True

(v) The act of setting up and running a business and taking risks in order to earn profits is known as ____.
Answer: entrepreneurship

(vi) In Open Office Calc ____ contains the Name Box which shows the location of the selected cell.
a) Formula Bar
b) Status Bar
c) Menu Bar
d) Title Bar

2. Answer any 5 out of the given 7 questions. (5X1=5)

(i) ____ command displays all the tables created in the current database.
(a) SHOW DATABASES
(b) SHOW TABLES
(c) CREATE TABLES
(d) DISPLAY TABLES

(ii) ____ symbol replaces a single character while matching a pattern with LIKE keyword.
Answer: underscore (_)

(iii) Predict the output :
String myStr = "Welcome Users";
System.out.println("New String:"+myStr.toUpperCase());
Answer: WELCOME USERS

(iv) An attribute value may not be permitted to be NULL value with ____ constraint.
Answer: NOT NULL

(v) ____ statement in Java, allows to use a prebuilt class and its associated methods from a package.
a) include
b) public
c) extend
d) import

(vi) _________ is an e-commerce application where the customer can purchase goods over the Internet.
Answer: Online store

(vii) Ranjana has written the following query but it is giving an error. Rectify the error and rewrite the query.
SELECT * FROM PRODUCT
SORT BY PRICE;
Answer: SELECT * FROM PRODUCT
ORDER BY PRICE;

3. Answer any 6 out of the given 7 questions. (6X1=6)

(i) The ____ blocks follow a try block. It contains the exception handler-specific code that is executed when the exception occurs.
Answer: catch

(ii) “Database management system could not find any usage in hospital domain.” Is the above statement true or false?
Answer: False
Explanation: DBMS plays a crucial role in the hospital domain by managing and organizing vast amounts of data critical to patient care, administration, and research.

(iii) NeGP stands for ____ .
Answer: National e-Governance Plan

(iv) The ____ command is used to view the structure and description of a table :
a) DESCRIBE
b) SELECT
c) SHOW
d) DISPLAY

(v) Define Referential Integrity.
Answer: Referential Integrity is a database concept that ensures relationships between tables are maintained. It enforces that foreign keys in one table match primary keys in another, preserving data consistency.

(vi) What is a Compiler ?
Answer: A compiler is a software tool that translates high-level programming code into machine code, making it executable by a computer.

(vii) Name any two Primitive datatypes in Java.
Answer: Int, Bollean

4. Answer any 5 out of the given 6 questions. (5X1=5)

(i) A ____ is a group of statements written to perform a specific task.
a) Method
b) Class
c) Comment
d) Variable

(ii) Predict the output of the given Java code :
String first_name = "Priyank";
String last_name = "Arora"
System.out.println(first_name.length()+last_name.length());
Answer: The combined length of “Priyank” (7 characters) and “Arora” (4 characters) is 11.

(iii) In which of the following phase of web based application project, we create backend database, frontend and the connectivity between them ?
a) Requirement
b) Design
c) Implementation
d) Test

(iv) Which of the following constraints specifies that the value of every attribute in each tuple must be from the domain of that attribute. ?
a) Domain Constraint
b) Key Constraint
c) Null Value Constraint
d) Entity Integrity Constraint

(v) Database can be removed by using ____ command.
Answer: DROP Command (DROP DATABASE database_name;)

(vi) What will be the output of the following code if value of variable a is 1 ?
{
case 0 : jTextField1.setText("Blue");
case 1 : jTextField1.setText("Red");
case 2 : jTextField1.setText("Orange");
break;
case 3 : jTextField1.setText("Black");
default : jTextField1.setText("transparent");
break;
}
Answer: If the value of the variable “a” is 1, the code will execute the “case 1” block, and the text in “jTextField1” will be set to “Red.”

5. Answer any 5 out of the given 6 questions. (5X1=5)

(i) Define Front End, with respect to web based application project.
Answer: In the context of a web-based application project, the “Front End” refers to the user interface or the client-side component of the application that users interact with.

(ii) ____ members of a class cannot be accessed outside the class.
Answer: Private

(iii) Create Table is a ____ command.
Answer: DDL (Data Definition Language) Command

(iv) Name any 2 web browsers.
Answer: Google Chrome, Apple Safari

(v) Name the Indian Government portal for booking train tickets.
Answer: https://www.irctc.co.in

(vi) Name the method that is used to concatenate a string at the end of another string in Java.
Answer: concat()

6. Answer any 5 out of the given 6 questions. (5X1=5)

(i) RDBMS packages are widely used as ____ (Frontend/Backend)
Answer: Backend

(ii) Mention any one eGovernance initiative taken by the Central Government of India.
Answer: Digital India

(iii) What is a Bytecode ?
Answer: Bytecode is an intermediate representation of a program’s source code that is used in various programming languages and platforms.

(iv) Requirement, ____, Implementation and Testing are the phases in Web Application Development.
Answer: Design

(v) Which of the following is/are not a keyword in JAVA ?
break, While, for, switch, Display
Answer: Display

(vi) The functions that are used to apply certain mathematical functions on a group of values in a database are called ____.
Answer: aggregate functions or SQL aggregate functions

Section B (Subjective Type Questions) (30 Marks)

Answer any 3 questions out of the given 5 questions on Employability Skills. Answer each question in 20-30 words.

7. Briefly discuss the importance of positive attitude.
Answer: Having a positive attitude makes life better. It helps you stay strong, see the good in things, and feel happier, even when things are tough.

8. Name any two types of Entrepreneurs.
Answer: (a) Small Business Entrepreneurs, Solo Entrepreneurs

9. Write down the main steps to apply filter to a tabular data in Calc.
Answer: The main steps to apply a filter to tabular data in LibreOffice Calc:
Step 1: Select the cell in the data.
Step 2: Go to “Data” > “Filter.”
Step 3: Click the filter arrow in the header.
Step 4: Set your filtering criteria.
Step 5: Click “OK” to apply the filter.

10. Mention any two common barriers to entrepreneurship.
Answer: (a) Lack of Capital (b) Market Competition

11. Mention any two steps to overcome personality disorders.
Answer: Overcoming personality disorders typically requires professional guidance and therapy. However, here are two simple steps that can be part of the process:
(a) Self-Awareness: Acknowledging the issue is the first step towards seeking help and change.
(b) Seek Professional Help: Consult a mental health professional, such as a psychologist or psychiatrist, who can provide a diagnosis and develop a treatment plan, which may include therapy, medication, or other interventions.

Answer any 3 out of the given 5 questions in 20-30 words each. (3X2=6)

12. Write a query to modify the value of field ‘dept’ from ‘marketing’ to ‘sales’ in the table Department.
Answer: UPDATE Department SET dept = 'sales' WHERE dept = 'marketing';

13. What is the purpose of using try and catch statements in JAVA ?
Answer: In Java, try and catch statements are used to handle exceptions, which are unexpected events that can occur during the execution of a program.

14. Explain any two methods of String class in Java with suitable example.
Answer: (a) substring(int beginIndex, int endIndex): This method extracts a portion of the string, starting at the beginIndex and ending before the endIndex.
Example:
String original = “Hello, World!”;
String sub = original.substring(7, 12);
System.out.println(sub); // Output: “World”
(b) toUpperCase(): This method converts all characters in the string to uppercase and returns a new string with the uppercase characters.
Example:
String text = “Hello, Java”;
String upperCaseText = text.toUpperCase();
System.out.println(upperCaseText); // Output: “HELLO, JAVA”

15. Mention any two major significances of Database Management System.
Answer: Database Management Systems (DBMS) have several significant advantages, but here are two major significances:
(i) Data Integrity and Consistency: DBMS enforces data integrity constraints, ensuring that data in the database follows predefined rules and constraints. This helps maintain the accuracy and consistency of data, preventing inconsistencies and errors.
(ii) Data Security and Access Control: DBMS provides robust security features to control access to data. It allows administrators to define user roles and permissions, limiting who can view, modify, or delete data.

16. Fill in the blanks.
(a) The number of attributes in a relation is called the ____ of a relation.
Answer: degree
(b) To avoid repetition in the result of a SELECT Query ____ clause is used.
Answer: DISTINCT

Answer any 2 out of the given 3 questions in 30-50 words each. (2X3=6)

17. Discuss any three main purposes of using Database applications in education domain.
Answer: Database applications in the education domain serve several important purposes, but here are three main ones:
(i) Student Information Management: Education databases store and manage student information, including personal details, enrollment records, attendance, and academic performance.
(ii) Curriculum and Course Management: Databases are used to manage curriculum details, course catalogs, class schedules, and resources. These systems help educators plan courses, allocate resources efficiently, and make curriculum adjustments.
(iii) Research and Analysis: Databases aid in educational research by collecting and storing data related to student performance, teaching methods, and institutional effectiveness.

18. Rewrite the following program code using switch statement :
if (color == 10)
{ system.out.println("Red"); }
else if (color == 20)
{
System.out.println ("Orange");
}
else if (color == 30)
{
System.out.println ("Green");
}
else
{
System.out.println ("Invalid");
}

switch (color) {
    case 10:
        System.out.println("Red");
        break;
    case 20:
        System.out.println("Orange");
        break;
    case 30:
        System.out.println("Green");
        break;
    default:
        System.out.println("Invalid");
        break;
}

19. (i) State the role of a DBA (Database Administrator).
Answer: A Database Administrator (DBA) plays a pivotal role in the efficient and secure management of database systems within organizations. DBAs are responsible for a wide range of tasks that revolve around the design, implementation, maintenance, and optimization of databases. They collaborate with software developers and business analysts to create well-structured databases, ensuring data integrity and efficiency. DBAs keep a vigilant eye on data growth and plan for capacity needs, as well as contribute to disaster recovery planning to ensure business continuity.
(ii) Sana has given the following query but she is unable to execute it successfully. Write the correct query after rectifying the error
SELECT NAME, MARKS
FROM STUDENT TABLE
WHERE NAME = "P%"
Answer: SELECT NAME, MARKS FROM STUDENT WHERE NAME LIKE ‘P%’;

Answer any 3 out of the given 5 questions in 50-80 words each. (3X4=12)

20. What is the purpose of HAVING clause ? How is it different from WHERE clause in SQL ? Give example to support you answer.
Answer: The HAVING clause in SQL is used to filter the results of a SQL query that includes a GROUP BY clause.
The main difference between the HAVING and WHERE clauses is when they are applied:
• The WHERE clause is used to filter rows before they are grouped and is applied to individual rows in the table.
• The HAVING clause is used to filter the results of the grouping after the GROUP BY operation has been performed, and it is applied to groups of rows based on the results of aggregate functions.

SELECT CustomerID, SUM(Quantity) as TotalQuantity
FROM Orders
WHERE Product = 'Widget'
GROUP BY CustomerID
HAVING TotalQuantity > 100;

SELECT CustomerID, SUM(Quantity) as TotalQuantity
FROM Orders
WHERE Product = 'Widget'
GROUP BY CustomerID
HAVING SUM(Quantity) > 100;

21. Write advantages of online tutorials.
Answer: Online tutorials offer several advantages, including:
Convenience and Flexibility: Learners can access online tutorials from anywhere, at any time, making it convenient for them to fit learning into their schedules. This flexibility allows for self-paced learning.
Variety of Topics: Online tutorials cover a wide range of subjects and skills, making it easy to find tutorials on specific topics of interest or need.
Cost-Effective Learning: Many online tutorials are available for free or at a lower cost than traditional classroom courses.
Interactive Learning: Online tutorials often incorporate multimedia, quizzes, and interactive exercises, making the learning experience engaging and effective.

22. Why is Java considered as an Object Oriented Programming language ? Explain data members and member methods with the help of an example.
Answer: Java is considered an Object-Oriented Programming (OOP) language because it follows the principles and concepts of Object-Oriented Programming. These principles include encapsulation, inheritance, polymorphism, and abstraction.
Data members and member methods with an example in Java:

public class Car {
    // Data members or attributes
    private String brand;
    private String model;
    private int year;
    private double price;

    // Constructor to initialize data members
    public Car(String brand, String model, int year, double price) {
        this.brand = brand;
        this.model = model;
        this.year = year;
        this.price = price;
    }

    // Member methods
    public void startEngine() {
        System.out.println("The " + brand + " " + model + "'s engine is started.");
    }

    public void accelerate() {
        System.out.println("The " + brand + " " + model + " is accelerating.");
    }

    public double calculateResaleValue() {
        int currentYear = java.time.Year.now().getValue();
        int age = currentYear - year;
        if (age >= 0 && age <= 5) {
            return price * 0.7; // 70% of the original price for cars 0-5 years old
        } else {
            return price * 0.5; // 50% of the original price for cars older than 5 years
        }
    }

    // Getters and setters for data members (encapsulation)
    public String getBrand() {
        return brand;
    }

    public void setBrand(String brand) {
        this.brand = brand;
    }

    // Other getters and setters for the remaining data members...
}

In this example, the Car class represents an object in an Object-Oriented manner. It has data members (attributes) like brand, model, year, and price, and member methods like startEngine, accelerate, and calculateResaleValue. The use of encapsulation is evident through private data members and public getters and setters to access and modify these attributes. The class illustrates the principles of OOP, including encapsulation and member methods.

23. (i) ‘Java is a platform independent language.’ Justify the statement.
Answer: Java’s platform independence means that Java code can run on different computer systems without modification. It achieves this through an intermediate step: when you write Java code, it gets compiled into a special form called bytecode, which is not tied to any specific computer. Then, a program called the Java Virtual Machine (JVM) on each computer translates this bytecode into instructions that the computer can understand. Since the JVM is available on various platforms, Java programs work on Windows, macOS, Linux, and more.
(ii) Give two relational operators and two logical operators in Java.
Answer: Relational Operators:
(i) Equal to (==): Used to check if two values are equal. For example: if (x == y) checks if x and y have the same value.
(ii) Not equal to (!=): Used to check if two values are not equal. For example: if (a != b) checks if a and b have different values.
Logical Operators:
(i) Logical AND (&&): Used to combine two conditions. It returns true if both conditions are true. For example: if (condition1 && condition2) checks if both condition1 and condition2 are true.
(ii) Logical OR (||): Used to combine two conditions. It returns true if at least one of the conditions is true. For example: if (conditionA || conditionB) checks if either conditionA or conditionB is true.

24. Write the output of following code:
(i) class production
{
int inp = 50;
void change(int inp)
{
System.out.println("Change"+po.inp);
inp=inp+100;
}
public static void main(String args[])
{
production po=new production();
System.out.println("before change"+po.inp);
po.change(500);
System.out.println("after change"+po.inp);
}
}
Answer:
before change 50
Change 50
after change 50
(ii) What are the two ways to write comments in Java ?
Answer: In Java, there are two ways to write comments:
(a) Single-Line Comments: Single-line comments are used to comment a single line or a portion of a single line. You can create a single-line comment by using //. Anything following // on the same line is treated as a comment and is ignored by the compiler.
(b) Multi-Line Comments: Multi-line comments are used to comment multiple lines or a block of code. You can create a multi-line comment by enclosing the comments within /* and */. Anything between these delimiters is considered a comment and is ignored by the compiler.

Find Class 12 Information Technology Previous Year Question Papers

Find Class 12 Information Technology Previous Year Question Papers Solution

Find Class 12 Information Technology Previous Year Compartment Question Papers

Find Class 12 Information Technology Previous Year Compartment Question Papers Solution

Leave a Comment