MID-TERM SAMPLE PAPER, CLASS-XII, IT-SKILLS 802
INFORMATION
TECHNOLOGY (SUBJECT CODE 802)
CLASS XII(SESSION
2022-2023)
SECTION A
Max.
Time: 3 Hours Max.
Marks: 60 General Instructions:
1. Please read the instructions carefully.
2. This Question Paper consists of 24
questions in two sections – Section A & Section B.
3. Section A has Objective type questions
whereas Section B contains Subjective type questions.
4. 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.
5. All questions of a particular section must
be attempted in the correct order.
6. SECTION A - OBJECTIVE TYPE QUESTIONS (30
MARKS):
i.
This section has 06 questions.
ii.
There is no negative marking.
iii.
Do as per the instructions given.
iv.
Marks allotted are mentioned against each question/part.
7. SECTION B – SUBJECTIVE TYPE QUESTIONS (30
MARKS):
i.
This section contains 18 questions.
ii.
A candidate has to do 11 questions.
iii.
Do as per the instructions given.
iv.
Marks allotted are mentioned against each question/part.
Answer
any 4 questions out of the given 6 questions (1 x 4 = 4 marks)
Q1
|
1. |
Define communication? Communication is the process of sharing information,
ideas, between two or more nodes. It is a two-way process, involving a sender
and a receiver. |
1 |
|
2. |
2. Which of the following can be a barrier to active
listening? (a) Noisy environment (b) Not maintaining an eye contact with the speaker (c) Not being attentive (d) All of the above |
1 |
|
3. |
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 |
1 |
|
4. |
__________________is derived from the word ‘motive’ The
word motivation
is derived from the word motive. |
1 |
|
5. |
Expand the term SMART in smart goal. S: Specific M: Measurable
A:
Achievable R: Realistic
5. T: Time Bound |
1 |
|
6. |
State true or false. “Self-Motivation is significant in building
one’s personality. “ True |
1 |
Q2 Answer any 5
questions out of the given 6 questions
(1 x 5 = 5 marks)
|
1. |
Mona is helping her sister to overcome a
personality disorder. What should she do? (a) Talk to her sister (b) Engage her in hobbies (c) Help her build confidence (d) All of the above |
1 |
|
2. |
Name any two anti-viruses. Here are some examples of antivirus programs:
|
1 |
|
3. |
What is effective communication? 1. Improved understanding. 2.
Stronger relationships
and builds trust between people. 3.
Improve efficiency and
productivity. 4.
Help to make better
decisions. 5.
Help to generate new
ideas and solutions. |
1 |
|
4. |
________________is a collection of raw facts which have not been
processed to reveal useful information. Data |
1 |
|
5. |
People
with such a disorder are characterized by lack of self-confidence and an
extra need to be looked after are known as _________________________. Dependent personality disorder (DPD). |
1 |
|
6. |
Which SQL keyword is used to sort the result? a)
ORDER BY b) SORT c) ORDER d) SORT BY |
1 |
Q3 Answer any 6
questions out of the given 7 questions
(1 x 6 = 6 marks)
|
1. |
________________ commands delete the tuples from a Table i.
Drop ii. Delete
iii. Modify
iv. None of the above DELETE
FROM table_name WHERE
condition; The table_name is the name of the table
from which you want to delete tuples. The WHERE clause is optional, but
if you specify it, only the tuples that satisfy the condition will be
deleted. |
1 |
|
2. |
Which of the following
methods are used to receive information from the sender through an audio
mode? a. Listening b.
Speaking c. Reading
d. Writing |
1 |
|
3. |
Define Stress. Stress can be
defined as our emotional, mental, physical and social reaction to any
situation. |
1 |
|
4. |
Mention any two ways to maintain positive attitude. 1. Time
management 2. Physical
exercise and fresh air 3. Healthy diet 4. Positivity 5. no delaying,
keeping track of all deadlines 6. Holidays with
family and friends 7. Minimum sleep
of 7 hours a day |
1 |
|
5. |
___________________,
which is also referred to as ‘self-control’, is the ability to control one’s
emotions, thoughts and behaviour effectively in different situations. Self-management |
1 |
|
6. |
__________________are
defined as relatively lasting patterns of thoughts, feelings and behaviour
that distinguish individuals from one another. Personality traits |
1 |
|
7 |
People with this disorder frequently try to gain more attention
by being overly dramatic is called as _________________________ Histrionic personality disorder (HPD) |
1 |
Q4 Answer any 5
questions out of the given 6 questions
(1 x 5 = 5 marks)
|
1. |
Name any one central initiative for e-governance. One
central initiative for e-governance is the Digital India program (any
relevant) |
1 |
|
2. |
Which website should we search for the list of NCERT e books? website: https://ncert.nic.in/ |
1 |
|
3. |
Define the following 1) Database 2) Database management system 3) A database is
an organized collection of structured information, or data. It is also called
as Single Repository. A database is usually controlled by a
database management system (DBMS). |
1 |
|
4. |
Write the name of any two DBMS. Some examples of DBMS are –
MySQL, Oracle, DB2, IMS, IDS etc. |
1 |
|
5. |
Who developed the RDBMS? E.F Codd at IBM |
1 |
|
6. |
Why there is a need /requirement of Database 1. Databases
are designed to store and manage large amounts of data efficiently. 2. To
ensure data accuracy and integrity. 3. To
protect the data, it provides the features such as user authentication, data
encryption, and access control. 4. Databases
can be used to store and manage data. |
1 |
Q5 Answer any 5
questions out of the given 6 questions
(1 x 5 = 5 marks)
|
Which of the
following queries will give the same output? (a) select
rollno, name from student where subject in ('Information
Technology','Informatics Practices'); (b) select
rollno, name from student where subject between 'Information Technology' and
'Informatics Practices'; (c) select
rollno, name from student where subject ='Information Technology' and subject
='Informatics Practices'; (d) select
rollno, name from student where subject ='Information Technology' or subject
=' Informatics Practices '; a
and c |
1 |
|
|
2. |
Write the command to see the structure of a table? Describe or DESC |
1 |
|
3. |
Write any two precautions should be followed while
performing online transactions. Never click on a suspicious link. 2. Make sure that passwords
are strong and are changed frequently. Never disclose personal information such as date
of birth, account details, passwords, credit and debit card details. |
1 |
|
4. |
Explain Drop table with Cascade command.
SYNTAX: DROP TABLE customers
CASCADE; |
1 |
|
5. |
The datatype for the |
1 |
|
6. |
________________ (The National Portal of India) : This is the
National Portal of India, which provides a single window access to
information and services being provided by the various Indian Government
entities. The
National Portal of India is: India.gov.in. It is a one-stop shop for information and
services provided by the various Indian Government entities. It is a mission
mode project under the National E-Governance Plan (NEGP) of the Government of
India. |
1 |
Q6 Answer any 5
questions out of the given 6 questions
(1 x 5 = 5 marks)
|
1. |
Difference between data and information. Data
is a collection of raw facts and figures. It is unprocessed and unorganized,
and it does not have any inherent meaning. Information
is data that has been processed, organized, and interpreted. It has meaning
and can be used to make decisions or solve problems. |
1 |
|
2. |
To retrieve names of all the teachers having 6 characters in the
first name and starting with 'R’. SELECT first_name FROM teachers WHERE first_name LIKE 'R_ _ _ _ _'; |
1 |
|
3. |
___________ is not an aggregate function a. Sum() b. Count() c. Round()
d. Avg() |
1 |
|
4. |
_______ replaces zero or more number of random character, when
used with Like keyword. a. _ b. %
c. $ d. @ |
1 |
|
5. |
Command which displays
list of databases available on the current server. i. Show
databases ii. Show tables Iii. Create
tables Iv display
table |
1 |
|
6. |
Select distinct dept_name from department; What does the above
query do? a) It gives all
the tuples having dept_name b) It gives the dept_name attribute values of all tuples without
repetition c) It gives all
the dept_name attribute of all the tuples d) It gives all
the dept_name attribute of any the tuples |
1 |
SECTION B
Answer any 3 questions out of the
given 5 questions (3 x 3 =
6 marks)
|
7. |
Aman wants to shop shoes online. Write detailed Steps/ procedure
to be followed while shopping online.
|
2 |
|
8. |
Write the syntax of Select Command and its use too. SELECT column1, column2, ... FROM table_name WHERE condition;
|
2 |
|
9. |
List the various ways in
which database management applications can be used in Government Sector. 1. For storing details of tax records like sales tax, house tax etc. 2.
Store and manage census data 3.
Maintaining criminal
records 4.
To store details of PAN
cards, AADHAR cards 5.
Vehicle registration 6.
Birth/death certificate
registration 7.
Mid-day meal Record 8.
Widow Pension |
2 |
|
10. |
Tino wants to go for a school trip. He is thinking
of booking a flight. (a) Name any one site
which he should browse for booking an air ticket. (b) Give any one benefit
of online reservation to Amit? (c) What are the
precautions to be followed while performing online transactions? (d) Give any one advantage
to the company providing online reservation? a) One site that Tino can browse for booking an
air ticket is MakeMyTrip. b)
One
benefit of online reservation for Tino is that it is convenient and
time-saving. c)
Make sure
that you are using a secure connection. Look for the https:// prefix in the
website address. d)
One
advantage to the company providing online reservation is that it can reduce
costs. |
2 |
|
11. |
What are the Phases in a Web Application
Project? 1. Requirements Definition Phase: In this phase we identify the problem and the
scope of the problem. 2. Design Phase: The focus
is on "how" the application is to be designed. 3. Implementation Phase: Create backend database, frontend and the
connectivity between them. 4. Testing Phase: Test the
complete application with dummy set of data to find error and then fix it. |
2 |
Answer any 3 questions out of the given 5
questions
(3 x 2 = 6 marks)
|
12. |
Name the commonly used built-in
aggregate functions(any four). The commonly used built-in aggregate functions in
SQL are: ·
COUNT: Returns the number of rows in a table or
in a specified group of rows. ·
SUM: Returns the sum of the values in a column or
in a specified group of rows. ·
AVG: Returns the average of the values in a
column or in a specified group of rows. ·
MIN: Returns the smallest value in a column or in
a specified group of rows. ·
MAX: Returns the largest value in a column or in
a specified group of rows. |
2 |
|
13. |
Name any 2 educational websites and 2 educational
App? Websites: ·
Khan Academy ·
Coursera Apps: ·
PHYSICS WALLAH ·
UNACADEMY |
2 |
|
14. |
Write any four datatype of SQL. ·
Character data types: CHAR, VARCHAR ·
Numeric data types: INT,DECIMAL. ·
Date and time data types: DATE, TIME ·
Boolean data types: TRUE and FALSE. |
2 |
|
15. |
Write the command to DROP table student. SYNTAX: DROP TABLE table_name; Example: DROP TABLE student; The DROP TABLE command is irreversible. Once
you drop a table, all of the data in the table is lost permanently. |
2 |
|
16. |
Mention the significance of online Education. 1. Recorded video or slides of lectures are
available. 2. Can
be accessed anywhere, any time 3. User
may ask questions, and get their queries answered. 4. It
provides freedom to the learner to learn at their convenient location,
convenient time 5. There
is no discrimination of age, caste, gender, background, or the qualification
of the learner |
2 |
Answer any 2 questions out of the given 3
questions (2 x 3 = 6 marks)
|
17. |
Difference between Webinar and seminar. Webinars are real time lectures on online
mode(virtually), where users participate in the lecture, may ask questions,
and get their queries answered. Seminars are real time lectures on offline mode
(Physically), where users participate in the lecture, may ask questions, and
get their queries answered. |
3 |
||||
|
18. |
Differentiate between frontend and backend.
|
3 |
||||
|
A Hospital is
making database of patients and its staff. Doctor table includes Docid,
Dname, and Department. Give details of Patient Table along with its schema The Patient table in a
hospital database can include the following columns: ·
Patient ID: A unique identifier for the
patient. ·
First Name: The patient's first name. ·
Last Name: The patient's last name. ·
Date of Birth: The patient's date of birth. ·
Gender: The patient's gender. ·
Address: The patient's address. ·
Phone Number: The patient's phone number. CREATE TABLE patients ( patient_id INT NOT NULL, first_name VARCHAR(255) NOT NULL, last_name VARCHAR(255) NOT NULL, date_of_birth DATE NOT NULL, gender VARCHAR(255) NOT NULL, address VARCHAR(255) NOT NULL, phone_number VARCHAR(255) ); |
3 |
Answer any 3 questions out of the
given 5 questions (3 x 4 =
12 marks)
|
20. |
What are the various types of USERS of DBMS? 1. End Users: Users who use the
database for querying, modifying and generating reports as per their needs. 2. Database Administrator (DBA): DBA
administers the database and the DBMS. The DBA is responsible for authoring
access, monitoring its use, providing technical support, acquiring software
and hardware resources. 3. Application Programmers: Application
programmers write application programs in high level languages and SQL to
interact with the database. 4.
System
Analyst: System analyst determines the requirements of the end users and then
develops specifications to meet these requirements. |
4 |
|
21. |
What are the advantages of Online Reservation System for
Producer and Consumer? Advantages for Producer 1. Requires Less Staffing: Less
man-power is required. 2. No Spatial Restrictions: The
physical location of the office and space does not matter to a customer who
is reserving tickets online. 3. Global Access: Anyone anytime who has
Internet connection can do online reservation. Advantages for Consumer 1. Convenient: The user/consumer can
book tickets anytime anywhere. 2. Price Comparison: Can check
the Price of different providers 3. Confirmation of Reservation: When a
booking is done, the confirmation of the booking just takes a few seconds. 4. Time Saving: Online reservation
consumes very less time. 5. Discount Scheme: Season
discount, advance booking discount and frequent user discount. |
4 |
|
22. |
What are the responsibilities of each phase of Project with
name? 1. Requirements Definition Phase: In this phase we identify the problem and the
scope of the problem. 2. Design Phase: The focus
is on "how" the application is to be designed. 3. Implementation Phase: Create backend database, frontend and the
connectivity between them. 4. Testing Phase: Test the
complete application with dummy set of data to find error and then fix it. |
4 |
|
23. |
Write the difference between
DROP and DELETE Command in sql with syntax. DROP is a
Data Definition Language (DDL) command. It is used to remove named elements
of a schema, such as tables, views, constraints, and triggers. It also
removes all of the data in the dropped element. DROP TABLE
table_name; DELETE is a
Data Manipulation Language (DML) command. It is used to remove specific rows
from a table. It does not remove the table itself DELETE FROM table_name
WHERE condition; |
4 |
|
24. |
Write the main elements of communication
skill and make a labelled diagram. The main
elements of communication skills are: ·
Sender: The person who
initiates the communication. ·
Receiver: The person who
receives the communication. ·
Message: The information
that is being communicated. ·
Channel: The medium through
which the message is communicated. ·
Feedback: The receiver's
response to the message. ( Relevant Diagram) |
4 |
FOR SUGGESTIONS COMMENT
Comments
Post a Comment