IT(402) Answer key

Section – A 1. Entrepreneur 2. Leadership 3. Biotic : Plants, Animals, Humans Abiotic: Air, Water 4. Using science and technology responsibly. Plant more trees and use eco-friendly bags. 5. Agricultural entrepreneurship provide supports to the farmers, understand the need of farmers, and enhance the skills of farmers for the commercialization. Agricultural Entrepreneurship can be defined as being primarily related to the marketing and production of inputs and products used in agricultural activities. Small scale entrepreneurship help society by creating wealth in local marketand local area. Small scale entrepreneurship refers to starting industries in which manufacturing, trading, providing services, productions are done on a small scale or micro scale. 6. Refuse: To create a sustainable environment, we must first REFUSE to use products that may harm the environment. Upcycle: Upcycling allows the scope of human skills upcycle any product that is not usable with innovation. Section -B 7. Internet Service Provider (ISP) 8. Firewall 9. First-aid 10. Composite Primary key 11. Record 12. Sorting means to arrange data in ascending or descending order 13. (i) Use combination of letters, symbols and digits (ii) Do not use birth day or any easily identifiable words (iii)Generate random password (iv) Avoid using something that the public or workmates know you strongly like or dislike (v) Recommended length of password is 12-14 characters

14. Blog Websites: www.wordpress.com www.weebly.com 15. LAN: It stands for Local Area Network. It connects computers and peripherals in limited geographical area. The connections are limited school, home, computer lab, office building, or closely positioned group of buildings. LAN offers high speed data transfer and uses Ethernet cables. WAN: It stands for Wide Area Network. It covers broad area. It covers metropolitan area, regional or national boundaries. The internet is the most popular example of WAN. It is used by large organizations, business, governments, NGOs, entertainers and many others. 16. One to many : In this kind of relationship one of the table must have primary key column. It means that one column of primary key table is associated with all the columns of associated table. As above example, emp and dept tables, empno is primary key for the EMP table. Many to many relationship: In this kind of relationship no table has primary key column. It means that all the columns of primary key table are associated with all the columns of associated table. 17. Forms provides an interface to users to view, add, modify in both table and queries. Reports are presented forms used to present formatted summaries or lists of the data from one or more table or queries 18. PID Char(4), Primary Key Pname - varchar (10) Runs – Integer (5) Gender – char (1) DOB - Date

Section – C 19. (a). He need to ensure that website URL must have lock icon at the beginning and starts with https (b). He can use a good antivirus software (c). Phishing refers to the internet represents an insecure channel for exchanging information leading to high risk of intrusion or fraud. (d). Cookies are programs that are created on your local computer when you visit websites, cookies aremeant for storing data based on activity performed during earlier visits. Cookies stores logon details, details of a shopping cart, visited pages in a website etc. They could be also tracked by unauthorized users and possibly gain access to personal information. 20. a) World Wide Web (abbreviated as WWW or W3, commonly known as the Web), is a system of interlinked hypertext documents accessed via the Internet. Two popular web browsers are: Google Chrome and Mozilla Firefox (b) The data transfer on the internet is done through the following steps: (i). Information on internet is divided into small packets. Each packet is sent from computer to computer until its find its destination. Each computer on the way decides where the next packet to be sent. All packets may hav etheir different routes. (ii). Once the packet reaches to its destination, packet will be examined. If any packets are missing or damaged, a message for sending it again will be sent. This process continues till all packets have been received. (iii). Finally all the packets reassembled into the original form. 21. (a) Select From STUDENT where house='GREEN';

(b) Update STUDENT SET marks=marks+5 from student where ADMNO=1005; (c) SELECT * From STUDENT where marks < 80; (d) SELECT* From STUDENT order by MARKS desc;