CBSE Class 12 Question Paper 2025 Information Technology

Series : 4YWZX Set 4
>
-
Q.P. Code 326
Roll No. - -
-
Candidates must write the Q.P. Code
on the title page of the answer-book.

INFORMATION TECHNOLOGY
3 60
Time allowed : 3 hours Maximum Marks : 60

- 19
- - - -
- 24
, -

- 15 -
10.15 10.15 10.30 -
-
Please check that this question paper contains 19 printed pages.
Q.P. Code given on the right hand side of the question paper should be
written on the title page of the answer-book by the candidate.
Please check that this question paper contains 24 questions.
Please write down the Serial Number of the question in the
answer-book at the given place before attempting it.
15 minute time has been allotted to read this question paper. The question
paper will be distributed at 10.15 a.m. From 10.15 a.m. to 10.30 a.m., the
candidates will read the question paper only and will not write any answer
on the answer-book during this period. #

326 Page 1 of 19 # P.T.O.

(i)
(ii) - 24
(iii)
(iv) (6 + 18) = 24 , 3
(6 + 11) = 17
(v)
(vi) 30
(a) 6
(b)
(c)
(d)
(vii) 30
(a) 18
(b) 11
(c)
(d)

( ) (30 )

1. 6 4 4×1=4
(i) _____________
(encode)
(ii) -
?
(A)
(B)
(C)
(D)
(iii) : (Personality Disorders)

326 Page 2 of 19 #

General Instructions :
(i) Please read the instructions carefully.
(ii) This question paper consists of 24 questions in two Sections : Section A
and Section B.
(iii) Section A has Objective type questions whereas Section B contains
Subjective type questions.
(iv) 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.
(v) All questions of a particular section must be attempted in the correct
order.
(vi) Section A : Objective Type Questions (30 marks) :
(a) This section has 6 questions.
(b) There is no negative marking.
(c) Do as per the instructions given.
(d) Marks allotted are mentioned against each question/part.
(vii) Section B : Subjective Type Questions (30 marks) :
(a) This section has 18 questions.
(b) A candidate has to do 11 questions.
(c) Do as per the instructions given.
(d) 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. 4 1=4

(i) _____________ is an element of communication which encodes and
sends messages through a channel.

(ii) To maintain a positive attitude, which one of the following is not a
good practice ?
(A) Feed the mind with positivity
(B)
(C) Move towards your goals and dreams
(D) Start the day with a morning routine

(iii) -term
patterns of thoughts and behaviours that are unhealthy and rigid.

326 Page 3 of 19 # P.T.O.

(iv) (Spreadsheet software) __________ (Vertical)
(Cells)
(v) _____________ ,

(A) (Decisiveness)
(B) (Interpersonal skills)
(C) (Perseverance)
(D) (Taking initiative)
(vi) CNG _____________

2. 7 5 5 1=5

(i) DBMS _____________

(ii) Java statements _____________

(iii) _____________ language RDBMS

(iv) (Relational models) _____________
(Relation)

(v) IRCTC :
(A) International Railway Catering and Tourism Corporation
(B) Indian Railway Controlling and Transport Corporation
(C) Indian Railway Catering and Tourism Corporation
(D) International Railway Controlling and Transport
Corporation
(vi) - SQL (Valid) data type ?
(A) CHAR(n) (B) VARCHAR(n)
(C) STR(n) (D) DATE

(vii) (Web application) _____________
(Server)
(A) Remote (B) Voice
(C) Local (D) Data

326 Page 4 of 19 #

(iv) In the spreadsheet software, a _____________ is an arrangement of
cells in a vertical (standing) manner.
(v) _____________ is one of the most important attitudes of an
entrepreneur, which is defined as the ability to continue to do
something, even when it is difficult.
(A) Decisiveness
(B) Interpersonal skills
(C) Perseverance
(D) Taking initiative
(vi) CNG stands for _____________ .

2. Answer any 5 out of the given 7 questions. 5 1=5

(i) DBMS stands for _____________ .

(ii) All Java statements must end with a/an _____________ .

(iii) _____________ is a language that is used to manage data stored in an
RDBMS.

(iv) In relational models, a _____________ is called a relation.

(v) IRCTC online portal for booking train tickets stands for :
(A) International Railway Catering and Tourism Corporation
(B) Indian Railway Controlling and Transport Corporation
(C) Indian Railway Catering and Tourism Corporation
(D) International Railway Controlling and Transport
Corporation

(vi) Which of the following is not a valid data type of SQL ?
(A) CHAR(n) (B) VARCHAR(n)
(C) STR(n) (D) DATE

(vii) A web application is a program that is stored on a _____________
server.
(A) Remote (B) Voice
(C) Local (D) Data

326 Page 5 of 19 # P.T.O.

3. 7 6 6 1=6

(i) - (e-learning websites)

(ii) (language) _____________

(iii) ORDER BY clause ASC DESC
(Query) ?
(iv) _____________ (National web portal of India)
,
(Single window access)

(v) (existing table)
(table) SQL
(Command) ?
(A) INSERT
(B) UPDATE
(C) MODIFY
(D) ALTER

(vi) - (Online Transaction) _____________

(A) (Alphabets) (Special symbols)

(B)
(C)
(D)

(vii) (variables) (declare)
(initialize) ?

326 Page 6 of 19 #

3. Answer any 6 out of the given 7 questions. 6 1=6

(i) Name any two popular e-learning websites.

(ii) A computer can understand only its own language called
_____________ .

(iii) Kritika did not use ASC or DESC keyword with ORDER BY clause. By
default in which order will the result of the query be displayed ?

(iv) _____________ is the national web portal of India, which provides a
single window access to information and services being provided by
the various Indian government entities.

(v) Rahul forgot to add a column in the existing table. Which one of the
following SQL commands can he use to add the desired column in
the table ?
(A) INSERT
(B) UPDATE
(C) MODIFY
(D) ALTER

(vi) _____________ makes the password safer for online transactions.
(A) Combination of alphabets, special symbols and numbers
(B) Use of personal mobile number
(C) Use of name of near and dear ones
(D) Use of date of birth of mother

(vii)

326 Page 7 of 19 # P.T.O.

4. 6 5 5 1=5

(i) (Frontend) (Backend)
(Connectivity), (web application project)
__________

(ii) (tuple) (attribute) (value)
_____________
(value)
(A) EMPTY
(B) BLANK
(C) NULL
(D) VOID

(iii) (National Satellite) _____________
1987 - (e-governance)
(A) NICNET
(B) DEITY
(C) NEGP
(D) NEGD

(iv) (Java programming language) Variable
?
(v) SQL Query (duplicate values)
(SELECT Statement)
_____________ (keyword)

(vi) (Java) (Array) (declare)
(initialize) (valid statement) :
(A) int[] marks;
(B) int[] marks = {60, 70, 90};
(C) int[] marks = (60, 70, 90);
(D) int[] marks = [60, 70, 90];

326 Page 8 of 19 #

4. Answer any 5 out of the given 6 questions. 5 1=5

(i) Connectivity between Frontend and Backend project will be done in
_____________ phase of a web application project.

(ii) If the value of an attribute in a tuple is not known or not applicable or
not available, a special value called _____________ is used to represent
them.
(A) EMPTY
(B) BLANK
(C) NULL
(D) VOID

(iii) In India the main thrust for e-governance was provided by the
launching of _____________, the national satellite-based computer
network in 1987.
(A) NICNET
(B) DEITY
(C) NEGP
(D) NEGD

(iv) What is a variable in Java programming language ?
(v) _____________ keyword is used in SELECT statement along with
column name to display duplicate values once in the result of an
SQL query.

(vi) Select the valid statement to declare and initialize an array in Java :
(A) int[] marks;
(B) int[] marks = {60, 70, 90};
(C) int[] marks = (60, 70, 90);
(D) int[] marks = [60, 70, 90];

326 Page 9 of 19 # P.T.O.

5. 6 5 5 1=5
(i) (Domains) (database application)
- ?
(A) (Education Database Application)

(B) (Hospital Database Application)

(C) (Banking Database Application)

(D) (Government Database Application)
(electoral roll)

(ii) DBMS _____________

(Specification)
(A) (DBA)
(B) (Application Programmers)
(C) (System Analyst)
(D) (Tester)

(iii) (try block) (statement)
(throw) (Exception) _____________ block
(handle)
(A) final (B) throw
(C) catch (D) except

(iv) Employee (Employee table) Salary blank
Salary - (Constraint) ?
(A) NOT NULL (B) DEFAULT
(C) CHECK (D) NOT BLANK

326 Page 10 of 19 #

5. Answer any 5 out of the given 6 questions. 5 1=5

(i) Which of the following statements is incorrect related to database
application used in the domains ?
(A) Education Database Application is used to store data of
students and staff.

(B) Hospital Database Application is used to record data of
patients.
(C) Banking Database Application is used to record details of
stock of medicines.

(D) Government Database Application is used to store details of
electoral roll.

(ii) Out of many types of DBMS users, _____________ is responsible to
determine the requirements of the end users and then develop
specifications to meet the requirements.

(A) DBA

(B) Application Programmers

(C) System Analyst

(D) Tester

(iii) Exception thrown by any statement in try block in a Java program
is handled in _____________ block.

(A) final (B) throw

(C) catch (D) except

(iv) Rashmi is not able to leave a blank in the Salary column of the
Employee table. Which constraint is applied on the field Salary ?

(A) NOT NULL (B) DEFAULT
(C) CHECK (D) NOT BLANK

326 Page 11 of 19 # P.T.O.

(v) (multiline comments)
?
(A) forward slashes (//)
(B) /* */ (Symbols)
(C) # (Comment line)
(D) /# #/
(vi) Java interpreter byte code
(machine code) (execute)

6. 6 5 5 1=5
(i) Java class (visible) class (data
member) (method member)
(Access modifier) ?
(A) public (B) protected
(C) default (D) private
(ii) Flipkart eBay _____________ (shopping stores)

(iii) (Web browsers)
(Websites) (browsing)
(iv) _____________
(grouped statements)
(A) Array (B) Object
(C) Class (D) Method
(v) (Java) , (Values) (value)
(Matching Code) (execution) ___________
(statement)
(vi) Java package scanner class ?
(A) java.util (B) java.applet
(C) java.net (D) java.lang

326 Page 12 of 19 #

(v) Which is the correct way to write multiline comments in a Java
program ?

(A) Beginning a comment line with two consecutive forward
slashes(//).

(B) Writing a comment between the symbols /* and */.

(C) Beginning a comment line with # symbol.

(D) Writing the comment between the symbols /# and #/.

(vi) Name the Java interpreter that translates the byte code into
machine code and then executes it.

6. Answer any 5 out of the given 6 questions. 5 1=5
(i) Which access modifier in Java is used to make a data member or a
method member of a class visible only within the class ?
(A) public (B) protected
(C) default (D) private

(ii) Flipkart and eBay are examples of _____________ shopping stores.
(iii) Write the names of any two web browsers which help us to browse
various websites over the Internet.
(iv) A/An _____________ in Java is a block of statements grouped
together to perform a specific task.
(A) Array (B) Object
(C) Class (D) Method

(v) In Java, _____________ statement is used to execute a block of code
matching one value out of many possible values.

(vi) In which Java package is the scanner class available ?
(A) java.util (B) java.applet
(C) java.net (D) java.lang

326 Page 13 of 19 # P.T.O.

$
30

5 3 20 30
=6

7. (Green Job) ? 2

8. (digital presentation)
(presentation softwares) 2

9. 2

(a) (Personality)

(b) (Personality traits)

10. (barriers)
(enterpreneur) 2

11. (Active listening) (factors)
2

5 3 20 30 =6
12. Java statements output 1+1

(a) System.out.println ("30+20");
(b) System.out.println ("Information Technology" + 802);

13. >(Database Management System)
2

14. >SQL LIKE operator % (underscore)
? 2

15. >Java IDE ? Java IDE 1+1

16. (database application)
2

326 Page 14 of 19 #

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. 3 2=6

7. What is a Green Job ? 2

8. To create a digital presentation, suggest the names of any two popular
presentation softwares. 2

9. Briefly explain the following terms : 2

(a) Personality

(b) Personality traits

10. Mention any four most common environmental barriers which an
entrepreneur may face while running his/her venture. 2

11. Briefly explain any two factors that affect active listening. 2

Answer any 3 out of the given 5 questions in 20 30 words each. 3 2=6

12. What will be the output of the following Java statements : 1+1

(a) System.out.println ("30 + 20");

(b) System.out.println ("Information Technology" + 802);

13. >Write any two characteristics of Database Management System. 2

14. >What is the purpose of % and _ (underscore) characters used with LIKE
operator in SQL ? 2

15. >What is Java IDE ? Name any one commonly used Java IDE. 1+1

16. >List any two ways in which database application is used in the Banking
Sector. 2

326 Page 15 of 19 # P.T.O.

3 2 30 50 3 2=6
17. for loop number 5 (factorial)
(calculate) (display) 3

18. SQL > (aggregate functions) 3

19. (New Trends Fashion Company)
(Database Application)
(website) database 6
entities 3

5 3 50 80 3 4=12

20. (String Variables) : 1+1+1+1
String str1 = "Hello";
String str2 = "Java Programming";

(Code statements) :
(a) str1 upper case
(b) str2 6 character
(c) str1 l first occurrence index value

(d) l str1

21. > (Entry controlled loop) (Exit controlled
loop) 4

22. >(Online learning) 4

23. (a) (threads)

(b) (Java Programming) (Assertion)
(Assertion) 2+2

326 Page 16 of 19 #

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

17. >Write a Java program to calculate and display the factorial of a number 5
using for loop. 3

18. >Explain the use of any three aggregate functions in SQL. 3

19. >Varun is the owner of New Trends Fashion Company that deals in
garments. He wants to make a Database Application for his company.
Suggest any six possible entities that can be used in the database for his
website. 3

Answer any 3 out of the given 5 questions in 50 80 words each. 3 4=12

20. Consider the following string variables : 1+1+1+1
String str1 = "Hello";
String str2 = "Java Programming";

Write the code statements for the following in Java :

(a) To display the string str1 into upper case.

(b) To display the character at the index 6 in string str2.

(c) To display the index of the first occurrence of letter l in
the string str1.

(d) To display the string str1 after replacing letter with '*'.

21 >Differentiate between Entry controlled loop and Exit controlled loop. 4

22. >Explain any four advantages of online learning. 4

23. (a) What are the different ways to create threads in Java programming ?

(b) With reference to Java programming language, define assertion.
State any one way to write an assertion. 2+2

326 Page 17 of 19 # P.T.O.

24. GARMENT (table) 1+1+1+1

GCODE GNAME SIZE COLOUR PRICE
111 TShirt XL Red 1400
112 Jeans L Blue 1600
113 Skirt M Black 1100
114 Ladies Jacket XL Blue 4000
115 Trousers L Brown 1500
116 Ladies Top L Pink 1200

SQL :

(a) (display)

(b) 115

(c) data row
GCODE = 117
GNAME = Kurta
SIZE = M
COLOUR = White
PRICE = 1000

(d) (Table)

326 Page 18 of 19 #

24. Consider the given table GARMENT : 1+1+1+1

GCODE GNAME SIZE COLOUR PRICE
111 TShirt XL Red 1400
112 Jeans L Blue 1600
113 Skirt M Black 1100
114 Ladies Jacket XL Blue 4000
115 Trousers L Brown 1500
116 Ladies Top L Pink 1200

Write SQL commands for the following :

(a) To display names of those garments that are available in size.

(b) To change the colour of garments with code as 115 to .

(c) To add a new row with the following data :
GCODE = 117
GNAME = Kurta
SIZE = M
COLOUR = White
PRICE = 1000

(d) To remove the column from the table .

326 Page 19 of 19 # P.T.O.