Q1. Parth is a student of class 10.

His computer teacher taught him about Accessibility options which will
enable a person with a disability or impairment to use a computer. He was curious to know about the types of
impairment that impact computer usage. Being a friend of Parth, explain him any four such types of
impairments.
Ans. There are numerous types of impairment that impact computer usage. These include:
1. Cognitive impairments and learning disabilities, such as dyslexia, attention deficit hyperactivity
disorder (ADHD) or autism.
2. Visual impairment such as low-vision, complete or partial blindness, and color blindness.
3. Hearing impairment including deafness.
4. Motor or dexterity impairment such as paralysis, cerebral palsy, and repetitive strain injury.

Q2. Aman’s computer has Window’s XP operating system. He wants to open the Accessibility Options. He also
wants to customise his keyboard but forgot the functionality of all the keys available on the keyboard tab of
Accessibility Options window. Help him to open the Accessibility Options window and also explain the
functionality of all the keys.
Ans. Steps to open the Accessibility option are : Click Start > Control Panel > Accessibility Options.
Keys available on Keyboard tab are:
1. StickyKeys : It is an accessibility feature to help computer users with physical disabilities, but it is also used
by others as a means to reduce repetitive strain.
2. FilterKeys : It is an accessibility feature that tells the keyboard to ignore brief or repeated keystrokes,
making typing easier for people with hand tremors.
3. ToggleKeys : It is an accessibility feature which is designed for people who have vision impairment or
cognitive disabilities

Q3. Kashish is making a list of students who have some impairment or disability due to which they are not able
to use the computer. Identify which Accessibility option will allow them to use the computer regardless of their
disability.
Ambuj : Suffering from Hand tremor.
Shikhar : Auditory impairment.
Simran : Difficulty in using mouse.
Ramesh : Difficulty in using mouse and keyboard both.
Ans. Ambuj : Filter Keys
Shikhar : Sound Sentry
Simran : Mouse Keys
Ramesh : Serial Keys

Q4. Soumya is a student of class X. Her Computer teacher has given an assignment. She has done all the
questions except the following. Help her to complete the assignment.
1. The computer which provide services in a network is called Client.(T/F)
2. What is Client – Server Architecture?
3. Cursor Options is an accessibility feature that assists people with vision impairment by changing
the _____ rate and __________ of the cursor.
4. Ans. 1. False
5. 2. Networks in which certain computers have special dedicated tasks, providing services to other
computers (in the network) are called client server networks.
6. 3. blink, width

Q5. Anshu is a student of class X. She has scored very low marks in her computer exam so she requested her
teacher to show her the paper. She had a mistake in the following questions. Being a friend of Anshu, explain
her the following questions.
1. What is WWW?
2. Expand the following terms:
1. MAN
2. P2P
3. Write any two Key Features of an instant messaging.
Ans. 1. WWW stands for World wide web. It is a system of interlinked hypertext documents accessed via
the Internet.
2. Full forms are :
1. MAN : Metropolitan Area Network
2. P2P : Peer to Peer
3. Two Key Features of an instant messaging are:
1. Text Messages can be sent to one or more person.
2. Video calling and conferencing.

Q6. Raman is a Computer teacher in a private school. He has 4 computers in a computer lab where his
colleagues used to work. All the computers are stand alone and not connected with the internet. He called a
Network engineer to form a network of 4 computers. Answer the following questions in reference to the given
situation.
1. What type of Network will be formed?
2. Which application/software is required in all computers to browse internet? Give two examples.
3. Write any two advantages of Computer Network.
4. Name any two ISP.
Ans.
1. LAN
2. Application/software is required in all computers to browse internet is Web Browser. for
example Internet Explorer, Mozilla Firefox.
3. Two advantages of Computer Network are :
1. Data Sharing
2. Hardware Sharing
4. Two ISP are:
1. Airtel
2. Jio

Q7. Raman had applied for job in a company via email last week. Today he received a mail from HR
department of the company regarding his interview date. His interview will be conducted online (due to Covid-
19) using video conferencing and instant messaging software. Answer the following questions in reference to
the given situation.
1. What is Video Conferencing?
2. Name any two hardware which is required for video conferencing.
3. Write any two features of instant messaging software.
4. Name two types of instant messaging software.
Ans.
1. Video conferencing is face to face meeting between two or more participants from
different locations.
2. Hardware required for video conferencing are: (Write any two)
1. Microphone
2. Headphone or Speaker
3. Web Camera
3. Two features of instant messaging software are: (Write any two)
1. Text Messages can be sent to one or more person (Similar to SMS)
2. Audio calling and conferencing.
3. Video calling and conferencing.
4. File transfers (Not limited to documents, spread sheets, audio files, video files, etc.)
5. Message history (Save messages for future reference).
4. Two types of instant messaging software are:
 1. Application based
2. Web based

Q8. Aman and Suman want to start an IT blog where they can share their knowledge about computers and
technology with others.
1. Name any four websites where Aman and Suman can create their blog for free.
2. Write the following steps of creating and publishing post in sequence.
1. Click Publish Post.
2. Click New Post.
3. Give title to the post.
3. What do you mean by publishing a post?
Ans.
1. Websites that offer free blog services are:
1. www.WordPress.com
2. www.blogger.com
3. www.blog.com
4. www.weebly.com
2. Steps to create and publish post are:
1. Click New Post.
2. Give title to the post.
3. Click Publish Post.
3. Publishing a post means to make the post public. Once we finished typing the content, we need
to publish the post for others to see

Q9. Raman is an engineer working in an IT company. He wants to replace his DSL with a good speed Wi-Fi
internet connection for home so that his kids can attend uninterrupted online classes.
1. Write the full form of Wi-Fi and DSL
2. Write any one difference between Wi-Fi and DSL.
3. What is Modem?
4. What you need for using DSL connection?
Ans. 1. Full forms are :
 Wi-Fi : Wireless Fidelity
 DSL : Digital Subscriber Line
2. Wi-Fi is a wireless type of connectivity while DSL is a Wired type of connectivity.
3. A modem is a device that converts digital signals to analog signals that can travel over phone
lines. It also re-converts the analog signals back into digital signals.
4. For using a DSL connection, we need a DSL modem and a subscription.

Q10. Suman used to work in a private Bank. She lost her job due to Covid Pandemic. So she decided to create a
YouTube channel where she will show some kitchen tips and recipes. For making good quality videos she needs
some accessories like a good mobile, tripod stand etc. Suman discussed this with her friend Anju and she
suggested that you can buy all these products Online.
1. What is Online Shopping?
2. Write any four payment methods offered by Flipkart.
3. Write any two situations where online shopping will be useful.
Ans. 1. Online shopping is a form of electronic commerce where customers can buy or sell goods
over the Internet.
2. Flipkart offers multiple payment methods like credit card, debit card, net banking, e-gift
voucher, and Cash on Delivery.
3. Situations where Online shopping will be useful are: (write any two)
 1. A customer does not have sufficient time to visit stores.
2. Visiting a store is more expensive than purchasing a product online.
3. A product or service that is not available in the local market is available online.

Q11. Internet provides so many opportunities for students and teachers. Now a days it is more important to
strengthen Internet security to deal with new and emerging online threat. According to a survey many students
and teachers are worried about their online safety. Software, Firewalls, strong passwords, spreading awareness
etc. are the best practices to avoid cyber threat.
1. What do you mean by Internet Security?
2. Name any two online threat.
3. What is Firewall?
4. Name any one website which help us to generate a random strong password.
Ans. 1. Internet security is a branch of computer security specifically related to the Internet,
often involving browser security but also network security.
2. Online threats are:
 Phishing
 Email Spoofing
 Chat spoofing
3. Firewalls could be software or hardware and can assist in keeping a computer and a network
secure. Firewalls analyze the network traffic and determine if the traffic should be allowed or
not.
4. www.strongpasswordgenerator.com help us to generate a random strong password.

Q12. Every organization must follow a standard set of safety rules and procedures. These rules must be stated
and displayed clearly in the important areas . All the employees must be given a demonstration and training to
follow safety rules – Fire safety, Falls and slips, Electrical safety, Use of first aid. Timely repairs should be
carried out by a competent person or organization at workplace to avoid any hazards.
1. Write any two basic Fire safety rules in an organization.
2. What do you mean by First Aid?
3. What is Occupational Hazards? Name any four types of Occupational Hazards.
Ans. 1. Basic Fire safety rules in an organization are: (write any two)
 Conduct regular drills
 Fire escape plans must be installed at proper levels
 Smoke alarms must be placed at proper intervals
 Keep workplace a no-smoking zone
 Maintenance of safety equipment must be taken care of regularly.
2. First Aid is the immediate assistance provided to the injured to save life and minimize health
loss till the proper medical aid/ facility is provided
3. An occupational hazard is the illness one may acquire due to his occupation. Four types of
Occupational hazards are : Physical hazards, chemical hazards, biological hazards, , behavioural
hazards, radiological hazards, ergonomic hazards etc.

Q13. Consider the following table : Student

Admno Name Class Sec

S121 Aman 9 A

S122 Suman 10 C

S123 Ravi 11 E
Write SQL Commands
1. Display detail of all Students.
2. Display all the details of “Aman.”
3. Display Name and Class of a student whose Admission Number is S122.
4. Display the details of all the students in alphabetical order of Name.
Ans. SQL commands are
1. Select * from Student;
2. Select * from Student where Name = “Aman”;
3. Select Name, Class from Student Where Admno = “S122”;
4. Select * from Student order by Name;

Q14. Consider the following table : Employee

Empid Name Salary Designation

121 Sonam 50000 Manager

125 Naman 38000 Sales Executive

148 Bhanu 32000 Clerk

Write SQL Commands

1. Display details of all Employees whose salary is less than 50000.
2. Display half of the salary amount paid to all the Employees.
3. Display details of all the Managers.
4. Increase the salary of Bhanu by 4000.
Ans. SQL commands are:
1. Select * from Employee where Salary < 50000;
2. Select Salary/2 from Employee;
3. Select * from Employee where Designation = ” Manager”;
4. Update Employee set Salary = Salary + 4000 where Name = “Bhanu”;

Q15. Consider the following table : Furniture

Fid Type Price Weight

F298 Double Bed 40000 25

F192 Sofa 46000 22

F231 Dressing Table 15000 8

Write the SQL commands for the following:

1. Display price of Double Bed.
2. Display details of furniture whose price is more than 20000 and less than 40000.
3. Replace the Type of “F192” from “Sofa” to “Sofa-set”.
4. Display the details of all furniture in increasing order of price.
Ans. SQL commands are :
1. Select Price from Furniture where Type = “Double Bed”;
2. Select * from Furniture where Price > 20000 and Price < 40000;
3. Update Furniture set Type = “Sofa-set” where Fid = “F192”;
4. Select * from Furniture order by Price;
Q16. Consider the following table “Hotel”.
Roomid C_Name Tariff Type_of_Room

321 Rahul 3500 Deluxe

122 Suman 3000 Semi deluxe

120 Alok 2500 Normal

Write SQL commands for the following

1. Display all the records of table.
2. Display Roomid, Customer Name and double the tariff amount.
3. Change the customer name from “Alok” to “Aman”.
4. Display details of all the “Deluxe” room.

Ans. SQL commands are :

1. Select * from Hotel;
2. Select Roomid, C_Name, Tariff*2 from Hotel;
3. Update Hotel set C_Name = “Aman” where C_Name = “Alok”;
4. Select * from Hotel where Type_of_Room = “Deluxe”;

Q17. Suppose if you own a stationary shop, you need to keep detailed records of the materials available in your
shop. You also need to store information about pricing, stock levels for reordering, old stocks, etc. in a database
program.
1. Name any two database programs to organize the data as per your business need.
2. When was the database concept was evolved?
3. What is DBMS? Explain in brief.
Ans. 1. Two database programs are : Microsoft Access, OpenOffice.org Base, and MySQL
2. Database concept was evolved in 1960.
3. DBMS stands for Database Management System. It is a software package with computer
programs that controls the creation, maintenance, and use of a database.

Q18. Aman has a small library at home. He want to store the details of all books in RDBMS. He created a table
with five fields by name “Aman_Lib” in the RDBMS program. He also created a primary key in that table.
1. What do you mean by table?
2. What is the purpose of creating a primary key in table?
3. Aman can create more than one primary key in his table.(Yes/No)
4. Expand RDBMS.
Ans. 1. A table is a collection of logically related data stored in the form of rows and columns.
2. As all the values in Primary key are unique so it helps in searching the records and
maintaining uniqueness in a table.
3. No, Aman can not create more than one primary key in his table.
4. Relational Database Management System.

Q19. Consider the following table: Order

Order_id Order_date Value Discount

1256 2022-02-20 40000 3000

 1357 2022-01-13 35000 1000

1024 2021-09-17 45000 3500

1. Which field is suitable for Primary Key?

2. How many fields and records are there in Order table?
3. Write SQL commands for the following:
1. Display details of all orders whose discount is more than 1000.
2. Display details in increasing order of value.
Ans. 1. Order_id
2. There are 4 fields and 3 records.
3. SQL Commands are:
1. Select * from Order where Discount > 1000;
2. Select * from Order order by value;

Q20. Aman wants to create a table in OpenOffice Base. He wants to set the field properties during creation of
table. Help him to identify the suitable field properties for the following task.
1. Which property will help to get the auto numeric values.
2. Which property will help to set the format of the data entered in the field.
3. Which property, if set to yes then it will be must to insert the value in the field.
4. Which property will help to set the default value of a field.
Ans.
1. Auto Value
2. Format
3. Entry Required
4. Default Value