Information Technology Sample Paper Class 12

Information Technology Sample Paper Class 12 Term-1 2021-22

Subject Code: 802

Max. Time Allowed: 90 Minutes

Max. Marks: 30

Check Term 2 Sample Paper here

General Instructions:

1. This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.

2. Section A is of 05 marks and has 06 questions on Employability Skills.

3. Section B is of 20 marks and has 25 questions on Subject specific Skills.

4. Section C is of 05 marks and has 07 competency-based questions.

SECTION A

Answer any 5 questions out of the given 6 questions on Employability Skills (1 x 5 = 5 marks)

1. Active listening is important in workplace because if we actively listen to other people (select the one which is not correct)

a) they will be more interested in communicating with us.

b) we can develop a long-term working relationship with others.

c) we can easily identify challenges and difficulties others are facing and provide solutions to it

d) we will become more popular in the workplace. ✓

2. Which of the following personality trait fall in the Big Five popular personality classification:?

a) Gregarious ✓

b) Avoidant

c) Borderline

d) Obsessive

3. The contents of cell A1, A2, A3, and A4 in a Spreadsheet application are 10, 15, 20, 25 respectively. If the formula =COUNT(A1:A4) is entered in cell A5, ___________ value will be displayed in A5.

a) 70

b) 4

c) 45 ✓

d) 65

4. What not to do during an interview

a) Do take notes

b) Let your achievements speak for you.

c) Answer questions fast and use slangs.

d) Ask questions ✓

5. ________________Is a condition in which people seek excessive attention and admiration and lack of empathy

a) Paranoid

b) Narcissistic ✓

c) Antisocial

d) Dependent

6. What will be displayed, if the following formula is entered in cell A1 in a spreadsheet application

= 6^2 + 15/3 *2 – 7

a) 39 ✓

b) 15

c) -14

d) -38

SECTION B

Answer any 20 questions out of the given 25 questions (1 x 20 = 20 marks)

7. Which of the following is a disadvantage of web based applications:

a) They do not need be installed.

b) They are available 24X7.

c) They are slow as compared to software based applications. ✓

d) They offer cross platform compatibility.

8. Internet transactions are susceptible to frauds. Creating a strong password is vital. A strong password has:

a) 6-8 Alphanumeric characters

b) Special symbols

c) Only numbers

d) Both a and b ✓

9. DEITY stands for:

a) Department of Electrical and Information Technology

b) Department of Electronics and Information Technology ✓

c) Department of Electronics and Informatics Technology

d) Department of Electrical and Informatics Technology

10. Which SQL keyword is used to display the data based on certain pattern?

a) LIKE ✓

b) IN

c) BETWEEN

d) RANGE

11. Sagun is creating a table SALESMAN with fields Salesman number, Name, Total Sales. She doesn’t want the Total Sales column to be remain unfilled i.e. she wants to make entry in this field mandatory. Which constraint she should use at the time of creating SALESMAN table:

a) Check

b) Default

c) Not null ✓

d) Primary key

12. Ranjana wants to delete the records where name starts with A from the table

CUSTOMER having fields Name, Amount, Discount. Identify the correct command:

a) Delete CUSTOMER where name like “A%”;

b) Delete from CUSTOMER where name like “A%”; ✓

c) Delete CUSTOMER where name = “A%”;

d) Delete from CUSTOMER where name = “A%”;

13. Consider a table STAFF:

Select the command which will count the number of people in each city.

a) SELECT COUNT(City) , City FROM STAFF WHERE GROUP BY City;

b) SELECT COUNT(City) , City FROM STAFF GROUP BY City; ✓

c) SELECT COUNT(City) , City FROM STAFF WHERE ORDER BY City;

d) SELECT COUNT(City) , City FROM STAFF ORDER BY City;

14. Consider the Table EMPLOYEE given below:

Name Zone Age Dept

Harit West 28 10

Kritika Centre 30 10

Naveen East 40 20

Uday North 38 30

Nupur East 24 20

Moksh South 28 10

Shelly North 24 30

Choose the correct query/queries that will give the following output:

Name

Harit

Kritika

Moksh

i) Select Name from EMPLOYEE where DEPT in (10);

ii) Select Name from EMPLOYEE where AGE between 25 and 30;

iii) Select Name from EMPLOYEE where NAME like “%i%”;

iv) Select Name from EMPLOYEE where ZONE in (“West”, “Centre”, ”South”);

Choose the correct option

a) Only (i)

b) Both (i) and (ii)

c) Both (ii) and (iv)

d) All (i), (ii) and (iv) ✓

15. The ______________command is used to modify the structure of the table STUDENT in MySQL.

a) Modify table STUDENT

b) Alter table STUDENT ✓

c) Alter STUDENT

d) Modify STUDENT

16. Consider a table FACTORY:

Reema wants to calculate the average production of the years 2008-2012. Help her select the correct SQL command for it:

a) SELECT AVERAGE(Production) from FACTORY;

b) SELECT AVERAGE(Production) from FACTORY group by Production;

c) SELECT SUM(Production) from FACTORY;

d) SELECT AVG(Production) from FACTORY; ✓

YEAR Production

2008 12000

2009 10000

2010 10600

2011 15000

2012 14500

17. The National Portal of India provides a single window access to information and services being provided by the various Indian Government entities Which of the following is the website for the National Portal of India:

a) india.gov.in ✓

b) india.gov.org

c) indian.gov.in

d) indian.gov.org

18. Online shopping is an e-commerce application where the customer can purchase  goods over the Internet. There are several websites where the customer can go for online shopping. Select from the options given below which of the following is not an online shopping website:

a) snapdeal.com

b) myntra.com

c) coursera.org ✓

d) infibeam.com

19. Garvit wants to change the default value of DISCOUNT in the CUSTOMER table from 10 to 15. Select the most appropriate command to do the same from the following options:

a) ALTER TABLE CUSTOMER ALTER DISCOUNT SET DEFAULT 15; ✓

b) ALTER TABLE CUSTOMER DELETE DISCOUNT SET DEFAULT 15;

c) ALTER TABLE CUSTOMER MODIFY DISCOUNT SET DEFAULT 15;

d) ALTER TABLE CUSTOMER CHANGE DISCOUNT SET DEFAULT 15;

20. Consider a table: COACHING having fields CITY_NAME, ENROLMENTS. Shikhar wants to display the data of the above table in ascending order of enrolments.

Choose the correct query/queries from the following:

i) Select * from coaching order by enrolments asc;

ii) Select * from coaching order by enrolments desc;

iii) Select * from coaching order by enrolments;

iv) Select * from coaching order by enrolments ascending;

Select the correct option:

a) Only (i) is correct

b) Both (i) and (ii) are correct

c) Both (i) and (iii) are correct ✓

d) Only (iv) is correct

21. Geeta wants to know the usage of NULL in MySQL. Help her choose in which of the following case NULL value cannot be assigned to the column Admission_Number:

a) When the Admission_Number is zero ✓

b) When the Admission_Number is not known

c) When the Admission_Number is not available

d) When the Admission_Number is not applicable

22. _________are real time lectures, where users participate, may ask questions, and get their queries answered.

a) Interactive tutorials

b) Video tutorials

c) Power Point Presentation

d) Webinars ✓

23. There are four main phases of development a Web Application Project.

Statement 1: The scope of the application is decided in the first phase.

Statement 2: The data connectivity is established between the Front-End interface and Back-End Database in the implementation phase.

Select the correct option:

a) Only Statement 1 is correct

b) Only Statement 2 is correct

c) Both Statement 1 and Statement 2 are correct ✓

d) None of the above statements are correct

24. Which of the following is NOT an advantage of DBMS approach:

a) All the data is stored at one place. There is no repetition of the same data.

b) There is a single copy of data that is accessed or updated by all the users.

c) The DBA can provide security to the database by controlling users’ database access rights.

d) Designing the database specifications and writing application programs is a time-consuming process. ✓

25. An attribute A of datatype varchar(20) has the value “Keshav”. The attribute B of datatype char(20) has value ”Meenakshi”. How many characters are occupied in attribute A and attribute B?

a) 20,6

b) 6,20 ✓

c) 9,6

d) 6,9

26. Consider the table ‘empsal’.

ID Salary Dept

Q101 54000 10

Q103 67000 20

Q105 75000 20

Q109 NULL 30

Read the following two commands carefully:

i) select COUNT(salary) from empsal;

ii) select COUNT(*) from empsal;

Choose the correct option:

a) Both i and ii will give the same output as 3.

b) The output of i is 3 and the output of ii is 4. ✓

c) Both i and ii will give the same output as 4.

d) The output of i is 4 and the output of ii is 3.

27. Cardinality of a table is four and degree is three. If two columns and four rows are added to the 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

28. Consider a table ‘SCORE’:

ROLLNO NAME STREAM OPTIONAL

1 Greesha Science 10

2 Satish Commerce 30

3 Teena NULL 20

4 Yasmine Humanities 10

5 Yashika Science 10

5 Lalit Humanities 20

Reema wants to display names of those students who have not been assigned any stream. Help her select the correct query:

a) Select name from SCORE where stream =NULL;

b) Select name from SCORE where stream =null;

c) Select name from SCORE where stream = “ “;

d) Select name from SCORE where stream is NULL; ✓

29. Consider the table SCORE in Q28. Select the correct query from the options given below to display the names of all streams only once.

a) Select distinct stream from score; ✓

b) Select distinct(stream) from score;

c) Select unique stream from score;

d) Select stream from score where stream = distinct;

30. Online reservation systems are advantageous both for the company providing reservation services and for the consumer who uses the online reservation system for booking.

i) User can read reviews posted by people while making choices during reservation.

ii) More man-power is required by providers to ensure smooth functioning.

Choose the correct justification to the statement given above:

a) Only i ✓

b) Only ii

c) Both i and ii

d) Neither i nor ii

31. Reeta is going to her aunt’s house to spend her vacations. To book her rail tickets online she needs to create new account on the reservation portal. Which of the following is NOT a correct step to do the same?

a) Sign up on the reservation portal.

b) Fill the registration form.

c) The fields marked with a star (*) are optional. ✓

d) Click the submit button after filling the form.

SECTION C

(COMPETENCY BASED QUESTIONS)

Answer any 5 questions out of the given 7 questions (1 x 5 = 5 marks)

32. Read the following statements carefully about E-governance

i) It is the use of electronic tools for governance.

ii) It has decreased the transparency in the system.

iii) E-governance empowers the citizens socially and economically.

iv) It enables citizens to access information after paying money.

Choose the correct option from the following:

a) Both i and ii are correct

b) Both ii and iii are correct

c) Both i and iii are correct ✓

d) Only iv is correct

33.Consider a Table STORE shown below:

Consider a table OWNER shown below:

OwnerId OwnerName

A145 Divyam Prakash

B178 Neha Sultan

D112 Gargi Chhabra

Choose the correct query to display the number of employees present in Delhi and Mumbai.

i) Select SUM(noofemployee), Location from STORE group by location HAVING location in (“Delhi”,”Mumbai”);

ii) Select SUM(noofemployee), Location from STORE group by location WHERE location in (“Delhi”,”Mumbai”);

iii) Select SUM(noofemployee), Location from STORE group by location HAVING location =“Delhi” and location=”Mumbai”;

iv) Select SUM(noofemployee), Location from STORE group by location WHERE location =“Delhi” or

location=”Mumbai”;

Choose the correct option:

a) Both i and ii

b) Both ii and iii

c) Both iii and iv

d) Both i and iii ✓

StoreId StoreName Location NoOfEmployee OpeningYear OwnerId

S101 Libas Delhi 45 2007 A145

S102 Life Style Mumbai 68 2000 B178

S103 Vogue Mumbai 50 1999 B178

S104 Pantaloon Chennai 78 2004 D112

S105 Max

Fashions

Delhi 80 2020 A145

34. Consider the table STORE given in Q33. Choose the correct query to display Stores names, Location and Date of Opening of stores that were opened before 2015.

a) Select storename, location, OpeningYear from store where OpeningYear <”2015”; ✓

b) Select storename, location, OpeningYear from store where OpeningYear >”2015”;

c) Select storename, location, OpeningYear from store where OpeningYear =2015;

d) Select storename, location, OpeningYear from store where OpeningYear !=2015;

35. Consider the table STORE given in Q33. Radhika wants to add a new column SALE on type integer to the table. Choose the correct query for the same:

a) Add column SALE integer;

b) Alter table add SALE integer;

c) Alter table store add SALE integer; ✓

d) Alter table store modify SALE integer;

36. Consider the table STORE and OWNER given in Q33. Seema wants to display StoreName and OwnerName of all stores in Mumbai. Help her select the correct query from the options given below:

a) Select StoreName, OwnerName from STORE, OWNER where store.OwnerId=Owner.OwnerId or Location=”Mumbai”;

b) Select StoreName, OwnerName from STORE, OWNER where store.OwnerId=Owner.OwnerId and Location=”Mumbai”; ✓

c) Select StoreName, OwnerName from STORE, OWNER where Location=”Mumbai”;

d) Select StoreName, OwnerName from STORE, OWNER where OwnerId=OwnerId and Location=”Mumbai”;

37. Consider the table STORE given in Q33. Radhika wants to display the following output:

Store Id Store Name No Of Employee

S101 Libas 45

S102 Life Style 68

Choose the correct command:

i) Select StoreId, StoreName, NoOfEmployee from STORE where StoreId=102 or StoreId=101;

ii) Select StoreId, StoreName, NoOfEmployee from STORE where StoreName=”Libas” or StoreName=”Life Style”;

iii) Select StoreId, StoreName, NoOfEmployee from STORE where Location=”Delhi” or Location=”Mumbai”;

iv) Select StoreId, StoreName, NoOfEmployee from STORE where StoreName like ”L%”;

Choose the correct option:

a) (i) and (ii) are correct

b) (i), (ii) and (iii) are correct

c) (i), (ii) and (iv) are correct ✓

d) All are correct

38. Rajat is compiling a detailed list with a clear description of application features of his project and recognizing the limitations that are placed on the project. Out of the given options choose the phase of the project in which Rajat is currently in:

a) Requirements Definition Phase ✓

b) Testing Phase

c) Implementation Phase

d) Design Phase