Important Competency Based Questions Class 10 IT 402 with Solution

Share with others

Competency Based Questions Class 10

Competency Based Questions Class 10

Competency Based Questions Class 10
Competency Based Questions Class 10

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.

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.

Competency Based Questions Class 10

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.

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

Competency Based Questions Class 10

Competency Based Questions Class 10
Competency Based Questions Class 10

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.

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.

Competency Based Questions Class 10

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.

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?

Competency Based Questions Class 10

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?

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.

Competency Based Questions Class 10

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.

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.

Competency Based Questions Class 10

Q13. Consider the following table : Student

AdmnoNameClassSec
S121Aman9A
S122Suman10C
S123Ravi11E
Competency based Questions Class 10

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.

Q14. Consider the following table : Employee

EmpidNameSalaryDesignation
121Sonam50000Manager
125Naman38000Sales Executive
148Bhanu32000Clerk
Competency based Questions Class 10

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.

Competency Based Questions Class 10

Q15. Consider the following table : Furniture

FidTypePriceWeight
F298Double Bed4000025
F192Sofa4600022
F231Dressing Table150008
Competency based Questions Class 10

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.

Q16. Consider the following table “Hotel”.

RoomidC_NameTariffType_of_Room
321Rahul3500Deluxe
122Suman3000Semi deluxe
120Alok2500Normal
Competency based Questions Class 10

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.

Competency Based Questions Class 10

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.

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.

Competency Based Questions Class 10

Q19. Consider the following table: Order

Order_idOrder_dateValueDiscount
12562022-02-20400003000
13572022-01-13350001000
10242021-09-17450003500
Competency based Questions Class 10
  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.

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.

Competency Based Questions Class 10


Disclaimer : I tried to give you the correct solution of “Competency based Questions Class 10 , but if you feel that there is/are mistakes in the solution of “Competency based Questions Class 10” given above, you can directly contact me at csiplearninghub@gmail.com. NCERT Book and Study material available on CBSE official website are used as a reference to create above “Competency based Questions Class 10


Competency Based Questions Class 10

Unit 1 : Introduction to IT–ITeS Industry BOOK SOLUTIONS

Unit 1 : Introduction to IT–ITeS Industry NOTES

Unit 1 : Introduction to IT-ITeS MCQ

Unit 3 : Digital Documentation NOTES

Unit 3 : Digital Documentation BOOK SOLUTIONS

Unit 3 : Digital Documentation MCQ

Unit 4 : Electronic Spreadsheet BOOK SOLUTIONS

Unit 4 : Electronic Spreadsheet MCQ

Unit 5 : Digital Presentation MCQ

UNIT 1: DIGITAL DOCUMENTATION (ADVANCED) MCQ

UNIT-2: ELECTRONIC SPREADSHEET (ADVANCED) MCQ

UNIT-3 RELATIONAL DATABASE MANAGEMENT SYSTEMS (BASIC) MCQ

UNIT-4 WEB APPLICATIONS AND SECURITY MCQ

IT Question Paper Class 10 with Solution

IT Question Paper Class 10 with Solution

Competency Based Questions Class 10

Competency Based Questions Class 10

Competency Based Questions Class 10

Competency Based Questions Class 10

Competency Based Questions Class 10

Competency Based Questions Class 10


Share with others

2 thoughts on “Important Competency Based Questions Class 10 IT 402 with Solution”

  1. Namaste. Thank you for guiding us with all the notes, MCQs and Competency Based Questions. Please provide all the updates also .Thank u very mujch

    Reply

Leave a Reply

%d bloggers like this: