Class 12 Question Paper 2024-25 Information Technology (Half Yearly)

HALF YEARLY EXAM

QUESTION
PAPER
ORIGINAL EXAM PAPERS

HALF YEARLY EXAMINATION, 2024-25
INFORMATION TECHNOLOGY
Time – 3:00 Hrs. Class – XII M.M. : 60
Date – 14.09.2024 (Saturday)
Name of the student _______________________________________________Section _____

General Instructions:
 Please read the instructions carefully.
 This Question Paper consists of 24 questions in two sections – A and B.
 Section A has MCQ / Objective type questions.
 Section B contains Subjective type questions.
SECTION A – MCQ/OBJECTIVE TYPE QUESTIONS (30 MARKS):
o This section has 06 questions. Attempt all the questions.
SECTION B – SUBJECTIVE TYPE QUESTIONS (30 MARKS):
 This section contains 18 questions.
 Do as per the instructions given.

SECTION – A
(Multiple Choice Questions / Objective Type Question)
Q.1 Answer ANY 4 out of the given 6 questions on Employability Skills. (1x4=4)
(i) Which of these sentence is punctuated correctly?
(a) Where are you going. (b) I have a pen a notebook and a pencil.
(c) I am so happy to see you? (d) This is my house.
(ii) _____________ is a state of feeling upset, annoyed and hopeless.
(iii) Which of these sentences has/have both indirect and direct objects?
(a) I am working on a presentation. (b) She bought a blue pen.
(c) The girls played cricket. (d) He wrote a letter to his sister.
(iv) _________symbol is displayed when the column in Calc is not wide enough to display the
value.
(v) Ravi has feelings of emptiness, abandonment and suicide. What type of personality
disorder is this?
(a) Borderline (b) Dependent (c) Avoidant (d) Obsessive
(vi) A ______________ is an arrangement of cells in a vertical (standing) manner.
Q.2 Answer ANY 5 out of the given 7 questions. (1x5=5)
(i) ______________ is not an aggregate function
(a) Sum() (b) Count() (c) Round() (d)Avg()
(ii) Pariniti wants to remove all the records from table "Customer" with fields
(Cust_ID,C_name, Amount, Dues, Address) whose dues status is Clear. Select the query
that will solve the purpose:

HALF YEARLY EXAM | IT | CLASS 12 | 2024-25 | PRINTED Q 24 PRINTED PAGES 5 | PAGE# 1

(a) Delete * from Customer where dues='Clear';
(b) Remove * from Customer where dues='Clear';
(c) Drop Customers where dues='Clear';
(d) Delete from Customer where dues='Clear';
(iii) DEITY stands for:
(a) Department of Electrical and Information Technology
(b) Department of Electronics and Information Technology
(c) Department of Electronics and Informatics Technology
(d) Department of Electrical and Informatics Technology
(iv) Jagriti wants to display the list of all the students in relation 'Student' with fields (Admno,
Name, DOB, DOJ, City, Class, FatherName, MotherName) whose city name ends with letter
'd' in decending order of Admno. Identify the correct query to do the same from the
following:
(a) Select * from Student where City like '%d' order by Admno;
(b) Select * from Student where City like 'd%' order by Admno;
(c) Select * from Student where City like '%d' order by Admno desc;
(d) Select * from Student where City like 'd%' order by Admno desc;
(v) Once the database is created, you can check it in the list of databases that currently exist
on the server by using ___________command.
(vi) An application that can be accessed via web browser, over a network connection is called
___________.
(vii) They are programmers who code in high level languages.
(a) Application programmers (b) System analysts
(c) End users (d) Database Administrators
Q.3 Answer ANY 6 out of the given 7 questions. (1x6=6)
(i) The process of development of web based applications is broadly categorized in ________
phases.
(ii) __________ are real time lectures, where users participate in the lecture, may ask questions
and get their queries answered.
(iii) In MySQL, while applying condition on a group, instead of WHERE clause _________ clause
is used.
(iv) In MySQL by default, the result of an order by clause is always displayed in ____________
order.
(v) For online booking of train ticket using the Indian Railway Catering and Tourism
Corporation (IRCTC) online portal, Identify the website of IRCTC Portal.
(a) irctc.gov.in (b) irctc.in (c) irctc.nic.in (d) irctc.co.in
(vi) Database can be removed by using ________ command.
(vii) The ______________ command is used to view the structure of a table.
(a) Describe (b) Select (c) Show (d) Display

HALF YEARLY EXAM | IT | CLASS 12 | 2024-25 | PRINTED Q 24 PRINTED PAGES 5 | PAGE# 2

Q.4 Answer ANY 5 out of the given 6 questions. (1x5=5)
i) This website includes sites of different states and union territories of India, sites of
government departments like judiciary and legislature. Which is this website?
(a) goidirectory.nic.in (b) godirectory.nic.in (c) indiagov.in (d) india.gov.in
ii) The main purpose of this constraint is to check that data entered in one relation is
consistent with the data entered in another relation. Name the constraint.
iii) Choose the correct MySql command to display 5% of salary as allowance
(a) select salary +0.5 as allowance from teacher;
(b) select salary *0.05 as allowance from teacher;
(c) select salary *0.5 rename as allowance from teacher;
(d) None of these
iv) Suppose you are asked to display all the names which have 'k' as their second character
then which query pattern you will use?
(a) _ _ k%; (b) _k_; (c) _k%; (d) _%k;
v) Naman studies in a government school and is a very intelligent child. He is preparing for
his examinations. He noticed that he lost his prescribed textbook due to renovation work
at his home. Help him to identify the website from where he can download his NCERT
notebook for free.
(a) ncert.org (b) w3schools.com (c) ncert.nic.in (d) edx.org
vi) Write the full form of NeGP.
Q5. Answer ANY 5 out of the given 6 questions. (1x5=5)
i) Which of the following syntax you will use to rename the table name?
(a) ALTER TABLE table_name RENAME TO new_table_name;
(b) RENAME new_table_name;
(c) ALTER table_name RENAME new_table_name;
(d) None of these
ii) Rashid is maintaining various records of his sales in different independent files. His boss
asked him to give a compiled report of his work. As all the data is stored in independent
files, it became difficult to access information out of multiple files. He is facing the
problem of
(a) Lack of data integration (b) Data storage
(c) Lack of data availability (d) Data deletion
iii) Finding of Bugs and Fixing them happens in ___________ phase.
iv) _______ is a collection of raw facts, which have not been processed to reveal useful _________.
(a) Data, information (b) Database, Information
(c) Information, data (d) Information, database
v) Mayank works in a company. He identifies requirements of the end users and develops
specifications to interact with the database. He plays a major role in database designing.
He is a -
(a) Programmer (b) End User (c) Database Administrator (d) Systems Analyst

HALF YEARLY EXAM | IT | CLASS 12 | 2024-25 | PRINTED Q 24 PRINTED PAGES 5 | PAGE# 3

vi) Creating a strong password is vital. A strong password has:
(a) 6-8 Alphanumeric characters (b) Special symbols
(c) Only numbers (d) Both a and b
Q6. Answer ANY 5 out of the given 6 questions. (1x5=5)
i) ____________clause is used to remove duplicate values.
ii) ____________ is the process of achieving the objectives of the project through a set of
activities defined within the time frame, to produce the end result.
iii) State True or False
The data connectivity is established between the Front-End interface and Back-End
Database in the implementation phase.
iv) Roma is booking a railway ticket using an online ticketing website makemytrip.com.
When she reached to catch the train she found that she left the ticket at her hotel. What
should she do?
(a) She can’t board the train.
(b) She should book a new ticket at station.
(c) She should go back and get the ticket.
(d) She can download the e-ticket from the website.
v) Identify the limitations of a database.
(a) Improved security (b) User friendly
(c) Reduced redundancy (d) Security and recovery overheads
vi) Which SQL keyword is used to retrieve a maximum value?
a) TOP() b) MOST() c) UPPER() d) MAX()
SECTION - B
(SUBJECTIVE TYPE QUESTIONS)
Answer ANY 3 out of the given 5 questions on Employability Skills. (2x3=6)
Q.7 Write the full form of RESPECT.
Q.8 Write the steps to sort data in LibreOffice Calc.
Q.9 Differentiate between Intrinsic motivation and Extrinsic motivation.
Q.10 Write the steps to protect your spreadsheet in LibreOfficeCalc?
Q.11 Write the steps to overcome personality disorders.
Answer ANY 3 out of the given 5 questions. (2 x 3 = 6)
Q.12 What are the data types used in MySQL. (Any four)
Q.13 What is SQL?
Q.14 Explain any two operations performed on database.
Q.15 Give two benefit of online reservation.
Q.16 REEMA wants to arrange names of students in alphabetical order in the student table.
Give the MYSQL command to create a sorted list.

HALF YEARLY EXAM | IT | CLASS 12 | 2024-25 | PRINTED Q 24 PRINTED PAGES 5 | PAGE# 4

Answer ANY 2 out of the given 3 questions. (3x2=6)
Q.17 Mention any three key characteristic of a project.
Q.18 (a) Rina wants to display the details of employee whose name starts from s. Find errors
in given MySQL command and write the correct statement.
select* from employee where name like *s;
(b) Classify them into DDL or DML commands
Update, delete, create , alter
Q.19 (a) Name two e-commerce websites.
(b) What are the challenges in online learning? (Any two)
Answer ANY 3 out of the given 5 questions. (4 x 3=12)
Q.20 Define the following terms in respect to Relational Database.
(a) Relation (b) Domain (c) Degree (d) Cardinality
Q.21 Write any four precautions while Performing Online Transactions.
Q.22 Consider the table SALES and write the SQL commands for the following statement:

(a) To display the name and salary for east area.
(b) To display the highest salary.
(c) Update the salary by 10% for all the employees.
(d) Delete the record E04.
Q.23 What are the advantages of Web-based applications?
Q.24 Consider the following table SHOP and write the SQL commands for the following
statement:

a) Create a table SHOP.
b) Display details of all item in the descending order of Price
c) Display Item whose price is between 40 and 100
d) Add a new column Quantity datatype as int and size(4) to the table SHOP.

HALF YEARLY EXAM | IT | CLASS 12 | 2024-25 | PRINTED Q 24 PRINTED PAGES 5 | PAGE# 5

Study Materials
Notes

Model Papers Class 6 Notes

Sample Papers Class 7 Notes
Half Yearly Sample Papers Class 8 Notes

Class 9 Notes
Important Resources
Class 10 Notes
Periodic Table
Class 11 Notes
Writing Skills / Formats

Maps of India / World Class 12 Notes

Books and Solutions

NCERT Books
NCERT Book Solutions
HC Verma Chapter Wise Solutions
RD Sharma Solutions
CGBSE Solutions