INFORMATION TECHNOLOGY (SUBJECT CODE 802)
Sample Question Paper with Solution for Class XII
(Session 2022-2023)
Max. Time: 3 Hours Max. Marks: 60
General Instructions:
- Please read the instructions carefully.
- This Question Paper consists of 24 questions in two sections – Section A & Section B.
- Section A has Objective type questions whereas Section B contains Subjective type questions.
- Out of the given (6 + 18 =) 24 questions, a candidate has to answer (6 + 11 =) 17 questions in the allotted (maximum) time of 3 hours.
- All questions of a particular section must be attempted in the correct order.
- SECTION A – OBJECTIVE TYPE QUESTIONS (30 MARKS):
- This section has 06 questions.
- There is no negative marking.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
- SECTION B – SUBJECTIVE TYPE QUESTIONS (30 MARKS):
- This section contains 18 questions.
- A candidate has to do 11 questions.
- Do as per the instructions given.
- Marks allotted are mentioned against each question/part.
SECTION A: OBJECTIVE-TYPE QUESTIONS
| Q. 1 | Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) | |
| i. | What is a Start up? Answer: A startup is a company that is in the first stage of its operations. Startups can be started with minimum investment. | 1 |
| ii. | Ms Sharma has saved marks of all students in a spreadsheet. What should she do to find out three students with the highest total marks? Answer: she can sort the data on the total marks. | 1 |
| iii. | Why do entrepreneurs require persistence as one of the competences to succeed? Answer: Persistence is the ability to continue to do something, even when it is difficult. It is one of the attitudes and competencies to become a successful entrepreneur. | 1 |
| iv. | Vikky had big dreams when he was studying. He worked hard for achieving his dreams and has achieved his goals. Which of the following options does the given fact refer to? a. Positive thinking b. Result Orientation c. Self Awareness d. Emotional management Answer: b. result orientation | 1 |
| v. | Rina loves interacting with people and is, generally, talkative. She can easily make friends and make any gathering lively, is confident. Identify the type of personality Reema possesses. a. Nervous b. Extrovert c. Paranoid d. Agreeable Answer: b. Extrovert | 1 |
| vi. | State true or false. “Self-Motivation is significant in building one’s personality. “ Answer: true | 1 |
| Q. 2 | Answer any 5 out of the given 7 questions (1 x 5 = 5 marks) | |
| i. | Which of the following is not a characteristic of a project? a. Project has a beginning and an end. b. The extent of the project is defined. c. Project has no boundaries. d. Project requires finite resources Answer: c. Project has no boundaries. | 1 |
| ii. | A group of statements which get executed based on a condition in java is called . (i) Selection (ii) Sequential (iiii) Iteration (iv) None of these Answer: (i) Selection | 1 |
| iii. | Which of the following is true for self-referencing table? a. A foreign key constraint can reference columns within the same table. b. A primary key constraint can be null. c. You cannot delete this table. d. You cannot update or delete this table. Answer: a. A foreign key constraint can reference columns within the same table. | 1 |
| iv. | Identify the operator that performs pattern searching in MYSQL. a. EXISTS operator b. BETWEEN operator c. LIKE operator d. SEARCH operator Answer: (c) LIKE | 1 |
| v. | What should we do to make a data member or a method member of a class visible only within the class? Answer: To make a data member or a method member of a class visible only within the class, we add the keyword private before its declaration | 1 |
| vi. | Name any one central initiatives for e-governance. Answer: NICNET – the national satellite-based computer network. Or District Information System of the National Informatics Centre (DISNIC) program to computerize all district offices | 1 |
| vii. | Which website should we search for the list of NCERT e books? Answer: http://www.ncert.nic.in | 1 |
| Q. 3 | Answer any 6 out of the given 7 questions (1 x 6 = 6 marks) | |
| i. | Name two domains where database management may be used. Answer: Education, banking (or any other 2 work areas) | ½+ ½ |
| ii. | If a=20 and b=30 What will be the value of a%=b? Answer: 20 | 1 |
| iii. | List any two advantages of DBMS. Answer: Reduction in Redundancy, Improved Consistency (or any other 2 advantages) | 1 |
| iv. | This website includes sites of different states and union territories of India, sites of government departments like judiciary and legislature. Which is this website? a. goidirectory.nic.in ii. godirectory.nic.in iii. indiagov.in iv. india.gov.in Answer: goidirectory.nic.in | 1 |
| v. | Cardinality of a table is four and degree is three. If two columns and four rows are added to this table, what will be the new degree and cardinality of the given table? (a) 5,8 (b) 3,4 (c) 8,5 (d) 4,3 Answer: a. 5,8 | 1 |
| vi. | The Phase of application development that involves creating a database and writing code is called Answer: Implementation Phase | 1 |
| vii. | b. Identify the valid variable names from the following Total marks , int , marks$ , marks4 Answer: marks$ , marks4 are valid variable names | 1 |
| Q. 4 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
| i. | This website provide high quality online courses for free, in collaboration with various universities across the globe. Which is this website? a. coursera.org b. khan academy c, w3schools.org d. cbse.nic.in Answer: a. Coursera.org | 1 |
| ii. | While entering the data in the table, Seema is not able to leave the column age as blank in the table. What can be the possible reason? Answer: NOT NULL constraint in age column | 1 |
| iii. | Mention any two modes of payment during online shopping. Answer: different modes of payment – credit card, debit card, Net Banking, Cash on Delivery or e-gift voucher (mention any 2) | ½+ ½ |
| iv. | What is the need of JVM? Answer: When the bytecode (also called a Java class file) is to be run on a computer, a Java interpreter, called the Java Virtual Machine (JVM), translates the bytecode into machine code and then executes it | 1 |
| v. | Which of the following queries will give the same output select rollno, name from student where subject in (‘Information Technology’,’Informatics Practices’);select rollno, name from student where subject between ‘Information Technology’ and ‘Informatics Practices’;select rollno, name from student where subject =’Information Technology’ or subject =’ Informatics Practices ‘; select rollno, name from student where subject =’Information Technology’ and subject =’Informatics Practices’; Answer: (a) and (c) are same | 1 |
| vi. | Which member function of the Integer wrapper class allows access to the int value held in it? Answer: intValue() member function of the Integer wrapper class allows access to the int value held in it. | 1 |
| Q. 5 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | – |
| i. | Sagar has declared an array whose last element is having an index/position as 10. What would be the size of this array? Answer: 11 | 1 |
| ii. | In the table teacher, Riya doesn’t want repeated values in column marks. Rewrite the correct command. select marks from teacher; Answer: SELECT DISTINCT MARKS FROM TEACHER; | 1 |
| iii. | Rema wants to input the price of shoes as 999.99 .What should be the datatype and size of the column price in the table? Answer: Decimal (6,2) | 1 |
| iv. | What is an exception in java? Answer: An error situation that is unexpected in the program execution and causes it to terminate unexpectedly is called an exception | 1 |
| v. | How can you write multiline comments in java program? Answer: Writing the comment between the symbols /* and */ | 1 |
| vi. | What is the purpose of wait () method in java threads? Answer: This method is useful when you have multiple threads running but you want one of them to start execution only when another one finishes and notifies the first one to resume execution | 1 |
| Q. 6 | Answer any 5 out of the given 6 questions (1 x 5 = 5 marks) | |
| i. | What are the two ways to create a thread in java? Answer: In Java, threads can be created in two ways 1. By extending the Thread class 2. By implementing the Runnable interface | ½ + ½ |
| ii. | What is the difference between the following two java statements? int x=5;integer y= new integer(50); Answer: In the first declaration, an int variable is declared and initialized with the value 50. In the second declaration, an object of the class Integer is instantiated and initialized with the value 50. OR The variable x is a memory location and the variable y is a reference to a memory location that holds an object of the class Integer. | ½ + ½ |
| iii. | Roma is booking a railway ticket using an online ticketing website makemytrip.com. When she reached to catch the train she found that she left the ticket at her hotel. What should she do? she can’t board the trainshe should book a new ticket at stationshe should go back and get the ticketShe can download the e-ticket from the website. Answer: d. She can download the e-ticket from the website | 1 |
| iv. | What is the MYSQL command to list the names of teachers in alphabetical order in the teacher table? Answer: SELECT Name FROM Teacher ORDER BY Name; | 1 |
| v. | Write the command to see the structure of a table? Answer: DESCRIBE | 1 |
| vi. | What do we mean by scope of a project? Answer: The focus is on “what” the application must do. Recognizing the limitations that are placed on the project. | 1 |
SECTION B: SUBJECTIVE-TYPE QUESTIONS
Answer any 3 out of the given 5 questions on Employability Skills (2 x 3 = 6 marks) Answer each question in 20 – 30 words.
| Q. 7 | Rohan has a successful start-up company. According to him ‘Decision Making is considered to be one of the important entrepreneurial competencies. Do you agree with Rohan.? Justify. Answer: Yes. If an entrepreneur does not have the ability to make suitable and timely decisions, the person may miss out on an opportunity and incur losses | ½+1½ |
| Q. 8 | What do we mean by SMART goals? Answer: SMART goals means: – S: Specific a goal should have a specific purpose. M: Measurable Goals should always be measurable. A: Action-oriented Goal setting should include action-based steps. R: Realistic Goals must always be realistically attainable. T: Timely Goals must have deadlines or specified time limit. | 2 |
| Q. 9 | What is a workbook? Name any one spreadsheet application. Answer: A workbook is a spreadsheet that has one or more worksheets eg Calc (or any other application) | 1½+½ |
| Q. 10 | How do you protect your spreadsheet from unauthorised access? Which menu option you will click to protect your spreadsheet? Answer: Protect your spreadsheet using a password. Click on Tools and select Protect Spreadsheet | 1+1 |
| Q. 11 | What are the various organizational skills required to become a successful entrepreneur? Answer: Ability to make the optimum use of time, energy and resources to achieve the desired goals like time management, Goal setting, efficiency, Managing quality. | 2 |
Answer any 3 out of the given 5 questions (2 x 3 = 6 marks)
| Q.12 | What will be the value of rem after the execution of the following code snippet? why? code =2; switch(code) {case 1: rem= 8; case 2: rem= 9; case 3: rem= 10; break; case 4: rem= 11; break;} Answer: 10 Fall through statement since there is no break in case 2 | 1+1 | |
| Q.13 | The following commands are giving errors. Write the correct MYSQL commands. alter table student delete marks;select * from employee where name =‘%s%’; Answer: ALTER TABLE STUDENT DROP MARKS; SELECT * FROM EMPLOYEE WHERE NAME LIKE ‘%S%’; | 1+1 | |
| Q.14 | Ms Prabha has mistakenly entered ‘‘AMIT’’ instead of ‘‘AMITA’’ in name field of table ‘TEACHER’. Help her to write the correct SQL command to make the desired changes in the table Answer: UPDATE Teacher SET NAME =”AMITA” WHERE NAME=”AMIT”; | 2 | |
| Q.15 | A company is making database of its items and shipment. Item table includes item code, item name, item cost . Give details of Shipment Table along with its schema. Answer: SHIPMENT (Shipment_id, Details, Shipment_date) Name Type Remarks Shipment_id INT(10) Shipment number (Primary Key) Details VARCHAR(30) location details Shipment_date DATE Date of shipment (or ANY OTHER RELEVANT ATTRIBUTES) | 1+1 | |
| Q.16 | What is the difference between a while and a do-while loop? Answer: A while loop is an entry controlled loop it tests for a condition prior to running a block of code. A do-while loop is an exit control loop. OR A while loop runs zero or more times Body of loop may never be executed A do-while loop runs once or more times but at least once. | 1+1 | |
Answer any 2 out of the given 3 questions (3 x 2 = 6 marks)
| Q.17 | Consider the following code int x = 1; while(x<=5); x = x +1; Name the coding error shown in the above code.What is the reason of the error? (c)Write correct java code. Answer: Syntax error This loop is an infinite loop. while ( x <=5 ) | 1+1+1 |
| Q.18 | Give any two characteristics of a relational model.Which aggregate function is used to find the average of all the values for a selected attribute of a table. Answer: (a) In relational model, 1.A column is called an Attribute. 2.The value in each tuple is an atomic value. (Or any other 2 characteristics) (b) AVG | 2+1 |
| Q.19 | List the various ways in which database management applications can be used in Government Sector. Answer: Database management application cab used in For storing details of electoral roll, all types of taxes (Income tax, sales tax, house tax etc.), criminal records, details of PAN cards, AADHAR cards, vehicle registration, birth/death certificate registration. | 3 |
Answer any 3 out of the given 5 questions (4 x 3 = 12 marks)
| Q.20 | What are String Class Methods in Java? Consider the statement String name = ‘‘Hello World’’. Write a single line Java code using String methods to perform the following : Convert the name to lowercase.Replace “Hello” by “Welcome” in the given string.Check whether the name contains ‘‘Sin’’ in it or notAdd a new string ‘‘jackpot” at the end of original string. Answer: a. name.toLowerCase( ) b. name.replace(”Hello”,“Welcome”) c. name.contains(”Sin”) d. name.concat(”jackpot”) | 1+1+1+1 |
| Q.21 | Mr. Amit wants to go for a business trip .He is thinking of booking a flight. Name any one site which he should browse for booking an air ticket.Give any one benefit of online reservation to Amit?What are the precautions to be followed while performing online transactions?Give any one advantage to the company providing online reservation? Answer: a. makemytrip.com (or any other reservation site) b. Convenient, time saving (or any other benefit) c. Make a password complex like mix case, use numbers and special characters. Be cautious not to leave passwords around. (or any other precaution) d. Requires Less Staffing, No Spatial Restrictions (or any other benefit) | 1+1+1+1 |
| Q.22 | Write a code in java using a for loop to display all odd numbers between 1 to 10. Is for loop an entry controlled loop or exit control loop? Answer: Loop to print odd numbers between 1 to 10: – for (int count = 1; count <= 10; count = count +2) { System.out.println(count); } Entry control loop | 3+1 |
| Q.23 | What is the need of a constructor in OOP? Explain all features of a constructor. Answer: A special method member called the constructor method is used to initialize the data members of the class. Features of Constructor: – The constructor has the same name as the class, has no return type, and may or may not have a parameter list. Whenever a new object of a class is created, the constructor of the class is invoked automatically. We do not call the constructor explicitly. | 1+3 |
| Q.24 | Write the Mysql commands for the following queries :- TRAIN TrainID Station 0001 DELHI 0002 MUMBAI COUNTER TicketID Date Cost TrainNo T1 12/3/22 500 0001 T2 15/5/22 450 0002 T3 15/5/22 500 0001 To find all the stations, date for ticket id as T1.To find the total ticket amount collected from each station.To displays all the tables created in the current database.To delete table counter along with the information in it. Answer: a. SELECT , DATE FROM TRAIN, COUNTER WHERE TRAIN.TrainID=COUNTER.TrainNO and TicketID=”T1”; b. SELECT SUM(COST), STATION FROM TRAIN, COUNTER WHERE TRAIN.TrainID=COUNTER.TrainNO GROUP BY STATION; c. SHOW TABLES; d. DROP TABLE COUNTER; | 4 |
