CBSE Class 12 Question Paper 2024 Information Technology

CBSE

Set-4
Series &RQPS
àíZ-nÌ H$moS>
Q.P. Code
326
amob Z§. narjmWu àíZ-nÌ H$moS> >H$mo CÎma-nwpñVH$m Ho$
Roll No. _wI-n¥ð >na Adí` {bIo§ &
Candidates must write the Q.P. Code
on the title page of the answer-book.

gyMZm àm¡Úmo{JH$s
INFORMATION TECHNOLOGY

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

ZmoQ> NOTE
(I) H¥$n`m Om±M H$a b| {H$ Bg àíZ-nÌ _o§ _w{ÐV (I) Please check that this question paper
contains 19 printed pages.
n¥ð> 19 h¢ &
(II) H¥$n`m Om±M H$a b| {H$ Bg àíZ-nÌ _| (II) Please check that this question paper
contains 24 questions.
>24 àíZ h¢ &
(III) àíZ-nÌ _| Xm{hZo hmW H$s Amoa {XE JE (III) Q.P. Code given on the right hand side of
the question paper should be written on
àíZ-nÌ H$moS >H$mo narjmWu CÎma-nwpñVH$m Ho$ the title page of the answer-book by the
_wI-n¥ð> na {bI| & candidate.
(IV) H¥$n`m àíZ H$m CÎma {bIZm ewê$ H$aZo go (IV) Please write down the serial number of
the question in the answer-book before
nhbo, CÎma-nwpñVH$m _| àíZ H$m H«$_m§H$ attempting it.
Adí` {bI| &
(V) Bg àíZ-nÌ 15 {_ZQ (V) 15 minute time has been allotted to read
this question paper. The question paper
>H$m g_` {X`m J`m h¡ & àíZ-nÌ H$m will be distributed at 10.15 a.m. From
10.15 ~Oo {H$`m OmEJm & 10.15 a.m. to 10.30 a.m., the students will
10.15 ~Oo go 10.30 ~Oo VH$ N>mÌ Ho$db read the question paper only and will not
àíZ- write any answer on the answer-book
during this period.
do CÎma-nwpñVH$m na H$moB© CÎma Zht {bI|Jo &
11-326 1 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) /

IÊS> H$ $
(dñVw{ZîR> àH$ma Ho$ àíZ) (30 A§H$)
1. amoµOJma H$m¡eb na {XE JE 6 àíZm| _| go {H$Ýht 4 Ho$ CÎma Xr{OE & 4 1=4
(i) ________ EH$ eãX g_yh h¡ Omo nyU© AW© H$m g§àofU H$aVm h¡ &
(ii) n[adUu (acronym) eãX _| bú` {ZYm©[aV H$aZo Ho$ {bE Aja H$m
AW© ________ h¡ &
(iii) ________ naoemZr, AàgÞVm Am¡a {Zamem H$s ^mdZm H$s EH$ pñW{V h¡ &
(iv) ñàoS>erQ> _| ________ MwZo JE gob (cell) H$s AdpñW{V (location) H$mo àX{e©V
H$aVm h¡ &
(v) ________ CÚ_r EH$ àH$ma H$m CÚ_r h¡ Omo CgH$s godmAm| Ho$ {bE EH$ Z`m
~mµOma {Z{_©V H$aVm h¡ AWdm {dÚ_mZ ~mµOma _| godm àXmZ H$aVm h¡ &
(vi) ________ \$m{_ªJ (farming) dh à{H«$`m h¡ {OgHo$ Ûmam h_ n`m©daUr` AZwHy$b
VarHo$ go nm¡Yo CJm gH$Vo h¢ &
11-326 2

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) A ________ is a group of words that communicate a complete
meaning.
(ii)
(iii) ________ is a state of feeling upset, annoyed and hopeless.
(iv) In a spreadsheet, the ________ shows the location of selected cell.
(v) A/An ________ entrepreneur is a type of entrepreneur who creates a
new market for his services or provides a service in an existing
market.
(vi) ________ farming is the process by which we can grow plants in an
environmental friendly way.

11-326 3 P.T.O.

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

(i) S>oQ>m àmogoqgJ Ho$ Ûmam ________ H$mo àmá {H$`m OmVm h¡ &
(ii) Omdm Ûmam {H$VZo {à{_{Q>d S>oQ>m Q>mBßg (data types) H$m g_W©Z (support) {H$`m
OmVm h¡ ?
(iii) S>oQ>m~og go gmaUr (table) H$mo hQ>mZo Ho$ {bE {ZåZ{b{IV _| go H$m¡Z-gr H$_m§S>
(command) H$m à`moJ {H$`m OmVm h¡ ?
(A) Delete (B) Drop
(C) Remove (D) Pop

(iv) Xr JB© pñQ´>¨J (String) Ho$ A§V _| {d{Z{X©îQ> pñQ´>¨J H$mo loUr~Õ (concatenate)
H$aZo Ho$ {bE Omdm _| ________ nÕ{V H$m à`moJ {H$`m OmVm h¡ &
(v) NeGD H$m AW© h¡ ________ &
(A) National e-Governance District
(B) National e-Government Draw
(C) National e-Governance Division
(D) National e-Government Discord

(vi) Omdm dMw©Ab _erZ (Java Virtual Machine) ¡?
(vii) do~ ~oñS> EoßbrHo$eZ S>odbn_|Q> (web based application development) Ho$
(feasibility) H$s Om±M H$s OmEJr ?

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

(i) Omdm (Java) _| {H$Ýht Xmo bm°{OH$b Am°naoQ>g© Ho$ Zm_ {b{IE &
(ii) ghr `m µJbV ~VmBE & Omdm nmoQ>}~b b¢½doO (portable language) Zht h¡ &
(iii) Table _| {H$gr attribute Ho$ g^r values H$m Am¡gV {ZH$mbZo Ho$ {bE SQL _|
________ aggregate function H$m Cn`moJ {H$`m OmVm h¡ &
(A) MAX (B) MIN
(C) AVG (D) COUNT

11-326 4

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

(i) ________ is produced by processing data.

(ii) How many primitive data types are supported by Java ?

(iii) Which one of the following commands is used to delete the table
from the database ?

(A) Delete (B) Drop

(C) Remove (D) Pop

(iv) ________ method in Java is used to concatenate the specified string
at the end of the given string.

(v) NeGD stands for ________.
(A) National e-Governance District
(B) National e-Government Draw
(C) National e-Governance Division
(D) National e-Government Discord

(vi) What is the advantage of Java Virtual Machine ?

(vii) In which phase of web based application development, will the
feasibility of the project be checked ?

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

(i) Write any two logical operators in Java.

(ii)

(iii) The ________ aggregate function in SQL is used to find the average
of all the values for an attribute in a table.

(A) MAX (B) MIN

(C) AVG (D) COUNT
11-326 5 P.T.O.

(iv) {H$Ýht Xmo e¡j{UH$ do~gmBQ²>g Ho$ Zm_ ~VmBE &
(v) {H$gr relation H$s gr_m (range) Ho$ A§VJ©V values H$mo gr{_V (restrict)
H$aZo Ho$ {bE SQL _| ________ constraint (amoY) H$m à`moJ {H$`m OmVm h¡ &
(A) DEFAULT (B) NOT NULL
(C) KEY (D) CHECK

(vi) do~ AZwà`moJ {dH$mg à{H«$`m (web application development process) _|
front-end interface Am¡a back-end database Ho$ ~rM S>oQ>m g§`moOH$Vm
(connectivity) ________ MaU _| hmoVr h¡ &
(A) {S>µOmBZ (Design)
(B) narjU (Testing)
(C) H$m`m©Ýd`Z (Implementation)
(D) Amdí`H$Vm n[a^mfm (Requirement Definition)

(vii) Omdm _| ________ statement H$m à`moJ AZoH$ g§^m{dV values _| go EH$
value Ho$ g_mZ (matching) code block Ho$ {ZînmXZ (execution) Ho$ {bE
{H$`m OmVm h¡ &

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

(i) {ZåZ{b{IV _| go H$m¡Z-gr AmB©grQ>r (ICT) gj_ godmE± ^maV gaH$ma Ûmam
ñWm{nV H$s JB© h¢ ?
(A) _¥Ë`w à_mU-nÌ n§OrH$aU
(B) {gZo_m (movie) {Q>H$Q>m| H$s IarX
(C) gyMZm{YH$ma (RTI) AmdoXZ nÌ àñVwV H$aZm
(D) OÝ_ à_mU-nÌ n§OrH$aU

(ii) gmohZ Zo RDBMS _| EH$ STUDENT gmaUr (Table) V¡`ma H$s h¡ & A~ dh
Xÿgar µ\$sëS> PERCENTAGE (add) MmhVm h¡, Omo gmaUr (Table)
Ho$ {bE integer Q>mBn H$s h¡ & Cg H$_m§S> (command) H$m Zm_ ~VmBE {Oggo
gmohZ H$mo AnZm H$m_ nyam H$aZo _| _XX {_boJr &
(iii) {H$Ýht Xmo AmB©grQ>r (ICT) Qy>ëg Ho$ Zm_ ~VmBE {OZH$m à`moJ B©-JdZ]g
(e-Governance) Ho$ {bE {H$`m Om gHo$$ &

11-326 6

(iv) Name any two educational websites.

(v) In SQL, ________ constraint is used to restrict the values within a
range in a relation.
(A) DEFAULT (B) NOT NULL
(C) KEY (D) CHECK

(vi) In a web application development process, data connectivity between
front-end interface and back-end database happens in the ________
phase.
(A) Design
(B) Testing
(C) Implementation
(D) Requirement Definition

(vii) The ________ statement in Java is used to execute a block of code
matching one value out of many possible values.

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

(i) Which of the following ICT enabled services have not been set up by
the Indian Government ?
(A) Registration of death certificate
(B) Purchase of movie tickets
(C) RTI application submission
(D) Registration of birth certificate

(ii) Sohan has created a table, STUDENT in RDBMS. He now wants to
add another field, PERCENTAGE, which is of type integer, to the
table. Write the command that will help Sohan to complete his task.

(iii) Name any two ICT tools that can be used for e-Governance.

11-326 7 P.T.O.

(iv) Omdm _| Arrays class H$s ________ nÕ{V (method) array _| {d{eîQ> VÎdm|
H$mo Ty>±T>Zo _| h_mar _XX H$aVr h¡ &
(A) search() (B) binary()
(C) binarySearch() (D) find()

(v) relation _| rows H$s g§»`m H$mo {H$gr relation H$m/H$s ________ H$hm OmVm
h¡ &
(vi) Predict the output :
System.out.print("Hello");
System.out.println("Java");

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

(i) Eogo {H$Ýht Xmo domains Ho$ Zm_ ~VmBE, Ohm± database applications H$m
Cn`moJ {H$`m Om gHo$ &
(ii) S>oQ>m~og _| g¥{OV Q>o~b H$s g§aMZm H$mo {XImZo Ho$ {bE, ________ H$_m§S> H$m
à`moJ {H$`m OmVm h¡ &
(iii) Omdm àmoJ«m_ _| new class ~ZmZo Ho$ {bE ________ H$sdS>© (Keyword) H$m
à`moJ {H$`m OmVm h¡ &

(iv) Q>o~b Q>rMa go g^r Q>rMa Ho$ ã`m¡ao {XImZo Ho$ {bE, {OgH$m doVZ 15000 go
A{YH$ h¡, SQL H$_m§S> ~VmBE &
(v) OOP H$m AW© ________ h¡ &>
(A) Ordinary Object Programming
(B) Oriented Object Programming
(C) Outsource Oriented Processing
(D) Object Oriented Programming

(vi) class Ho$ A§Xa hr class Ho$ data member H$mo {XImZo Ho$ {bE H$m¡Z-gm
keyword _XX H$aVm h¡ ?

11-326 8

(iv) ________ method of Arrays class in Java helps us to search for a
specific element in the array.
(A) search() (B) binary()

(C) binarySearch() (D) find()

(v) The number of rows in a relation is called the ________ of a relation.

(vi) Predict the output :
System.out.print("Hello");
System.out.println("Java");

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

(i) Name any two domains where database applications may be used.

(ii) To show the structure of created table in the database, ________
command is used.

(iii) ________ keyword is used to create a new class in Java program.

(iv) Write the SQL command to display all the details of teachers from
the table 15000.

(v) OOP stands for ________.

(A) Ordinary Object Programming

(B) Oriented Object Programming

(C) Outsource Oriented Processing
(D) Object Oriented Programming

(vi) Which keyword helps to make a data member of a class visible only
within the class ?

11-326 9 P.T.O.

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

(i) {ZåZ{b{IV _| go H$m¡Z-gr d¡Y Ma KmofUm (valid variable declaration) h¡ ?
(A) yes no
(B) yes & no
(C) yesno
(D) 1_yesno

(ii) MYSQL S>oQ>m~og _| gmaUr (table) ~ZmVo g_` gwYm field Age Ho$ {bE value
{ZYm©aU 0 Ho$ ê$n _| H$aZm MmhVr h¡ & Bg value H$s à{dpîQ> (insert) H$s OmEJr
`{X Cn`moJH$Vm© Ûmam C_« (Age) H$s value Z Xr JB© hmo & EH$ amoY (constraint)
H$m gwPmd Xr{OE Vm{H$ gwYm H$m`© nyam H$aZo Ho$ {bE BgH$m à`moJ H$a gHo$ &
(iii) Cg amîQ´>r` nmoQ>©b (national portal) H$m Zm_ ~VmBE Omo {d{^Þ gaH$mar g§ñWmZm|
Ûmam àXmZ H$s Om ahr gyMZmAm| Am¡a godmAm| Ho$ {bE single window gw{dYm
àXmZ H$aVm h¡ &
(iv) ZrMo {XE JE Omdm H$moS> H$m output ?
int a = 20;
int b = 30;
a + = b;
System.out.println(a);

(v) {ZåZ{b{IV _| go H$m¡Z-gm DML H$_m§S> (command) h¡ ?
(A) SELECT
(B) INSERT
(C) CREATE
(D) DELETE

(vi) Cn^moº$m Ho$ {bE B§Q>aZoQ> go IarXXmar (online shopping) H$m H$moB© EH$ bm^
~VmBE &
11-326 10

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

(i) Which of the following is a valid variable declaration ?

(A) yes no

(B) yes & no

(C) yesno
(D) 1_yesno

(ii) While creating a table in MYSQL database, Sudha wants to set the
value for the field Age as 0. This value will be inserted if no value of
age is given by the user. Suggest a constraint that Sudha can use to
complete her task.

(iii) Name the national portal which provides a single window access to
information and services being provided by various government
entities.

(iv) What will be the output of the Java code given below ?
int a = 20;
int b = 30;
a + = b;
System.out.println(a);

(v) Which one of the following is not a DML command ?

(A) SELECT

(B) INSERT

(C) CREATE

(D) DELETE

(vi) Give any one benefit of online shopping to the consumer.

11-326 11 P.T.O.

IÊS> I $
({df`naH$ àH$ma Ho$ àíZ) (30 A§H$)

5 3

20 30 3 2=6

7. gH$mamË_H$ ÑpîQ>H$moU (positive attitude) ~ZmE aIZo Ho$ H$moB© Xmo VarHo$ ~VmBE & 2

8. à^mdH$mar ldU (active listening) ? {H$Ýht Mma ñVam| Ho$ Zm_
{b{IE & 2

9. h_ {H$g àH$ma greenhouse J¡g Ho$ CËgO©Z (emission) H$mo H$_ H$a gH$Vo h¢ ? 2

10. {H$gr CÚ_r Ûmam bú` {ZYm©aU Ho$ {H$Ýht Xmo bm^m| H$m CëboI H$s{OE & 2

11. LibreOffice Impress _| àñVwVrH$aU (presentation) H$mo save H$aZo Ho$ MaUm| H$m
CëboI H$s{OE & 2

5 3 20 30 3 2=6

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

public class test {
public static void main (string [] args) {
int num = 5;
while (num > 1)
{
system.out.println("**" + num * num);
num;
}
}
}

11-326 12

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. Write any two ways to maintain positive attitude. 2

8. What are the different stages of active listening ? Write the names of any
four stages. 2

9. How can we reduce greenhouse gas emission ? 2

10. Write any two benefits of goal setting by an entrepreneur. 2

11. Write the steps to save a presentation in LibreOffice Impress. 2

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

12. Give the output of the following code segment : 2
public class test {
public static void main (string [] args) {
int num = 5;
while (num > 1)
{
system.out.println("**" + num * num);
num;
}
}
}
11-326 13 P.T.O.

13. DBA ? DBA H$m H$moB© EH$ CÎmaXm{`Ëd ~VmBE & 1+1

14. MySQL Ho$ CHAR(n) Am¡a VARCHAR(n) S>oQ>m àH$mam| Ho$ ~rM A§Va ~VmBE & AnZo
CÎma Ho$ g_W©Z _| CXmhaU Xr{OE & 1+1

15. Amb_ AnZo {S>nmQ>©_|Q>b ñQ>moa _| dñVwAm| H$s IarX Am¡a {~H«$s Ho$ à~§YZ Ho$ {bE EH$
database ~ZmZm MmhVm h¡ & CgHo$ database H$s ITEMS gmaUr (Table) _| CZ g^r
dñVwAm| H$s gyMZm hmoVr h¡, Omo dh AnZo ñQ>mao _| ~oMVm h¡ & ITEMS gmaUr (Table) Ho$
{ddaU BgH$s ñH$s_m Ho$ gmW Xr{OE & 2

16. Omdm _| while loop Am¡a do while loop Ho$ ~rM A§Va ~VmBE & 2

3 2 30 50 2 3=6

17. JAVA _| {ZåZ{b{IV H$moS> H$mo nyam H$s{OE, Omo eãXm| _| g§»`m (0 `m 1) H$mo qàQ> H$aVm
h¡ & 3

public class word {
public static void main (string [ ] args) {
int number = 0;
______ (number) {
case 0 :
system.out.println("ZERO");
______;
case 1 :
system.out.println("ONE");
break;
______:
system.out.println("NEITHER ZERO NOR ONE");
}
}
}

11-326 14

13. What is DBA ? Write any one responsibility of DBA. 1+1

14. Differentiate between CHAR(n) and VARCHAR(n) data types of MySQL.
Give examples to support your answer. 1+1

15. Aalam wants to create a database to manage the purchase and sale of
items in his departmental store. The ITEMS table in the database contains
information of all items that he sells in his store. Give details of ITEMS
table along with its schema. 2

16. Differentiate between while loop and do while loop in Java. 2

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

17. Complete the following code in JAVA, that prints the number
(either 0 or 1) in words : 3
public class word {
public static void main (string [ ] args) {
int number = 0;
______ (number) {
case 0 :
system.out.println("ZERO");
______;
case 1 :
system.out.println("ONE");
break;
______:
system.out.println("NEITHER ZERO NOR ONE");
}
}
}

11-326 15 P.T.O.

18. (H$) {dH«$m§V Zo {ZåZ{b{IV n¥ÀN>m (query) Xr h¡ na§Vw Bg_| Ìw{Q>`m± (errors) h¢ & Ìw{Q>`m| _|
gwYma H$s{OE Am¡a {H$E JE gwYma H$mo underline (aoIm§{H$V) H$s{OE &
Teacher go Zm_, C_« Mw{Z`o Ohm± Zm_ (name) = "_a%" h¡;

(I) EH$ CXmhaU Ho$ gmW SQL _| GROUP BY clause H$mo ñnîQ> H$s{OE & 1+2

19. {ejm Ho$ joÌ _| S>oQ>m~og à~§YZ àUm{b`m| Ho$ AZwà`moJ ~VmBE & 3

5 3 50 80 3 4=12

20. (H$) {XE JE output Xr{OE &

public class StringDemo{

public static void main(String[]args) {

String myString = "Welcome Java";

System.out.println (myString.toUpperCase());

System.out.println (myString.indexOf('o'));

System.out.println (myString.contains("come"));

}}

(I) Omdm _| {ZåZ{b{IV string na {dMma H$s{OE :
String q

H$s OJh H$aZo Ho$ {bE {ddaU {b{IE & 3+1

21. (H$) Am`V (rectangle) Ho$ joÌ\$b (Area) H$mo àX{e©V H$aZo Ho$ {bE Omdm _| EH$
àmoJ«m_ ~ZmBE &
ZmoQ : àmoJ«m_ _| Cn`moJ hþE d¡[aE~ëg H$mo H$moB© ^r H$mën{ZH$ d¡ë`y Xr{OE &
(I) Omdm _| = and == operator Ho$ ? AnZo CÎma Ho$ g_W©Z Ho$ {bE
CXmhaU Xr{OE & 2+2

11-326 16

18. (a) Vikrant has given the following query but it has errors. Rectify the
errors and underline the correction made.
Select name, age from teacher where name = "_a%";
(b) Explain the GROUP BY clause in SQL with an example. 1+2

19. State the applications of database management systems in the field of
education. 3

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

20. (a) Read the given Java code carefully and give the output :

public class StringDemo{

public static void main(String[]args) {

String myString = "Welcome Java";

System.out.println (myString.toUpperCase());

System.out.println (myString.indexOf('o'));

System.out.println (myString.contains("come"));

}}

(b) Consider the following string in Java :
S
3+1

21. (a) Write a program in Java to display area of a rectangle.

Note : Assign any imaginary values to the variables used in the
program.

(b) What is the difference between = and == operator in Java ? Give
example to support your answer. 2+2

11-326 17 P.T.O.

22. (H$) Webinar Am¡a video tutorial Ho$ ~rM EH$ A§Va ~VmBE &

(I) Cn`moJH$Vm©Am| (Users) H$mo Am°ZbmBZ AmajU gw{dYm àXmZ H$aZo dmbo g§JR>Z `m
H§$nZr Ho$ AZoH$ bm^ h¢ & BZ_| go {H$Ýht Xmo bm^m| H$m CëboI H$s{OE &

(J) A{Zb {Xëbr go _wå~B© H$s âbmBQ> Am°ZbmBZ [aOd}eZ Ho$ Ûmam ~wH$ H$aZm MmhVm
h¡ & CgZo hdmB© `mÌm AmajU (Flight reservation) Ho$ {bE do~gmBQ> Imobr h¡
Am¡a AnZm userid Am¡a password H$m à`moJ H$aVo hþE login {H$`m h¡ & AnZr
~wqH$J H$mo nyam H$aZo Ho$ {bE A~ Cgo {H$Z MaUm| H$m nmbZ H$aZm Mm{hE, {b{IE & 1+1+2

23. (H$) JAVA Ho$ g§X^© _| Array eãX H$mo n[a^m{fV H$s{OE &

(I) JAVA _| access modifiers Am¡a BZHo$ àH$mam| H$mo ñnîQ> H$s{OE & 1+3

24. {ZåZ{b{IV na {dMma H$s{OE Am¡a àíZm| Ho$ CÎma Xr{OE &

(H$) Q´>odbEO|gr (TravelAgency), {OgHo$ {ddaU ZrMo {XE JE h¢, Ho$ {bE EH$ gmaUr
(table) ~ZmZo hoVw SQL H$_m§S> {b{IE &
EO|Q>H$moS> (AgentCode) Char(4) Primary Key
EO|Q> H$m Zm_ (AgentName) Varchar(20) Not Null
ñWmZ Varchar(25)
n¡Ho$O Varchar(30)
MmO}µO (ewëH$) Decimal

(I) {ZåZ{b{IV data Ho$ gmW Q>o~b Q´>odbEO|gr (TravelAgency) _| EH$ ZB© row
E H$_m§S> {b{IE &

(J) Q>o~b Q´>odbEO|gr (TravelAgency) go H$m°b_ n¡H$o O (column Package) hQ>mZo
H$s query {b{IE & 2+1+1

11-326 18

22. (a) Give one difference between a webinar and a video tutorial.

(b) The organization or company providing the online reservation
facility to the users has several advantages. Give any two of these
advantages.

(c) Anil wants to book a flight from Delhi to Mumbai through online
reservation. He has opened the website for flight reservation and
logged in using his userid and password. Write the steps that he
should follow now to complete his booking. 1+1+2

23. (a) Define the term Array with respect to Java.

(b) Explain the access modifiers and their types in Java. 1+3

24. Consider the following and answer the questions.

(a) Write an SQL command to create a table TravelAgency whose
description is given below :

AgentCode Char(4) Primary Key
AgentName Varchar(20) Not Null
Location Varchar(25)
Package Varchar(30)
Charges Decimal

(b) Write the command to add a new row to a table TravelAgency with
the following data :

(c) Write a query to remove the column Package from the table
TravelAgency. 2+1+1

11-326 19 P.T.O.

CBSE STUDY MATERIAL

CBSE Board

INFORMATION CLASS STUDY MATERIAL

1 Time Table 09 Sample Paper
10 Sample Paper
2 Result
11 Sample Paper
3 Syllabus 12 Sample Paper

OTHER RESOURCES
09 Question Paper
Maps of India, Maps of World
Writing Skill Formats 10 Question Paper
Periodic Table 11 Question Paper
12 Question Paper
Class 9 Notes
Class 10 Notes
NCERT Book
Class 11 Notes
Class 12 Notes NCERT Solutions

ENTRANCE EXAMS

JEE Main CLAT CUET UG
JEE Advanced NEET UG Fashion & Design