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

by

Series ∊FGHE/C
Question Paper Code 326 Set 4

INFORMATION TECHNOLOGY – COMPARTMENT – 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 out of the given 6 questions on Employability Skills. (4X1=4)

(i) An individual demonstrates a desire to do his/her work without any external reward is ____ motivation.
Answer: intrinsic

(ii) “Entrepreneurship is considered to be both an art and a science.” Is this statement true or false ?
Answer: True

(iii) All formulae in OpenOffice Calc begin with ____ sign.
a) #
b) $%
c) %
d) =

(iv) Mention any one quality that makes an entrepreneur successful.
Answer: Some of these qualities include: Vision, Risk-taking, Adaptability, Creativity, Strong work ethic etc.

(v) A ____ is a collection of one or more worksheets in a single file.
Answer: workbook

(vi) People with ____ personality disorder essentially lack a sense of self-worth and thus experience feelings of emptiness and fear of abandonment.
a) Paranoid
b) Antisocial
c) Borderline
d) Schizoid

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

(i) Define Data.
Answer: Data refers to facts, figures, or information that can be in the form of numbers, text, images, or any other format, which can be stored, processed, and analyzed to extract meaning or make decisions.

(ii) The number of attributes in a relation is called its ____.
a) Degree
b) Attribute
c) Cardinality
d) Domain

(iii) ____ is a set of attributes in a relation, for which no two tuples in a relation state have the same combination of values.
Answer: superkey

(iv) In SQL, a column definition can be changed with the help of ____ command.
Answer: ALTER TABLE

(v) A/An ____ is a task that is undertaken to create a unique product, service or result.
Answer: project

(vi) ____ are real time lectures, where users participate in the lecture, may ask questions and get their queries answered.
Answer: Webinars

(vii) In this phase we identify the problem statement for which the “web application” is to be developed.
a) Requirement Definition Phase
b) Design Phase
c) Implementation Phase
d) Test Phase

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

(i) A/An ____ is the named storage location in the computer’s internal memory, has a specific data type and its value can change during execution.
Answer: variable

(ii) Name any two primitive data types in Java.
Answer: In Java, there are several primitive data types. Here are five of them: int, double, boolean, char, byte.

(iii) In Java = = is a/an ____ operator.
a) Arithmetic
b) Relational
c) Assignment
d) Logical

(iv) Alternate of if - else is :
a) switch.. case
b) while
c) for
d) do while

(v) “There is no use of Database Management System applications in telecommunications.” Is the given statement true or false ?
Answer: false

(vi) What are the different payment methods while buying online ?
Answer: When buying online, there are several payment methods available to make transactions like Credit / Debit Card, PayPal, Digital Wallets, Bank Transfers, Prepaid Cards, Cash on Delivery (COD), Mobile Payment Apps etc.

(vii) ____ method of a String Class returns the count of characters present in a String.
a) indexOf()
b) indexAt()
c) length()
d) isEmpty()

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

(i) Which of the following is not a key characteristic of a project ?
a) A project has a beginning and an end
b) A project has a specific time frame
c) A project has no boundaries
d) The objective of the project is specific and identifiable

(ii) The ____ block is examined during execution to detect any exceptions that may be thrown by any statements or any calls to methods within the block.
Answer: try

(iii) JVM stands for _____.
Answer: Java Vertual Machine

(iv) The ____ statement evaluates the test after executing the body of a loop.
Answer: do-while loop

(v) ____ command deletes one or more tuples from a Table.
Answer: DELETE

(vi) if ((percentage > = 40)&& (percentage < 60))
{System.out.println("PASSED with II Division");}
Consider the above statement, && will check for both the conditions to be :
a) True
b) False
c) Any of the above
d) None of the above

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

(i) In SQL, while applying condition on a group, instead of WHERE clause ____ clause is used.
Answer: HAVING

(ii) Name any two aggregate functions used in SQL.
Answer: COUNT, SUM

(iii) An application that can be accessed via a web browser, over a network connection is called a ____ application.
Answer: web

(iv) command displays list of databases available on the current server.
a) Show databases
b) Show tables
c) Create tables
d) Display tables

(v) ____ can be used for Multi-line Comment entry.
a) //
b) /* …. */
c) ##
d) $$

(vi) All Java Statements must end with ____.
a) /
b) *
c) ;
d) &

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

(i) Name any one e-governance website of India.
Answer: https://www.digitalindia.gov.in

(ii) Give examples of any two online educational websites.
Answer: (i) Coursera (ii) Khan Academy

(iii) Create backend database, frontend and the connectivity between them comes under which phase ?
a) Requirement Definition
b) Design
c) Implementation
d) Testing

(iv) How does e-governance benefits its citizens ?
Answer: E-governance offers numerous benefits to its citizens. One of the most significant advantages is increased accessibility. Through online platforms, citizens can conveniently access government services and information without the need for physical visits to government offices. This not only saves time and money but also provides 24/7 availability, allowing citizens to complete tasks at their own convenience.

(v) An error situation that is unexpected in the program execution and causes it to terminate unexpectedly is called ____.
Answer: “exception” or “runtime exception”

(vi) Consider Payment Table with columns
Payment_id, Payment_amount, Payment_date, Mode.
Identify the Primary Key in the above given table.
Answer: Payment_id

Section B – Subjective Type Questions (30 Marks)

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

7. Suggest any four ways to maintain positive attitude.
Answer: Maintaining a positive attitude is essential for personal well-being and productivity. Here are four ways to help you maintain a positive attitude:
(i) Practice Gratitude
(ii) Surround Yourself with Positivity
(iii) Self-Care
(iv) Challenge Negative Thoughts

8. Mention any four most common environmental barriers that an entrepreneur may face.
Answer: Entrepreneurs often face various environmental barriers that can impact their business ventures. Four of the most common environmental barriers include:
(i) Regulatory and Legal Barriers
(ii) Economic Barriers
(iii) Market Competition
(iv) Technological and Industry Changes

9. Write a short note on the significance of self-awareness.
Answer: Self-awareness empowers better decision-making, emotional control, effective communication, and personal growth, enhancing overall well-being and success in both personal and professional life.

10. Write down the main steps to sort the data in Calc.
Answer: To sort data in Calc, follow these main steps:
Step 1: Select the range of cells that you want to sort.
Step 2: Click on “Data” in the menu and select “Sort.”
Step 3: Choose the column you want to sort by from the “Sort Key” list and specify the sorting order (ascending or descending).
Step 4: Click “OK” to apply the sort.

11. Why must a successful entrepreneur have self-confidence ? Discuss briefly.
Answer: Self-confidence is crucial for entrepreneurs as it fuels risk-taking, resilience, decision-making, and leadership, enabling them to navigate challenges and inspire others toward success.

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

12. What is the purpose of comments in Java ?
Answer: Comments in Java provide explanations and context within code, aiding developers in understanding, maintaining, and collaborating on software projects while not affecting program execution.

13. The following code has some error(s). Rewrite the correct code underlining all the corrections.
Class-12-IT-802-Previous-Year-Question-Paper-2023-compartment-Q13

int x, y;  // Corrected variable declaration and added a semicolon
x = 10;     // Corrected variable assignment
for (x = 20; x > 10; x--)  // Corrected the for loop syntax and condition
    y = y - 2;
System.out.println(y);  // Corrected the print statement and removed the extra curly brace

14. Write SQL command to create the following table :
Class-12-IT-802-Previous-Year-Question-Paper-2023-compartment-Q14

CREATE TABLE Gadget (
    G_ID CHAR(4),
    Description VARCHAR(20),
    Manufacture_Date DATE,
    Price DECIMAL,
    Warranty INT
);

15. Mention any two usages of a Database Management System in Hospitals.
Answer: Database Management Systems (DBMS) are widely used in hospitals for various purposes. Two common usages are:
(i) Patient Records: DBMS is used to store and manage patient records. This includes storing patient demographics, medical history, diagnostic reports, treatment plans, and billing information.
(ii) Inventory Management: Hospitals need to manage a vast inventory of medical supplies, equipment, and medications.

16. Suggest the datatypes for the following columns of Salary table to be created :
Emp_ID
Name
Basic Salary
HRA
DateofJoin
Net_Salary
Answer: You can use the following data types for the columns of the “Salary” table:

Field NameData Type
Emp_IDCHAR or VARCHAR
NameVARCHAR
Basic SalaryDECIMAL or NUMERIC
HRADECIMAL or NUMERIC
DateofJoinDATE or DATETIME
Net_SalaryDECIMAL or NUMERIC

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

17. Write any three domain names where database applications may be used. Also give one example of each of these three domains which can be developed to cater their respective needs.
Answer: Database applications are used in various domains to manage and process data efficiently. Here are three domain names and examples of database applications in each:
(i) Education Domain:
• Student Information System: A database application for educational institutions to manage student records, including enrollment, grades, attendance, and course schedules.
(ii) Manufacturing Domain:
• Production Planning and Control System: In manufacturing, a database application can be used for production planning, scheduling, and tracking. It helps optimize production processes, manage resources, and ensure timely delivery of products to meet customer demands.
(iii) Human Resources Domain:
• HR Management System: An HR database application streamlines employee data management, including personnel records, payroll, benefits, and performance evaluations.

18. Explain Syntax error with the help of a valid example.
Answer: A syntax error in Java occurs when the code you write does not adhere to the correct syntax rules of the Java programming language.
Here’s an example of a Java syntax error:

public class SyntaxErrorExample {
    public static void main(String[] args) {
        System.out.println("Hello, World!"
    }
}

In the code above, there is a missing semicolon ; at the end of the System.out.println statement. This is a common syntax error in Java. When you attempt to compile this code, you’ll receive an error message like this:

SyntaxErrorExample.java:4: error: ';' expected
        System.out.println("Hello, World!"
                                         ^

19. Explain Referential Integrity Constraint with valid example.
Answer: Referential integrity is a database constraint that ensures the relationships between tables in a relational database are maintained correctly. It enforces that relationships between tables are consistent, and it prevents actions that would violate these relationships, such as deleting a record from one table that is referenced by another table. This constraint is typically used in database management systems (DBMS) like MySQL
Here’s a valid example to explain referential integrity with two tables: “Students” and “Courses.”

CREATE TABLE Students (
    StudentID INT PRIMARY KEY,
    FirstName VARCHAR(50),
    LastName VARCHAR(50),
    CourseID INT,
    FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);

CREATE TABLE Courses (
    CourseID INT PRIMARY KEY,
    CourseName VARCHAR(100)
);

In this example:
• The “Students” table has a foreign key column called “CourseID” that references the “Courses” table’s “CourseID” primary key.
• The “CourseID” in the “Students” table is constrained by the referential integrity rule to only allow values that exist in the “CourseID” column of the “Courses” table. This ensures that students can only be associated with valid courses.

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

20. Consider the following table and write SQL statements for the given task :
Class-12-IT-802-Previous-Year-Question-Paper-2023-compartment-Q20
(i) Display all the records of the table Menu.
Answer: SELECT * FROM Menu;
(ii) Increase the prices of all Menu Items by 10.
Answer: UPDATE Menu SET Price = Price + 10;
(iii) Display the Description and Price in the ascending order of Price.
Answer: SELECT Description, Price FROM Menu ORDER BY Price ASC;
(iv) Display the structure of Table Menu.
Answer: DESCRIBE Menu;

21. Write a code in Java to print the squares of numbers from 1 to 5 by using for loop.

public class SquareNumbers {
    public static void main(String[] args) {
        for (int i = 1; i <= 5; i++) {
            int square = i * i;
            System.out.println("The square of " + i + " is: " + square);
        }
    }
}

22. Write a method Disp_sal() in Java to display Net Salary on the basis of Basic Salary, Allowance and Deductions to be passed as arguments of type double.
(Net Salary = Basic Salary + Allowance - Deductions)
If the Net Salary is more than 50,000, additional 2000 bonus is added.
Also display Net Salary.

public class SalaryCalculator {
    public static void main(String[] args) {
        double basicSalary = 50000.0;
        double allowance = 10000.0;
        double deductions = 5000.0;

        double netSalary = Disp_sal(basicSalary, allowance, deductions);
        
        System.out.println("Net Salary: " + netSalary);
    }

    public static double Disp_sal(double basicSalary, double allowance, double deductions) {
        double netSalary = basicSalary + allowance - deductions;
        
        // Check if the net salary is more than 50,000 and add a bonus if true
        if (netSalary > 50000) {
            netSalary += 2000;
        }
        
        return netSalary;
    }
}

23. Online shopping is playing a vital role in making our country a digital country. Write any two situations when online shopping can be more beneficial as compared to traditional offline shopping. Also discuss any two main precautions to be taken while shopping online.
Answer: Online shopping has become a significant contributor to the digital transformation of many countries. Here are two situations when online shopping can be more beneficial compared to traditional offline shopping:
(a) Convenience and Selection: Online shopping provides the convenience of shopping from anywhere, at any time. You can explore a vast selection of products from multiple retailers without the need to physically travel to different stores.
(b) Cost Savings and Comparisons: Online shopping often offers competitive prices and discounts. Shoppers can easily compare prices across different websites and find the best deals.

However, while online shopping offers numerous benefits, it’s essential to take precautions to ensure a safe and satisfying shopping experience. Here are two main precautions:
(a) Secure and Trusted Websites: Only shop from well-established websites. Verify that the website uses secure payment and look for “https://” in the website URL.
(b) Protect Personal Information: Be cautious when sharing personal and financial information online. Use strong and unique passwords for your online shopping accounts, and avoid using public Wi-Fi networks for making purchases.

24. Mention any two main points of difference between while and do-while statements. Also give the syntax of both.
Answer: In a while loop, the condition is evaluated before the loop body is executed. If the condition is initially false, the loop body may not execute at all whereas in a do-while loop, the condition is evaluated after the loop body is executed. This guarantees that the loop body will execute at least once, even if the condition is false.

while (condition) {
    // Code to be executed
}

do {
    // Code to be executed
} while (condition);

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