CBSE Class 12 Question Paper 2023 Information Technology (Solved)

Qu e st i o n

P a p e r
2023

:

(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) /

IÊS> H$ $
(dñVw{ZîR> àíZ) (30 A§H$)

1. amoµOJma H$m¡eb na {XE JE 6 àíZm| _| go {H$Ýht 4 àíZm| Ho$ CÎma Xr{OE & 4 1=4

(i) AÝ` ì`{º$`m| `m KQ>ZmAm| go ào[aV {H$gr ì`{º$ Ho$ A{^àoaU (motivation) H$mo
__________ H$hm OmVm h¡ & 1

(ii) ? 1

(iii) _________ EH$ Am`Vm ñàoS>erQ> _| {_bVo h¢ & 1

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 questions out of the given 6 questions on Employability
Skills. 4 1=4

(i)
____________. 1

(ii) What is stress ? 1

(iii) A ____________ is rectangle shaped box, where row and column meet
in a spreadsheet. 1

326 Page 3 of 19 P.T.O.

(iv) {ZíM`mË_H$ {ZU©`, CÚ{_Vm `mo½`VmAm| _| go EH$ h¡ & ~VmE± `h
ghr/JbV h¡ >& 1

(v) _wZm\$m H$_mZo Ho$ {bE H$mamo~ma ({~µOZog) ñWm{nV H$aZo Am¡a Cgo MbmZo VWm
Omo{I_ CR>mZo H$m H$m`© _______ H$hm OmVm h¡ & 1

(vi) Iwbo Am°{\$g H¡$ëH$ _| __________ _| o J`o
(selected) gob pñW{V H$mo àX{e©V H$aVm h¡ & 1
(a) \$m°_w©bm ~ma (b) ñQ>oQ>g ~ma
(c) _oZy ~ma (d) Q>mBQ>b ~ma

2. {XE JE 7 àíZm| _| go {H$Ýht 5 àíZm| Ho$ CÎma Xr{OE & 5 1=5

(i) Mmby S>mQ>m~og _| g¥{OV g^r gma{U`m| (tables) H$mo _______ H$_mÊS>
(command) àX{e©V H$aVr h¡ & 1
(a) SHOW DATABASES (b) SHOW TABLES >
(c) CREATE TABLES (d) DISPLAY TABLES

(ii) LIKE H$s-dS>© Ho$ gmW n¡Q>Z© _¡M H$aVo g_` ________ g§Ho$V (symbol) EH$
(single character) H$mo ~Xb XoVm h¡ & 1

(iii) AmCQ>nwQ> ~VmBE : 1

String myStr = "Welcome Users";

System.out.println("New String:"+myStr.toUpperCase());

(iv) __________ constraint Ho$ gmW Null d¡ë`y ~ZZo Ho$ {bE Attribute value
H$s AZw_{V Zht h¡ & 1

(v) Java _|, n¡H$o O go nyd© {Z{_©V (prebuilt) loUr Am¡a Bggo g§~§{YV nÕ{V`m| H$m
Cn`moJ H$aZo Ho$ {bE ______ statement à`moJ _| bmB© OmVr h¡ & 1
(a) include
(b) public
(c) extend
(d) import

326 Page 4 of 19

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

(v) The act of setting up and running a business and taking risks in
order to earn profits is known as ___________ . 1

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

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

(i) ______ command displays all the tables created in the current
database. 1
(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. 1

(iii) Predict the output : 1

String myStr = "Welcome Users";

System.out.println("New String:"+myStr.toUpperCase());

(iv) An attribute value may not be permitted to be NULL value with
__________ constraint. 1

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

326 Page 5 of 19 P.T.O.

(vi) ______ EH$ B©-H$m_g© EßbrHo$eZ h¡ {Og na J«mhH$ B§Q>aZoQ> go gm_mZ IarX gH$Vm
h¡ & $ 1
(vii) a§OZm Zo {ZåZ{b{IV ³doar (àíZ) Xr h¡ na§Vw `h Ìw{Q> {XIm ahm h¡ & Ìw{Q> H$mo R>rH$
H$a| Am¡a query H$mo Xþ~mam {b{IE & 1
SELECT * FROM PRODUCT
SORT BY PRICE; $

3. {XE JE 7 àíZm| _| go {H$Ýht 6 àíZm| Ho$ CÎma Xr{OE & 6 1=6

(i) Try block Ho$ nrN>o _______ blocks AmVo h¢ & BZ_| exception handler-
specific code hmoVm h¡ {OgH$m {ZînmXZ exception Ho$ ~mX {H$`m OmVm h¡ & 1

(ii) AñnmbmV Ho$ joÌ _| Database Management System (S>mQ>m~og à~§YZ
àUmbr) H$m H$moB© Cn`moJ Zht hmo nm`m & Cn`©wº$ H$WZ ghr h¡ `m JbV h¡ ? 1

(iii) NeGP H$m AW© h¡ ________ 1

(iv) _______ H$_m§S> H$m à`moJ gmaUr Ho$ ê$n Am¡a {ddaU H$mo {XImZo Ho$ {bE {H$`m
OmVm h¡ & 1
(a) DESCRIBE
(b) SELECT
(c) SHOW
(d) DISPLAY

(v) Referential Integrity H$s ì`m»`m H$s{OE & 1
(vi) Compiler ¡? $ 1
(vii) Omdm _| {H$Ýht Xmo Primitive datatypes Ho$ Zm_ ~Vm`| & $ 1

4. {XE JE 6 àíZm| _| go {H$Ýht 5 àíZm| Ho$ CÎma Xr{OE & 5 1=5

(i) {H$gr {d{eîQ> H$m`© H$mo H$aZo Ho$ {bE _________ EH$ {b{IV {ddaU g_yh h¡ & 1
(a) Method
(b) Class
(c) Comment
(d) Variable

326 Page 6 of 19

(vi) _____________________ is an e-commerce application where the
customer can purchase goods over the Internet. 1
(vii) Ranjana has written the following query but it is giving an error.
Rectify the error and rewrite the query. 1
SELECT * FROM PRODUCT
SORT BY PRICE;

3. Answer any 6 out of the given 7 questions. 6 1=6
(i) The _______ blocks follow a try block. It contains the exception
handler-specific code that is executed when the exception occurs. 1
(ii) in hospital
lse ? 1
(iii) NeGP stands for ___________ . 1
(iv) The _________ command is used to view the structure and
description of a table : 1
(a) DESCRIBE
(b) SELECT
(c) SHOW
(d) DISPLAY

(v) Define Referential Integrity. 1

(vi) What is a Compiler ? 1

(vii) Name any two Primitive datatypes in Java. 1

4. Answer any 5 out of the given 6 questions. 5 1=5
(i) A ___________ is a group of statements written to perform a specific
task. 1
(a) Method
(b) Class
(c) Comment
(d) Variable
326 Page 7 of 19 P.T.O.

(ii) {X`o J`o Omdm H$moS> Ho$ output H$mo ~VmBE & 1
String first_name = "Priyank";
String last_name = "Arora"
System.out.println(first_name.length()+last_name.le
ngth());

(iii) \o$O _| h_ CZHo$ ~rM
~¡H$E§S> S>oQ>m~og, \ ? 1
(a) [a³dm`a_|Q> (Requirement)
(b) {S>µOmBZ (Design)
(c) Bånbr_|Q>oeZ (Implementation)
(d) Q>oñQ> (Test)

(iv) {ZåZ{b{IV _| go H$m¡Zgm constraint `h ~VmVm h¡ {H$ àË`oH$ tuple
g§J«h) _| àË`oH$ attribute H$m _yë` (value) Cg attritube Ho$ domain go
hmoZm Mm{hE ? 1
(a) Domain Constraint
(b) Key Constraint
(c) Null Value Constraint
(d) Entity Integrity Constraint

(v) _______ H$_mÊS> H$m à`moJ H$aHo$ S>oQ>m~og (database) H$mo hQ>m`m Om gH$Vm h¡ & 1

(vi) `{X variable a H$m _yë` 1 h¡ Vmo {ZåZ{b{IV H$moS> H$m output hmoJm ?$ 1
switch (a)
{
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;
}

326 Page 8 of 19

(ii) Predict the output of the given Java code : 1
String first_name = "Priyank";
String last_name = "Arora"
System.out.println(first_name.length()+last_name.le
ngth());
(iii) In which of the following phase of web based application project, we
create backend database, frontend and the connectivity between
them ? 1
(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. ? 1
(a) Domain Constraint
(b) Key Constraint
(c) Null Value Constraint
(d) Entity Integrity Constraint
(v) Database can be removed by using ____________ command 1
(vi) What will be the output of the following code if value of variable a
is 1 ? 1
switch (a)

{
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;

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

5. {XE JE 6 àíZm| _| go {H$Ýht 5 àíZm| Ho$ CÎma Xr{OE & 5 1=5

(i) d¡~ AmYm[aV EßbrHo$eZ (application) \«§$Q> EÊS> (Front
End) H$mo ñnîQ> H$s{OE & 1

(ii) {H$gr dJ© Ho$ members H$mo dJ© (class) go ~mha àmá Zht {H$`m Om gH$Vm & 1

(iii) Create Table EH$ ________ H$_m§S> h¡ & 1

(iv) {H$Ýht Xmo do~ ~«mCOg© Ho$ Zm_ ~VmBE & 1

(v) Q´>oZ Ho$ {Q>{H$Q> ~wH$ H$aZo Ho$ {b`o ^maV gaH$ma Ho$ nmoQ>©b (portal) H$m Zm_
~VmBE & 1

(vi) Omdm _| pñQ´>¨J (string) (concatenate) Ho$
{bE à`wº$ nÕ{V H$m Zm_ ~VmBE & 1

6. {XE JE 6 àíZm| _| go {H$Ýht 5 àíZm| Ho$ CÎma Xr{OE & 5 1=5

(i) RDBMS n¡H$o Om| H$m à`moJ ì`mnH$ ê$n go __________ Ho$ ê$n _|
(Frontend/Backend) {H$`m OmVm h¡ & 1

(ii) ^maV gaH$ma Ûmam CR>m`o J`o {H$gr EH$ e-governance (B©-JdZ]g) nhb
(initiative) 1

(iii) Bytecode ? 1

(iv) d¡~ EßbrHo$eZ V¡`ma H$aZo _| Requirement, __________, Implementation
Am¡a Testing CgHo$ H«$_ (Phase) h¢ & 1

(v) {ZåZ{b{IV _| go H$m¡Z Omdm H$m/Ho$ H$s-dS>© (keyword) Zht h¡/h¢ ? 1
break, While, for, switch, Display

(vi) S>oQ>m~og Ho$ _yë` dJ© Ho$ H${Vn` J{UVr` H$m`m]
(group of values)
(mathematical functions) Ho$ {bE à`wº$ functions (H$m`©) __________
H$ho OmVo h¢ & $ 1

326 Page 10 of 19

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

(i) Define Front End, with respect to web based application project. 1

(ii) __________ members of a class cannot be accessed outside the class. 1

(iii) Create Table is a __________ command. 1

(iv) Name any 2 web browsers. 1

(v) Name the Indian Government portal for booking train tickets. 1

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

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

(i) RDBMS packages are widely used as ______ (Frontend/Backend) 1

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

(iii) What is a Bytecode ? 1

(iv) Requirement, __________, Implementation and Testing are the
phases in Web Application Development. 1

(v) Which of the following is/are not a keyword in JAVA ? 1

break, While, for, switch, Display

(vi) The functions that are used to apply certain mathematical functions
on a group of values in a database are called __________. 1

326 Page 11 of 19 P.T.O.

IÊS> I $
(ì`{º${ZîR> àíZ) (30 A§H$)
5 3

20 30 3 2=6

7. gH$mamË_H$ ÑpîQ>H$moU (positive attitude) Ho$ _hÎd na g§jon _| MMm© H$s{OE & 2

8. {H$Ýht Xmo àH$ma Ho$ CÚ{_`m| (entreprereurs) Ho$ Zm_ ~VmE± & 2

9. H¡$ëH$ (Calc) Ho$ Tabular data _| filter à`moJ H$aZo Ho$ _w»` H$X_m| (steps) H$mo

{b{IE & 2

10. CÚ{_Vm (entrepreneurship) Ho$ gm_Zo AmZo dmbr {H$Ýht Xmo Am_
H$s{OE & 2

11. ì`{º$Ëd {dH$mam| (personality disorders) H$mo Xÿa H$aZo
H$s{OE & 2

5 3 20 30 3 2=6

12. Q>o~b {d^mJ (table Department) _| _mH}$qQ>J go goëg VH$ \$sëS> {S>nmQ>©_|Q> Ho$
_yë` H$mo g§emo{YV H$aZo H$s n¥ÀN>m (query) H$mo {b{IE & 2

13. Omdm _| try Am¡a catch Ho$ à`moJ Ho$ CÔoí` h¢ ? 2

14. Omdm _| 2

15. (Database Management Systems) Ho$ {H$Ýht Xmo à_wI
oI H$s{OE & 2

326 Page 12 of 19

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

7. Briefly discus the importance of positive attitude. 2

8. Name any two types of Entrepreneurs. 2

9. Write down the main steps to apply filter to a tabular data in Calc. 2

10. Mention any two common barriers to entrepreneurship. 2

11. Mention any two steps to overcome personality disorders. 2

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

12.

in the table Department. 2

13. What is the purpose of using try and catch statements in JAVA ? 2

14. Explain any two methods of String class in Java with suitable example. 2

15. Mention any two major significances of Database Management System. 2

326 Page 13 of 19 P.T.O.

16. [aº$ ñWmZm| H$mo ^[aE & 1+1=2

(H )$ {H$gr relation _| attributes H$s g§»`m __________ H$hbmVr h¡ & 1

(I)$ {H$gr SELECT (repetition) go ~MZo Ho$ {b`o

_________ clause H$m à`moJ {H$`m OmVm h¡ & 1

3 2 30 50 2 3=6

17. {ejm joÌ _| database applications Ho$ Cn`moJ Ho$ {H$Ýht VrZ _w»` CÔoí`m| H$s MMm©
H$s{OE & 3

18. Switch statement H$m Cn`moJ H$aVo hþE {ZåZ{b{IV àmoJ«m_ H$moS> H$mo Xþ~mam
{b{IE : 3
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");
}

326 Page 14 of 19

16. Fill in the blanks. 1+1=2

(a) The number of attributes in a relation is called the __________ of a
relation. 1

(b) To avoid repetition in the result of a SELECT Query _________
clause is used. 1

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

17. Discuss any three main purposes of using Database applications in
education domain. 3
18. Rewrite the following program code using switch statement : 3

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");
}

326 Page 15 of 19 P.T.O.

19. (i) S>r.~r.E. (Database Administrator) 1

(ii) gZm Zo {ZåZ{b{IV Xr h¡ na§Vw dh BgH$m g\$b {ZînmXZ H$aZo _| Ag_W© h¡ &
Ìw{Q> H$mo R>rH$ H$aVo hþE ghr (query) {b{IE & 2

SELECT NAME, MARKS

FROM STUDENT TABLE

WHERE NAME = "P%"

5 3 50 80 3 4=12

20. HAVING clause ? `h SQL _| WHERE clause go {H$g àH$ma

{^Þ h¡ ? AnZo CÎma Ho$ g_W©Z _| CXmhaU Xr{OE & 4

21. Online tutorials (B§Q>aZoQ> {ejU) Ho$ \$m`Xm| Ho$ ~mao _| {b{IE & 4

22. Object Oriented Programming language (dñVwnaH$ ^mfm H$m`©H«$_)

_mZm OmVm h¡ ? CXmhaUm| H$s ghm`Vm go S>oQ>m _oå~g© (data members) Am¡a _oå~a

àUm{b`m| (member methods) H$mo ñnîQ> H$s{OE & 4

23. (i) Omdm EH$ Platform independent language (ßboQ>\$m_© a{hV ^mfm) h¡ & Bg
H$WZ H$s gË`Vm {gÕ H$s{OE & 2

(ii) Omdm _| Xmo [aboeZb Am°naoQ>g© (relational operators) Am¡a Xmo (logical
operators) H$mo ~VmBE & 2

326 Page 16 of 19

19. (i) State the role of a DBA (Database Administrator). 1

(ii) Sana has given the following query but she is unable to execute it
successfully. Write the correct query after rectifying the error 2

SELECT NAME, MARKS

FROM STUDENT TABLE

WHERE NAME = "P%"

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

20. What is the purpose of HAVING clause ? How is it different from WHERE

clause in SQL ? Give example to support you answer. 4

21. Write advantages of online tutorials. 4

22. Why is Java considered as an Object Oriented Programming language ?

Explain data members and member methods with the help of an example. 4

23. (i) 2

(ii) Give two relational operators and two logical operators in Java. 2

326 Page 17 of 19 P.T.O.

24. {ZåZ{b{IV H$moS> H$m output ~VmBE : 2

(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);

}

}

(ii) Omdm _| {Q>ßn{U`m± {bIZo Ho$ H$m¡Z go Xmo VarHo$ h¢ ? 2

326 Page 18 of 19

24. Write the output of following code: 2

(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);

}

}

(ii) What are the two ways to write comments in Java ? 2

326 Page 19 of 19 P.T.O.