Page 1 :
SECTION A, , (3 + 2 = 5 marks), , Answer any 3 questions out of the given 4 questions. Each question is of mark., Q.1, Q.2, Q.3, , Ans : They are confident, , Q.4, , Ans : Charanka - Gujarat Solar Park, , 1x3=3, , Ans : Myth, , 1, 1, , Ans : one such practice is : organic farming/ vermicomposting etc., , 1, 1, , Answer any 1 question out of the given 2 questions. Each question is of 2 marks., Q.5, , Ans : Any two functions of an entrepreneur are :, , Q.6, , a. making decisions:, b. Managing the business, Ans : Two easy to reduce inequalities are :, - be helpful to one another., - be friendly with everyone, , SECTION B, , 2x1=2, 2, , 2, , (4 + 8 = 12 marks), , Answer any 04 questions out of the given 06 questions, Q.7, MODEM, 1 mark for the correct answer, Q.8, Toggle key, 1 mark for correct answer, Ans: client server, Q.9, 1 mark for correct answer, Q.10, Ans: TINYINT, SMALLĪNT, INTEGER, NUMERIC, BIGINT, , 1x4=4, 1, 1, 1, 1, , Q.11, Q.12, , (½ mark for each integer datatype), Ans: One to Many Relationship or Many to One Relationship, Ans: A report helps to display the data in a summarized manner. It is used to generate, the overall work outcome in a clear format. You can create reports in the database., , Answer any 04 questions out of the given 06 questions, Ans. Four advantages are :, , Q.13, , Q.14, , Q.15, , Data Sharing, Files Transfer, Hardware Sharing., Internet Access Sharing, Usage of network based applications, ½ marks for each correct advantage listed, Ans: A wired setup uses physical cables to transfer data between different devices and, computer systems. Wireless network does not use wires for data or voice. Examples, Wired: Dial-up, DSL or Cable Internet Access etc, Wireless .3G or WiMAX or Wi-Fi, 1 marks for correct difference, ½ marks for each correct example, Ans:, An Internet service provider (ISP) is an organization which provides you with access to, the Internet via a dial-up (using modem) or direct (hard wired) or wireless connection., DSL, cable modem, dial-up, broadband wireless, WiMAX etc, 1 marks for the correct definition and 1/2 each for correct connection type, , 1, 1, 2x4=8, , 2, , 2, , 2

Page 2 :
Q.16, , Ans:, Entry Required – if set to yes then it will be necessary for the user to insert the value in, the field which means that field cannot be left blank., Default Value – A default value can be set for a field if user don’t provide any value, while entering the values in the table., , Q.17, , 2, , (1 mark for each property), Ans:, Referential Integrity is used to maintain accuracy and consistency of data in a, relationship. In Base, data can be linked between two or more tables with the help of, primary key and foreign key constraints., Referential integrity helps to avoid:, 1. Records can be added to a related table, if there is no associated record, available in the primary key table., 2. The values can be modified in a primary if any dependent records are present in, the associated table(s)., 3. Deleting records from a primary key table if there are any matching related, records available in associated table(s), , 2, , ( 1 mark for definition. ½ mark each for any two purposes.), Q.18, Ans:, Columns, , Data type, , Flight No, No.of Passengers, Airlines, Arrival Time, Departure Time, Fares, , Text, Integer, Text, Date/Time, Date/Time, Float, , 2, , (½ mark for each column & data type), , SECTION C, , (2 x 4 = 8 marks), , (COMPETENCY BASED QUESTIONS), Answer any 02 questions out of the given 03 questions, Q.19, , Ans, a., Google Talk , Yahoo! Messenger , Skype , Windows Live Messenger , Rediff Bol,, MS-Teams, ZOOM etc., ½ marks for each correct name, b. Headphone, Speaker & Microphone & Web Camera, ½ marks for each correct hardware listed, , 4

Page 3 :
Q.20, , Ans:1. credit, debit card or by internet banking etc, (1/ 2 marks for each correct options), 2., • A customer does not have sufficient time to visit stores., • Visiting a store is more expensive than purchasing a product online., • A product or service that is not available in the local market is available online. etc, (1/ 2 marks for each correct situation ), 4, 3.Flipkart , amazon, Myntra etc, (1/ 2 marks for each correct name of website), 1. Cash On Delivery, 1 marks for correct full form, , Q.21, , Ans:, a., b., c., d., , Select * from Teachers where subject = “COMPUTER”;, Select * from teachers where salary >= 20000 and salary <= 35000;, Select Subject from Teachers where age > 40;, Select * from Teachers order by name, , Q.21, FOR, Ans:, VISUALLY, IMPAIRED, STUDENTS a. Data, , Integrity: Data Integrity is very important as there are multiple databases in, a DBMS. It means that the data is accurate and consistent in the, database., , b. Data Inconsistency: Data inconsistency is when the same data exists in, different forms in multiple tables. Which can provide a unreliable or meaningless, information., c. Composite Primary Key: It is also called a composite key. It is a combination of, two or more columns to form a primary key for a table, d. Relationship: A relationship refers to an association or connection between two or, more tables. When we relate two tables, we don't need to enter the same data in, separate tables., , Three types of relationships are:, 1. One to One relationship, 2. One to many or many to one relationship, 3. Many to many relationships, (1 mark each for all the parts.), , 4