IT Question Paper CLASS - XI - Sahodaya Board - 2023-24

Class 11th  Question Paper for Information Technology of Sahodaya Board 

Section - A [EMPLOYABILITY SKILL] (10 MARKS)

Part A (Attempt any four questions out of six questions) (1x4=4)

1. Give two benefits of Teamwork.

2. Having conscious knowledge of your own self, capabilities, feelings and one's own character is called a) Self-awareness b) Self-motivation c) Self-control

3. What are the three different types of business activities? 

4. What are components of Green economy? 

5. What is the shortcut key for spell check?

6. Track changes are suggestions. If you want to make the changes permanent, you have to them.

a) Underline

 b) Save

 c) Accept

 d) Reject

Part-B/Attempt any three questions out of five questions) (2x3=6)

7. Explain the verbal method of communication.

8. Explain the three main principles which can be followed to grow a business.

9. Explain any three types of customer needs.

10. What is the importance of personal hygiene?

11. How to set Goals using a model? 

Section-B [SUBJECT SKILL: IT] (50 MARKS)

Part-A (Attempt any 26 questions out of 30 questions (1 x26=26)

1. How to make TextField uneditable?

2. Which SQL command is used to view the tables in the database?

3. What is the use of DISTINCT keyword in SQL queries?

4. Define record.

5. Explain IN operator.

 6. Which method is used to add two strings together? Give example also.

 7. Define Cardinality

 8. Which statement is used to delete rows from a table?

a) DROP

b) NULL

c) DELETE

 d) ALTER

9. QUERY: select * from student where roll_no=10;

 What is the use of symbol in the above statement?

10. What do you mean by OOP concept?

11. List any two features of MySQL

 12. Give the names of different logical operators used in Java NetBeans.

 13. What is a combo box?

 14. Which method is used to retrieve the value typed by the user in a textbox or label?

 a) setText()

 b) getText()

 c) getter()

 d) setter()

 15. What is the use of Power Supply Unit in the computer system?

 16. Define Topology.

 17. Which Tab consists of Header and Footer option?

 18. Which combination of keys is used to forcefully end the application?

 19. An operating system that allows several processors to perform computation as the same time is call:

 a) Single Program

 b) Multitasking

c) Multiprocessing

d) Real Time Processing

20. Which of the following is not the characteristic of ROM:

a) It is generally used in startup operations of computer.

b) It is a non-volatile

c) Read Only Memory

d) It is generally placed between CPU and Primary memory and acts as a buffer.

21. Which of the following is not a popular word processor?

a) Wordpad

b) Google Docs

c) Notepad

d) Libre Office Writer

22. Antus is software that aims to protect your system against malicious and potentially unwanted programs.

23. What is the use of autofill option in spreadsheet software?

24. Define Phishing.

25. What is the difference between wrapping the text and shrinking the text in OpenOffice Calc?

26. What do you mean by digital literacy?

27. Name any four types of charts which can be used in OpenOffice Calc.

28. Hacking may be described as having computer system. access to someone's

a) malicious

b) unauthorized

c) permanent

d) permitted

29. Which software of OpenOffice is used to make presentations?

30. Shortcut key to start slide show is

a) F4

b) FS

c) F6

d) FS

Part-B (Attempt any three questions out of five questions) (2x3=6)

31. Table-EMPLOYEE

Emp_ID	Emp_Dept_ID	EMP_Name	Emp_City	Emp_Salary
EM1	D1	Ananya	Ludhiana	40000
EM2	D4	Priyanka	Jaipur	28600
EM3	D3	Prabh	Delhi	35000
EM4	D2	Kavita	Delhi	40000

a) Identify candidate Key(s) in a table. 

b) Identify Alternate Key(s) in a table.

c) Which Key will be considered as a Primary Key in a table?

32. Give the rules and conventions for naming a variable in Java. (Any 4)

33. Explain any two types of operating system

34. What is the difference between Save and Save As in OpenOffice Writer?

 35. What is the difference between TELNET AND FTP?

 Part-C (Attempt any two questions out of three questions) (3x2=6)

 36. What is the difference between Relative referencing and Absolute referencing?

 37. When you are not getting sound properly from the speakers, which troubleshooting steps you should follow? Explain in detail.

 38. Explain the block diagram of a computer system in detail.

 Part-D (Attempt any three questions out of four questions) (4x3=12)

 39. Explain any four network devices.

 Give different ways in which presentation slides can be viewed.

 41. Design a GUI application to accept the price of an apple and calculate the amount to be paid of one dozen and two dozen.

42 Follow the table and answer the questions in the form of queries:

PLAYER_SN	PLAYER_NAME	PLAYER_CITY	PLAYER_SCORE	PLAYER_SALARY
2	Rajesh	Jaipur	100	10000
3	Suresh	Delhi	90	20000
4	Aman	Jaipur	50	40000
5	Rajni	Tonk	39	50000
6	Harsih	Barmer	69	20000
7	Pjiu	Sikar	77	80000

a) To increase the salary of Player by 50% if he scored a century.

b) To display unique city from table Player.

 c) Add a new record in above table with the following data:

(8, piyush, kota, 90, 14000)

 a) List the names of Players who belong to city Jaipur or Tonk.