CLASS -- X (IT Practice Set)

 TERM II (PRACTICE SET)

SECTION  A
Attempt any 3 questions out of the given 4 questions. Each question is of 1 mark.
Q.1	Name the term used for false belief or opinion about something.
Q.2	Write the full forms of WCED and SDG.
Q.3	State two disadvantages of entrepreneurship as a career.
Q.4	How an individual can contribute in controlling air pollution?
Attempt any 1 question out of the given 2 questions. Each question is of 2 marks.
Q.5	What are the myths about entrepreneurship?
Q.6	What is the focus and aim of sustainability?
SECTION B
Answer any 04 questions out of the given 06 questions. Each question is of 1 mark.
Q.7	What do you mean by Report in Open Office Base?
Q.8	Write four online threats.
Q.9	What do you mean by Report in Open Office Base?
Q.10	Explain the term packet with reference to data transfer.
Q.11	Define cardinality.
Q.12	What is a blog?
Answer any 04 questions out of the given 06 questions. Each question is of 2 marks.
Q.13	Define the following terms : 1. Table 2. Fields 3. Records
Q.14	Expand the following  terms: LAN,  MAN,  WAN,  DSL, ISP, WWW,  P2P,  Modem
Q.15	Define any five types of keys.
Q.16	Explain any four best practices to secure data.
Q.17	Identify the columns and data types of a table: Employee.  Mention at least four columns with data type.
Q.18	Give any four basic safety rules for ensuring Falls and Slips safety.
SECTION  C (COMPETENCY BASED QUESTIONS)
Q.19	Write the queries for the following table : Item Itemno Iname Price Qty 12 Pen 10 17 13 Eraser 5 15 14 Notebook 15 20   a. Write a query to insert a new record of following details (15, “Pencil”, 20, 10) b. Display the name of item whose price is 10. c. Write a query to change the quantity of Item number 13 to 25. d. Write the suitable data type of field “Iname”
Q.20	Which command is used for the following task in database, write their Syntax ? a.       To insert a new record b.      To modify the existing data. c.       To delete a record d.      To display record
Q.21	Bharti is a young woman from Bihar. Many girls in her area like to wear earrings. She buys jute from a farmer and makes earrings from that. Her business is called Manavi Natural Handicrafts. She sees that most women in her village do not work. So, she hires two women to help them. a. What demand did Bharti identify in her village? b. What is the local resource that Bharti used? c. How is Bharti helping her village grow? d. How was she creating more jobs?
		TERM II (PRACTICE SET) Section A Attempt any 3 questions out of the given 4 questions. Each question is of 1 mark. Q1) Why is it important to adopt sustainable development ? Q2) What is SDGs? Q3) What is the full form of DBMS and RDBMS?Write one advantage of DBMS. Q4) Write one disadvantage of eurship as a career.Entrepreneurship as a career ? Attempt any 1 question out of the given 2 questions. Each question is of 2 marks. Q5) Write two Myths about entrepreneurs. Q6) Write two solutions related to sustainable development ? Section B Answer any 04 questions out of the given 06 questions. Each question is of 1 mark. Q8) What is a "Primary Key"? Q9) In which year the concept of 'Sustainable development' became popular as the Brundtland Report? Q10) What is a MODEM? Q11) A collection of related records is also known as …………..? Q12) When data is stored, maintained and retrieved from multiple tables then special database software is required called…………. Answer any 04 questions out of the given 06 questions. Each question is of 2 marks. Q13) What are 4 R's in reference to management of waste? Q14) Define Internet. Mention it's advantages. Q15) List any two websites that allow online transactions.And explain the benefits of online transactions. Q16)What are 4 types of network? Q 17) Describe any three long term solutions to sustainable development. Q18) State the main characteristics of an entrepreneur. SECTION C (COMPETENCY BASED QUESTIONS)  Q19) Saurabh and Gaurav are two friends who wants to share the pictures with messages of assignment assigned by their sir. They also want to interact by video conferencing.  1)Suggest any 4 good messaging apps that can help them.  2)Suggest any 2 video conferencing app.  3)List 2 hardwares that will be used for video conferencing.  Q21)Write SQL commands for the questions from (i) to (v) on the basis of table MASTER (contains details of employees) (i) Write a command to update the salary of the employee to 40000, whose SNo is 3. (ii) Write a query to add a column Date_of_ Joining to the table MASTER. (iii) Select Age, Department of those employees whose salary is greater than 12000. (iv) List all data of table MASTER. (v) Write a query to change the data type of a column Name to varchar with size 35. Q23)Write the SQL commands for the questions from (i) to (v) on the basis of table Employee.  (i) Display Employee Name and Salary of those employees whose salary is greater than or equal to 22000?  (ii) Display details of employees those are not getting commission.  (iii) Display employee name and salary of those employees who have their salary in range of 2000 to 4000?  (iv) Display the name, profile and salary of employee (s) who doesn't have manager?  (v) Display the name of employee whose name contains ‘‘A" as fourth alphabet