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

by

Series ∊FGHE/C
Question Paper Code 326 Set 4

INFORMATION TECHNOLOGY – COMPARTMENT
(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.

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

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

(iv) Mention any one quality that makes an entrepreneur successful.

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

(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.

(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.

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

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

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

(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.

(ii) Name any two primitive data types in Java.

(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 ?

(vi) What are the different payment methods while buying online ?

(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.

(iii) JVM stands for _____.

(iv) The statement evaluates the test after executing the body of a loop.

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

(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.

(ii) Name any two aggregate functions used in SQL.

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

(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.

(ii) Give examples of any two online educational websites.

(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 ?

(v) An error situation that is unexpected in the program execution and causes it to terminate unexpectedly is called ____.

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

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.

8. Mention any four most common environmental barriers that an entrepreneur may face.

9. Write a short note on the significance of self-awareness.

10. Write down the main steps to sort the data in Calc.

11. Why must a successful entrepreneur have self-confidence ? Discuss briefly.

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 ?

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

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

15. Mention any two usages of a Database Management System in Hospitals.

16. Suggest the datatypes for the following columns of Salary table to be created :
Emp_ID
Name
Basic Salary
HRA
DateofJoin
Net_Salary

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.

18. Explain Syntax error with the help of a valid example.

19. Explain Referential Integrity Constraint with valid example.

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.
(ii) Increase the prices of all Menu Items by 10.
(iii) Display the Description and Price in the ascending order of Price.
(iv) Display the structure of Table Menu.

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

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.

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.

24. Mention any two main points of difference between while and do-while statements. Also give the syntax of both.

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