CBSE Class 12 Question Paper 2024 Solution Information Technology

Marking Scheme
Strictly Confidential
(For Internal and Restricted use only)
Senior Secondary School Examination, 2024
SUBJECT NAME: INFORMATION TECHNOLOGY
(SUBJECT CODE – 802) (PAPER CODE – 326)

General Instructions: -

1 You are aware that evaluation is the most important process in the actual and correct
assessment of the candidates. A small mistake in evaluation may lead to serious
problems which may affect the future of the candidates, education system and
teaching profession. To avoid mistakes, it is requested that before starting evaluation,
you must read and understand the spot evaluation guidelines carefully.
2 “Evaluation policy is a confidential policy as it is related to the confidentiality of
the examinations conducted, Evaluation done and several other aspects. Its’
leakage to public in any manner could lead to derailment of the examination
system and affect the life and future of millions of candidates. Sharing this
policy/document to anyone, publishing in any magazine and printing in News
Paper/Website etc. may invite action under various rules of the Board and IPC.”

3 Evaluation is to be done as per instructions provided in the Marking Scheme. It should
not be done according to one’s own interpretation or any other consideration. Marking
Scheme should be strictly adhered to and religiously followed. However, while
evaluating, answers which are based on latest information or knowledge and/or
are innovative, they may be assessed for their correctness otherwise and due
marks be awarded to them. In Class-XII, while evaluating two competency-based
questions, please try to understand given answer and even if reply is not from
marking scheme but correct competency is enumerated by the candidate, due
marks should be awarded.

4 The Marking scheme carries only suggested value points for the answers
These are in the nature of Guidelines only and do not constitute the complete answer.
The students can have their own expression and if the expression is correct, the due
marks should be awarded accordingly.
5 The Head-Examiner must go through the first five answer books evaluated by each
evaluator on the first day, to ensure that evaluation has been carried out as per the
instructions given in the Marking Scheme. If there is any variation, the same should be
zero after deliberation and discussion. The remaining answer books meant for
evaluation shall be given only after ensuring that there is no significant variation in the
marking of individual evaluators.

6 Evaluators will mark (√) wherever answer is correct. For wrong answer CROSS ‘X” be
marked. Evaluators will not put right (✓) while evaluating which gives an impression
that answer is correct and no marks are awarded. This is most common mistake
which evaluators are committing.

7 If a question has parts, please award marks on the right-hand side for each part.
Marks awarded for different parts of the question should then be totalled up and
written in the left-hand margin and encircled. This may be followed strictly.
8 If a question does not have any parts, marks must be awarded in the left-hand margin
and encircled. This may also be followed strictly.
9 If a student has attempted an extra question, answer of the question deserving more
marks should be retained and the other answer scored out with a note “Extra
Question”.

IT(802)/MS/2023-24/1

10 No marks to be deducted for the cumulative effect of an error. It should be penalized
only once.

11 A full scale of marks __________ (example 0 to 80/70/60/50/40/30 marks as given in
Question Paper) has to be used. Please do not hesitate to award full marks if the
answer deserves it.
12 Every examiner has to necessarily do evaluation work for full working hours i.e., 8
hours every day and evaluate 20 answer books per day in main subjects and 25
answer books per day in other subjects (Details are given in Spot Guidelines).This is in
view of the reduced syllabus and number of questions in question paper.

13 Ensure that you do not make the following common types of errors committed by the
Examiner in the past: -
● Leaving answer or part thereof unassessed in an answer book.
● Giving more marks for an answer than assigned to it.
● Wrong totalling of marks awarded on an answer.
● Wrong transfer of marks from the inside pages of the answer book to the title
page.
● Wrong question wise totalling on the title page.
● Wrong totalling of marks of the two columns on the title page.
● Wrong grand total.
● Marks in words and figures not tallying/not same.
● Wrong transfer of marks from the answer book to online award list.
● Answers marked as correct, but marks not awarded. (Ensure that the right tick
mark is correctly and clearly indicated. It should merely be a line. Same is with the
X for incorrect answer.)
● Half or a part of answer marked correct and the rest as wrong, but no marks
awarded.
14 While evaluating the answer books if the answer is found to be totally incorrect, it
should be marked as cross (X) and awarded zero (0)Marks.

15 Any unassessed portion, non-carrying over of marks to the title page, or totalling error
detected by the candidate shall damage the prestige of all the personnel engaged in
the evaluation work as also of the Board. Hence, in order to uphold the prestige of all
concerned, it is again reiterated that the instructions be followed meticulously and
judiciously.
16 The Examiners should acquaint themselves with the guidelines given in the
“Guidelines for spot Evaluation” before starting the actual evaluation.

17 Every Examiner shall also ensure that all the answers are evaluated, marks carried
over to the title page, correctly totalled and written in figures and words.
18 The candidates are entitled to obtain photocopy of the Answer Book on request on
payment of the prescribed processing fee. All Examiners/Additional Head
Examiners/Head Examiners are once again reminded that they must ensure that
evaluation is carried out strictly as per value points for each answer as given in the
Marking Scheme.

IT(802)/MS/2023-24/2

MARKING SCHEME
Senior Secondary School Examination, 2024
INFORMATION TECHNOLOGY (Subject Code–802)
[ Paper Code:326]
Max. Time: 3 Hours Max. Marks: 60
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) Marks allotted are mentioned against each question/part.
(c) There is no negative marking.
(d) Do as per the instructions given.
(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.
Note: Ignore semicolon (;) in SQL related commands and ignore case in Java
related codes written by students.
Q. No. EXPECTED ANSWER / VALUE POINTS Marks
SECTION—A (30
(Objective Type Questions) Marks)
Q1. Answer any 4 questions out of the given 6 questions on Employability 4×1=4
Skills.
i) A ________ is a group of words that communicate a complete meaning. 1
Ans: Sentence

(1 mark for correct answer)
ii) In the acronym ‘SMART’ to set goals, the letter ‘S’ implies ________ 1
Ans: Specific
(1 mark for correct answer)
iii) ________ is a state of feeling upset, annoyed and hopeless. 1
Ans: Stress / Depress /Depression

(1 mark for correct answer)
iv) In a spreadsheet, the ________ shows the location of selected cell. 1
Ans: Name Box

(1 mark for correct answer)
v) A/An ________ entrepreneur is a type of entrepreneur who creates a new market for his 1
services or provides a service in an existing market.
Ans: Service

(1 mark for correct answer)
vi) _____ farming is the process by which we can grow plants in an environmental friendly way. 1
Ans: Organic / Eco / Eco-friendly / Green / Hydroponics

(1 mark for correct answer)
IT(802)/MS/2023-24/3

Q2. Answer any 5 out of the given 7 questions. 5×1=5
________ is produced by processing data. 1
i)
Ans: Information

(1 mark for correct answer)
ii) How many primitive data types are supported by Java? 1
Ans: 8
OR
byte, short, int, long, float, double, char, boolean
(1 mark for correct answer)
OR
(½ mark for any four names of the data types)
iii) Which one of the following commands is used to delete the table from the database? 1
(A) Delete (B) Drop
(C) Remove (D) Pop
Ans: (B) Drop
(1 mark for correct answer)
iv) _____ method in Java is used to concatenate the specified string at the end of the given string. 1
Ans: concat() (ignore case and parenthesis)
(1 mark for correct answer)
v) NeGD stands for ________.
(A) National e-Governance District 1
(B) National e-Government Draw
(C) National e-Governance Division
(D) National e-Government Discord
Ans: (C) National e-Governance Division
(1 mark for correct answer)
vi) What is the advantage of Java Virtual Machine?
1
It is a platform-independent environment for executing Java code.
OR
Once a program is compiled into bytecode, it can run on any platform.
(1 mark for correct answer)
OR
It translates the byte code into machine code and then executes it.
(1/2 mark)
In which phase of web based application development, will the feasibility of the project be
vii) 1
checked?
Ans: Requirement Definition Phase
(1 mark for correct answer)
Q3. Answer any 6 out of the given 7 questions. 6×1=6

i) Write any two logical operators in Java. 1
&& /AND /Logical AND , || /OR/ Logical OR , ! / NOT / Logical NOT
(1 mark for any two correct operators)
(1/2 mark for any one correct operator)
IT(802)/MS/2023-24/4

ii) State True or False. “Java is not a portable language”. 1
Ans: False /No / 0 (zero)
OR
Java is a portable language.
OR
Portable
(1 mark for correct answer)
The ________ aggregate function in SQL is used to find the average of all the values for an
iii) 1
attribute in a table.
(A) MAX (B) MIN
(C) AVG (D) COUNT
Ans: (C) AVG
(1 mark for correct answer)
Name any two educational websites.
iv) 1
Ans: www.ncert.nic.in
www.coursera.org
www.w3schools.com
www.khanacademy.org
www.eagetutor.com
www.udacity.org
www.edx.org
www.gcllearnfree.org

(Any two of the above or any other relevant educational websites)
(1 mark for any two correct website names)
(1/2 mark for any one correct website name)
In SQL, ________ constraint is used to restrict the values within a range in a relation.
v) 1
(A) DEFAULT (B) NOT NULL
(C) KEY (D) CHECK
Ans: (D) CHECK
(1 mark for correct answer)
In a web application development process, data connectivity between front-end interface and
vi) 1
back-end database happens in the ________ phase.
(A) Design (B) Testing
(C) Implementation (D) Requirement Definition
Ans: (C) Implementation
(1 mark for correct answer)
The ________ statement in Java is used to execute a block of code matching one value out of
vii) 1
many possible values.
Ans: Switch/ switch / if with OR operator / if … else if/ if and else
(1 mark for correct answer)

Q4. 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 1
Government?
(A) Registration of death certificate
(B) Purchase of movie tickets
(C) RTI application submission
(D) Registration of birth certificate
Ans: (B) Purchase of movie tickets
(1 mark for correct answer)
IT(802)/MS/2023-24/5

Sohan has created a table, STUDENT in RDBMS. He now wants to add another field, 1
ii) PERCENTAGE, which is of type integer, to the table. Write the command that will help
Sohan to complete his task.
Ans: Alter table student add percentage int;
OR
Alter table student add percentage integer;
(1 mark to be given)
OR
Alter table student
(1/2 mark)
OR
Add percentage integer/int
(1/2 mark)
Name any two ICT tools that can be used for e-Governance.
iii) 1
Ans: Mobile phones/Internet/ Wi-Fi/ Broadband/ LAN /
Laptop /Desktop / Computer /Tablet
(1 mark for any two correct answers)
________ method of Arrays class in Java helps us to search for a specific element in the
iv) 1
array.
(A) search()
(B) binary()
(C) binarySearch()
(D) find()
Ans: (C) binarySearch()
(1 mark for correct answer)
The number of rows in a relation is called the ________ of a relation.
v) 1
Ans: Cardinality
(1 mark for correct answer)
Predict the output:
vi) 1
System.out.print("Hello");
System.out.println("Java");

Ans: HelloJava
(1 mark for correct answer)
OR
Hello
Java
(1/2 mark)
OR
Hello
(1/2 mark)
OR
Java
(1/2 mark)
IT(802)/MS/2023-24/6

Q5. Answer any 5 out of the given 6 questions. 5×1=5
i) Name any two domains where database applications may be used.
1
 Hospital
 School
 Banking
 Government sector
 Education
 Companies
 e-Commerce
 Airlines
 Railways
 Telecommunications
 Hotels
(1 mark for any two correct answers/ relevant answers)
(1/2 mark for any one correct answer/ relevant answer)
To show the structure of created table in the database, ________ command is used.
ii) 1
Ans: Desc/Describe
(1 mark for correct answer)
________ keyword is used to create a new class in Java program.
iii) 1
Ans: class (ignore case)
(1 mark for correct answer)
iv) Write the SQL command to display all the details of teachers from the table “Teacher” whose
1
salary is greater than 15000.
Ans: Select * from Teacher where salary >15000 ;
(1 mark for correct answer)
Select * from Teacher
(1/2 mark)
where salary >15000
(1/2 mark)
v) OOP stands for ________.
1
(A) Ordinary Object Programming
(B) Oriented Object Programming
(C) Outsource Oriented Processing
(D) Object Oriented Programming
Ans: (D) Object Oriented Programming
(1 mark for correct answer)
vi) Which keyword helps to make a data member of a class visible only within the class?
1
Ans: private
(1 mark for correct answer)
Q6. Answer any 5 out of the given 6 questions. 5×1=5

i) Which of the following is a valid variable declaration?
1
(A) yes no
(B) yes & no
(C) yesno
(D) 1_yesno
Ans: (C) yesno
(1 mark for correct answer)

IT(802)/MS/2023-24/7

ii) While creating a table in MYSQL database, Sudha wants to set the value for the field Age as 1
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.
Ans: DEFAULT (ignore case)
(1 mark for correct answer)
iii) Name the national portal which provides a single window access to information and services 1
being provided by various government entities.
Ans: www.india.gov.in
OR
india.gov.in
OR
india.gov
(1 mark for any correct answer)
iv) What will be the output of the Java code given below? 1
int a = 20;
int b = 30;
a + = b;
System.out.println(a);
Ans: 50
(1 mark for the correct answer)
v) Which one of the following is not a DML command? 1
(A) SELECT
(B) INSERT
(C) CREATE
(D) DELETE
Ans: (C) CREATE
(1 mark for the correct answer)
vi) Give any one benefit of online shopping to the consumer. 1
 247 service available
 Need not go to shop/market
 Anywhere anytime
 Can be delivered at any address
 Save time and energy
 Save travelling time
 Save money
 Better Prices
 Variety
 Safety
 No pressure shopping
(1 mark for any one correct answer / relevant answer)
SECTION - B:
(Subjective Type Questions) (30 marks)
Answer any 3 questions out of the given 5 questions on Employability Skills. 3x2 = 6
Answer each question in 20 – 30 words.
Q7. Write any two ways to maintain positive attitude.
2
 Start the day with a morning routine. Say positive affirmations, smile often and think
about the tasks to be accomplished during for the day.
 Feed the mind with positivity, read motivating books, listen to music with uplifting
lyrics, watch inspiring movies, etc.
 Be proactive. A proactive person decides how one must feel regardless of what may
IT(802)/MS/2023-24/8

be going around or what the day may bring.
 Focus on constructive and positive things. Do not approach life with ‘problems’.
Approach it with ‘solutions’.
 Learn from failures. Think what could have been better and work towards the goals.
 Learn to focus on the present. Negativity mostly stems out from anxiety of the past
and future events.
 Move towards your goals and dreams. Be cheerful and work hard to achieve the
dreams.
(2 marks for any two relevant answers)
(1 mark for any one relevant answer)
Q8. What are the different stages of active listening? Write the names of any four stages.
2
 Receiving
 Understanding
 Remembering
 Evaluating
 Responding / Feedback
(2 marks for any 4 of the above mentioned points)
(1/2 mark for each correct stage of active listening)
Q9. How can we reduce greenhouse gas emission?
2
1) Buy energy-efficient appliances.
2) Conserve energy.
3) Reduce household waste.
4) Plant more trees.
5) Reduce the use of fossil fuels.
6) Use CNG.
7) Choose renewable energy.
(2 marks for any 2 of the above points or relevant answers)
(1 mark for any one of the above points or relevant answer)
Q10. Write any two benefits of goal setting by an entrepreneur.
2
 Motivation–to complete what has been started
 Makes to work harder
 Give directions
 Makes him to put more effort and focus
 Provides clarity and focus
 Helps to measure progress
(2 marks for any 2 benefits or relevant answers)
(1 mark for any 1 benefit or relevant answer)
Q11. Write the steps to save a presentation in LibreOffice Impress.
2
 Click on File menu. Select Save or Save As from drop down menu.
OR
Click on Save Icon.
OR
CTRL+S
 The Save As dialog box appears.
 Select the folder where you want to save your file and write the name of file.
 Click on Save button.
(2 marks for mentioning all the above points)
(1/2 mark each for mentioning the above points)
(Any other valid explanation is also accepted)

IT(802)/MS/2023-24/9

Answer any 3 out of the given 5 questions in 20 – 30 words each. 3x2=6
Q12. 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;
}
}
}
**25
**16
**9
**4
(2 marks for correct answer)
OR
(1 mark for mentioning all the numbers excluding **)
OR
(1/2 mark for each correct line)
OR
(2 marks for No Output / Syntax Error)
Q13. What is DBA ? Write any one responsibility of DBA.
1+1
Ans: DBA – Database Administrator
The DBA is responsible for :
 Administer the database and DBMS
 Authoring access
 Monitoring its use
 Providing technical support
 Acquiring software and hardware resources
 Security and integrity
 Ensures the availability and accessibility of database.
 Ensures that all the data stored in the database is not misplaced or mismatched
(1 mark for any one of the above mentioned responsibility/ relevant answer)
(1 mark for the Full form of DBA)
OR
(1/2 mark for writing Database)
OR
(1/2 mark for writing Administrator)
Q14. Differentiate between CHAR(n) and VARCHAR(n) data types of MySQL. Give examples to
1+1
support your answer.
CHAR(n)  It is used for fixed length character string where ‘n’ is no. of characters.
VARCHAR(n) It is used for variable length string where ‘n’ is maximum no. of characters
in a string.
(Relevant examples to be given)

(1 mark for difference)
( 1/2 mark for each relevant example)

IT(802)/MS/2023-24/10

Q15. Aalam wants to create a database to manage the purchase and sale of items in his
2
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
Schema: ITEMS (Item_Code, Item_Name, Price, Qty)
Details
Name Type Remarks
Item_ Code INT (10) Primary Key
Item_ Name CHAR (20)/ VARCHAR(20) Name of Item
Price INT (10) Price of Item
Qty INT (10) Qty of Item available
(1 mark for schema)
(1 mark for correct details)
Q16. Differentiate between while loop and do while loop in Java. 2
while loop do….while loop
Entry-controlled loop Exit-controlled loop
Loop executes only when condition is true Loop executes at least once whether
condition is true or false.
(2 marks for two correct differences)
OR
(2 marks for correct explanations through examples)
(1 mark for one correct difference)
Answer any 2 out of the given 3 questions in 30 – 50 words. 2x3=6
Complete the following code in JAVA, that prints the number (either 0 or 1) in words :
Q17. public class word { 3
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");
}
}
}
public class word {
public static void main (string [ ] args) {
int number = 0;
switch (number) {
case 0 :
system.out.println("ZERO");
break;
case 1 :
system.out.println("ONE");
break;
default :
system.out.println("NEITHER ZERO NOR ONE");
}
}
}
(1 mark each for writing each missing keywords ( switch, break, default) correctly )
IT(802)/MS/2023-24/11

Q18. Vikrant has given the following query but it has errors. Rectify the errors and underline the
1
correction made.
(a) Select name, age from teacher where name = “_a%”;
Select name, age from teacher where name like “_a%”;
(1 mark for correct answer)
(1/2 mark for underlining the error without correction)
(b) Explain the GROUP BY clause in SQL with an example 2
GROUP BY clause is used to view results in groups based on an attribute.
For e.g. – to find the number of teachers teaching in each department, we can use group by
clause –
SELECT Dept_No, Count(*)
From Teacher
Group By Dept_No
(1 mark for explanation and 1 mark for example)
Q19. State the applications of database management systems in the field of education.
3
1. For storing information about teaching and non-teaching staff.
2. For storing details of infrastructure.
3. For storing information about student’s details, marks and result.
4. Educational institutions can track student performance, analyse data, and provide
students with personalized learning experiences.
5. Helps to improve communication between students, teachers, parents and
administrators, leading to better student outcomes.
6. To store data of alumni members
(1 mark each for any three of the above mentioned points / relevant answer)
Answer any 3 out of the given 5 questions in 50 – 80 words each. 3x4=12
(a) Read the given Java code carefully and give the output :
Q20. 3
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"));
} }
WELCOME JAVA
4
true
(1 Mark for each line of correct output )
(b) Consider the following string in Java:
String quote = “Stay Safe”; 1
Write a statement to replace “Safe” with “Secure”.
quote.replace(“Safe”, “Secure”);

(1 Mark for correct answer)
(1/2 mark for replace( ) )

IT(802)/MS/2023-24/12

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

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

public class Area_Rect
{
public static void main(String[ ] args)
{ int l = 20, b = 30, area;
area = l * b;
System.out.println(“Area of rectangle is”+area);
}
}
(½ mark for declaration of class and main () or any)
(½ mark for declaration and assigning values to the variables)
(½ mark for calculating area of a rectangle)
( ½ mark for displaying the area of a rectangle)
(b) What is the difference between = and == operator in Java? Give example to support your 2
answer.
The “=” is an assignment operator used to assign the value on the right to the variable
on the left.
b = 20;
The ‘==’ is a relational / comparative operator that checks whether the two given operands
are equal or not. If so, it returns true otherwise it returns false.
5==5
This will return true.
(or any other relevant example to be given)
(1 mark for the difference)
OR
(½ mark for explanation of only ’=’ or ’==’)
(½ mark for each example)
(a) Give one difference between a webinar and a video tutorial.
Q22. 1
Webinar – These are real time lectures, where users participate in the lecture, may ask
questions, and get their queries answered.
Video Tutorials – These are videos or slides of lectures for which the learner can visit the site
and view them.
(1 mark for the difference)
OR
( ½ mark for each explanation)
(b)The organization or company providing the online reservation facility to the users has
1
several advantages. Give any two of these advantages.
Advantages to the organization or company:
1. Requires less staffing
2. Save your staff time
3. Reduce workloads for your staff and optimize customer service
4. Open around the clock
5. No more human errors
6. No spatial restrictions
7. Global access
(1/2 mark each for any two correct advantages /relevant answers)
IT(802)/MS/2023-24/13

(c) Anil wants to book a flight from Delhi to Mumbai through online reservation. He has
2
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. Search the flight available by entering some details like source, destination, date of
travelling, personal details etc.
2. Select the desired seat and confirm the seat and proceed to payment option.
3. Make the payment.
4. Download the e-ticket after confirmation.
( ½ mark for each step / relevant answer)

Q23. (a) Define the term Array with respect to Java. 1
Array: It is a type of variable which can hold multiple values of same data type.
(1 Mark for correct answer)

(b) Explain the access modifiers and their types in Java.
Ans: 3
Access modifiers are used to make the class members visible/non-visible outside the class.
Private members of a class cannot be accessed outside the class.
Public members of a class can be accessed both within and outside the class.
By default, all members of a class are public.
(1 mark for definition of access specifiers/modifiers / relevant answer)
(1 mark for private modifier/ explanation with example / relevant answer)
(1 mark for public modifier/ explanation with example / relevant answer)

Q24. Consider the following and answer the questions. 2
(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
Create table TravelAgency (
AgentCode char (4) Primary key,
AgentName varchar (20) Not Null,
Location varchar (25),
Package varchar (30),
Charges Decimal
);
(½ mark for create table)
(½ mark for constraints)
(½ mark for column names)
(½ mark for data types)

(b) Write the command to add a new row to a table TravelAgency with the following data: 1
(“A005”, “Raman”, “Grover Travel”, “Domestic”,8000)

IT(802)/MS/2023-24/14

Insert into TravelAgency
values (“A005”, “Raman”, “Grover Travel”, “Domestic”, 8000);
OR
Insert into TravelAgency (AgentCode, AgentName, Location,
Package, Charges)
values (“A005”, “Raman”, “Grover Travel”, “Domestic”, 8000);

(½ Mark for insert into)
(½ Mark for values)
(c) Write a query to remove the column Package from the table TravelAgency. 1
Alter table TravelAgency
drop Package;
OR
Alter table TravelAgency
drop column Package;

(½ Mark for alter table)
(½ Mark for drop)

***

IT(802)/MS/2023-24/15