{"id":1426,"date":"2021-10-26T22:45:10","date_gmt":"2021-10-26T17:15:10","guid":{"rendered":"https:\/\/cbsepython.in\/?p=1426"},"modified":"2024-05-01T07:30:29","modified_gmt":"2024-05-01T02:00:29","slug":"information-technology-sample-paper-class-12","status":"publish","type":"post","link":"https:\/\/cbsepython.in\/information-technology-sample-paper-class-12\/","title":{"rendered":"Information Technology Sample Paper Class 12"},"content":{"rendered":"

Information Technology Sample Paper Class 12 Term-1 2021-22<\/span><\/h3>\n

Subject Code: 802<\/span><\/p>\n

Max. Time Allowed: 90 Minutes <\/span><\/p>\n

Max. Marks: 30<\/span><\/p>\n

Check Term 2 Sample Paper here<\/a><\/p>\n

General Instructions:<\/strong><\/em><\/span><\/p>\n

1. <\/strong><\/em>This Question Paper is divided into 03 sections, viz., Section A, Section B and Section C.<\/strong><\/em><\/span><\/p>\n

2. Section A is of 05 marks and has 06 questions on Employability Skills.<\/strong><\/em><\/span><\/p>\n

3. Section B is of 20 marks and has 25 questions on Subject specific Skills.<\/strong><\/em><\/span><\/p>\n

4. Section C is of 05 marks and has 07 competency-based questions.<\/strong><\/em><\/span><\/p>\n

 <\/p>\n

SECTION A<\/strong><\/span><\/p>\n

Answer any 5 questions out of the given 6 questions on Employability Skills (1 x 5 = 5 marks)<\/strong><\/span><\/p>\n

1. Active listening is important in workplace because if we actively listen to other <\/span>people (select the one which is not correct)<\/span><\/p>\n

a) they will be more interested in communicating with us.<\/span><\/p>\n

b) we can develop a long-term working relationship with others.<\/span><\/p>\n

c) we can easily identify challenges and difficulties others are facing and <\/span>provide solutions to it<\/span><\/p>\n

d) we will become more popular in the workplace. \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

2. Which of the following personality trait fall in the Big Five popular personality <\/span>classification:?<\/span><\/p>\n

a) Gregarious \u2713<\/strong><\/span><\/p>\n

b) Avoidant<\/span><\/p>\n

c) Borderline<\/span><\/p>\n

d) Obsessive<\/span><\/p>\n

 <\/p>\n

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

a) 70<\/span><\/p>\n

b) 4<\/span><\/p>\n

c) 45 \u2713<\/strong><\/span><\/p>\n

d) 65<\/span><\/p>\n

 <\/p>\n

4. What not to do during an interview<\/span><\/p>\n

a) Do take notes<\/span><\/p>\n

b) Let your achievements speak for you.<\/span><\/p>\n

c) Answer questions fast and use slangs.<\/span><\/p>\n

d) Ask questions \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

5. ________________Is a condition in which people seek excessive attention and <\/span>admiration and lack of empathy<\/span><\/p>\n

a) Paranoid<\/span><\/p>\n

b) Narcissistic \u2713<\/strong><\/span><\/p>\n

c) Antisocial<\/span><\/p>\n

d) Dependent<\/span><\/p>\n

 <\/p>\n

6. What will be displayed, if the following formula is entered in cell A1 in a <\/span>spreadsheet application <\/span><\/p>\n

= 6^2 + 15\/3 *2 \u2013 7<\/span><\/p>\n

a) 39 \u2713<\/strong><\/span><\/p>\n

b) 15<\/span><\/p>\n

c) -14<\/span><\/p>\n

d) -38<\/span><\/p>\n

 <\/p>\n

SECTION B<\/span><\/strong><\/p>\n

Answer any 20 questions out of the given 25 questions (1 x 20 = 20 marks)<\/span><\/strong><\/p>\n

7. Which of the following is a disadvantage of web based applications:<\/span><\/p>\n

a) They do not need be installed.<\/span><\/p>\n

b) They are available 24X7.<\/span><\/p>\n

c) They are slow as compared to software based applications. \u2713<\/strong><\/span><\/p>\n

d) They offer cross platform compatibility.<\/span><\/p>\n

 <\/p>\n

8. Internet transactions are susceptible to frauds. Creating a strong password is vital. <\/span>A strong password has:<\/span><\/p>\n

a) 6-8 Alphanumeric characters<\/span><\/p>\n

b) Special symbols<\/span><\/p>\n

c) Only numbers<\/span><\/p>\n

d) Both a and b \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

9. DEITY stands for:<\/span><\/p>\n

a) Department of Electrical and Information Technology<\/span><\/p>\n

b) Department of Electronics and Information Technology \u2713<\/strong><\/span><\/p>\n

c) Department of Electronics and Informatics Technology<\/span><\/p>\n

d) Department of Electrical and Informatics Technology<\/span><\/p>\n

 <\/p>\n

10. Which SQL keyword is used to display the data based on certain pattern?<\/span><\/p>\n

a) LIKE \u2713<\/strong><\/span><\/p>\n

b) IN<\/span><\/p>\n

c) BETWEEN<\/span><\/p>\n

d) RANGE<\/span><\/p>\n

 <\/p>\n

11. Sagun is creating a table SALESMAN with fields Salesman number, Name, Total <\/span>Sales. She doesn\u2019t want the Total Sales column to be remain unfilled i.e. she wants\u00a0<\/span>to make entry in this field mandatory. Which constraint she should use at the time\u00a0<\/span>of creating SALESMAN table:<\/span><\/p>\n

a) Check<\/span><\/p>\n

b) Default<\/span><\/p>\n

c) Not null \u2713<\/strong><\/span><\/p>\n

d) Primary key<\/span><\/p>\n

 <\/p>\n

12. Ranjana wants to delete the records where name starts with A from the table<\/span><\/p>\n

CUSTOMER having fields Name, Amount, Discount. Identify the correct command:<\/span><\/p>\n

a) Delete CUSTOMER where name like \u201cA%\u201d;<\/span><\/p>\n

b) Delete from CUSTOMER where name like \u201cA%\u201d; \u2713<\/strong><\/span><\/p>\n

c) Delete CUSTOMER where name = \u201cA%\u201d;<\/span><\/p>\n

d) Delete from CUSTOMER where name = \u201cA%\u201d;<\/span><\/p>\n

 <\/p>\n

13. Consider a table STAFF:<\/span><\/p>\n\n\n\n\n\n\n\n\n
Name<\/span><\/td>\nCity<\/span><\/td>\n<\/tr>\n
Akash\u00a0<\/span><\/td>\nMumbai<\/span><\/td>\n<\/tr>\n
Ajay\u00a0<\/span><\/td>\nChennai<\/span><\/td>\n<\/tr>\n
Banit<\/span><\/td>\nDelhi<\/span><\/td>\n<\/tr>\n
Fauzia\u00a0<\/span><\/td>\nMumbai<\/span><\/td>\n<\/tr>\n
Sakal\u00a0<\/span><\/td>\nChennai<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

Select the command which will count the number of people in each city.<\/span><\/p>\n

a) SELECT COUNT(City) , City FROM STAFF WHERE GROUP BY <\/span>City;<\/span><\/p>\n

b) SELECT COUNT(City) , City FROM STAFF GROUP BY City; \u2713<\/strong><\/span><\/p>\n

c) SELECT COUNT(City) , City FROM STAFF WHERE ORDER BY <\/span>City;<\/span><\/p>\n

d) SELECT COUNT(City) , City FROM STAFF ORDER BY City;<\/span><\/p>\n

 <\/p>\n

14. Consider the Table EMPLOYEE given below:<\/span><\/p>\n

Name Zone Age Dept<\/span><\/p>\n

Harit West 28 10<\/span><\/p>\n

Kritika Centre 30 10<\/span><\/p>\n

Naveen East 40 20<\/span><\/p>\n

Uday North 38 30<\/span><\/p>\n

Nupur East 24 20<\/span><\/p>\n

Moksh South 28 10<\/span><\/p>\n

Shelly North 24 30<\/span><\/p>\n

 <\/p>\n

Choose the correct query\/queries that will give the following output:<\/span><\/p>\n

Name<\/span><\/p>\n

Harit<\/span><\/p>\n

Kritika<\/span><\/p>\n

Moksh<\/span><\/p>\n

 <\/p>\n

i) Select Name from EMPLOYEE where DEPT in (10);<\/span><\/p>\n

ii) Select Name from EMPLOYEE where AGE between 25 and <\/span>30;<\/span><\/p>\n

iii) Select Name from EMPLOYEE where NAME like \u201c%i%\u201d;<\/span><\/p>\n

iv) Select Name from EMPLOYEE where ZONE in (\u201cWest\u201d, <\/span>\u201cCentre\u201d, \u201dSouth\u201d);<\/span><\/p>\n

Choose the correct option<\/span><\/p>\n

a) Only (i)<\/span><\/p>\n

b) Both (i) and (ii)<\/span><\/p>\n

c) Both (ii) and (iv)<\/span><\/p>\n

d) All (i), (ii) and (iv) \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

15. The ______________command is used to modify the structure of the table <\/span>STUDENT in MySQL.<\/span><\/p>\n

a) Modify table STUDENT<\/span><\/p>\n

b) Alter table STUDENT \u2713<\/strong><\/span><\/p>\n

c) Alter STUDENT<\/span><\/p>\n

d) Modify STUDENT<\/span><\/p>\n

 <\/p>\n

16. <\/span>Consider a table FACTORY:<\/span><\/p>\n

Reema wants to calculate the average production of the years 2008-2012. Help her <\/span>select the correct SQL command for it:<\/span><\/p>\n

a) SELECT AVERAGE(Production) from FACTORY;<\/span><\/p>\n

b) SELECT AVERAGE(Production) from FACTORY group by <\/span>Production;<\/span><\/p>\n

c) SELECT SUM(Production) from FACTORY;<\/span><\/p>\n

d) SELECT AVG(Production) from FACTORY; \u2713<\/strong><\/span><\/p>\n

YEAR Production<\/span><\/p>\n

2008 12000<\/span><\/p>\n

2009 10000<\/span><\/p>\n

2010 10600<\/span><\/p>\n

2011 15000<\/span><\/p>\n

2012 14500<\/span><\/p>\n

 <\/p>\n

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

a) india.gov.in \u2713<\/strong><\/span><\/p>\n

b) india.gov.org<\/span><\/p>\n

c) indian.gov.in<\/span><\/p>\n

d) indian.gov.org<\/span><\/p>\n

 <\/p>\n

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

a) snapdeal.com<\/span><\/p>\n

b) myntra.com<\/span><\/p>\n

c) coursera.org \u2713<\/strong><\/span><\/p>\n

d) infibeam.com<\/span><\/p>\n

 <\/p>\n

19. Garvit wants to change the default value of DISCOUNT in the CUSTOMER table <\/span>from 10 to 15. Select the most appropriate command to do the same from the\u00a0<\/span>following options:<\/span><\/p>\n

a) ALTER TABLE CUSTOMER ALTER DISCOUNT SET DEFAULT 15; \u2713<\/strong><\/span><\/p>\n

b) ALTER TABLE CUSTOMER DELETE DISCOUNT SET DEFAULT <\/span>15;<\/span><\/p>\n

c) ALTER TABLE CUSTOMER MODIFY DISCOUNT SET DEFAULT <\/span>15;<\/span><\/p>\n

d) ALTER TABLE CUSTOMER CHANGE DISCOUNT SET DEFAULT <\/span>15;<\/span><\/p>\n

 <\/p>\n

20. Consider a table: COACHING having fields CITY_NAME, ENROLMENTS. Shikhar <\/span>wants to display the data of the above table in ascending order of enrolments.<\/span><\/p>\n

Choose the correct query\/queries from the following:<\/span><\/p>\n

i) Select * from coaching order by enrolments asc;<\/span><\/p>\n

ii) Select * from coaching order by enrolments desc;<\/span><\/p>\n

iii) Select * from coaching order by enrolments;<\/span><\/p>\n

iv) Select * from coaching order by enrolments <\/span>ascending;<\/span><\/p>\n

 <\/p>\n

Select the correct option:<\/span><\/p>\n

a) Only (i) is correct<\/span><\/p>\n

b) Both (i) and (ii) are correct<\/span><\/p>\n

c) Both (i) and (iii) are correct \u2713<\/strong><\/span><\/p>\n

d) Only (iv) is correct<\/span><\/p>\n

 <\/p>\n

21. Geeta wants to know the usage of NULL in MySQL. Help her choose in which of the <\/span>following case NULL value cannot be assigned to the column Admission_Number:<\/span><\/p>\n

a) When the Admission_Number is zero \u2713<\/strong><\/span><\/p>\n

b) When the Admission_Number is not known<\/span><\/p>\n

c) When the Admission_Number is not available<\/span><\/p>\n

d) When the Admission_Number is not applicable<\/span><\/p>\n

 <\/p>\n

22. _________are real time lectures, where users participate, may ask <\/span>questions, and get their queries answered.<\/span><\/p>\n

a) Interactive tutorials<\/span><\/p>\n

b) Video tutorials<\/span><\/p>\n

c) Power Point Presentation<\/span><\/p>\n

d) Webinars \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

23. There are four main phases of development a Web Application Project.<\/span><\/p>\n

Statement 1: The scope of the application is decided in the first phase.<\/span><\/p>\n

Statement 2: The data connectivity is established between the Front-End interface <\/span>and Back-End Database in the implementation phase.<\/span><\/p>\n

Select the correct option:<\/span><\/p>\n

a) Only Statement 1 is correct<\/span><\/p>\n

b) Only Statement 2 is correct<\/span><\/p>\n

c) Both Statement 1 and Statement 2 are correct \u2713<\/strong><\/span><\/p>\n

d) None of the above statements are correct<\/span><\/p>\n

 <\/p>\n

24. Which of the following is NOT an advantage of DBMS approach:<\/span><\/p>\n

a) All the data is stored at one place. There is no repetition of the same data.<\/span><\/p>\n

b) There is a single copy of data that is accessed or updated by all the users.<\/span><\/p>\n

c) The DBA can provide security to the database by controlling users’ database <\/span>access rights.<\/span><\/p>\n

d) Designing the database specifications and writing application programs is a <\/span>time-consuming process. \u2713<\/strong><\/span><\/p>\n

 <\/p>\n

25. An attribute A of datatype varchar(20) has the value \u201cKeshav\u201d. The attribute B of <\/span>datatype char(20) has value \u201dMeenakshi\u201d. How many characters are occupied in\u00a0<\/span>attribute A and attribute B?<\/span><\/p>\n

a) 20,6<\/span><\/p>\n

b) 6,20 \u2713<\/strong><\/span><\/p>\n

c) 9,6<\/span><\/p>\n

d) 6,9<\/span><\/p>\n

 <\/p>\n

26. Consider the table \u2018empsal\u2019.<\/span><\/p>\n

ID Salary Dept<\/span><\/p>\n

Q101 54000 10<\/span><\/p>\n

Q103 67000 20<\/span><\/p>\n

Q105 75000 20<\/span><\/p>\n

Q109 NULL 30<\/span><\/p>\n

Read the following two commands carefully:<\/span><\/p>\n

i) select COUNT(salary) from empsal;<\/span><\/p>\n

ii) select COUNT(*) from empsal;<\/span><\/p>\n

Choose the correct option:<\/span><\/p>\n

a) Both i and ii will give the same output as 3.<\/span><\/p>\n

b) The output of i is 3 and the output of ii is 4. \u2713<\/strong><\/span><\/p>\n

c) Both i and ii will give the same output as 4.<\/span><\/p>\n

d) The output of i is 4 and the output of ii is 3.<\/span><\/p>\n

 <\/p>\n

27. Cardinality of a table is four and degree is three. If two columns and four rows are <\/span>added to the table what will be the new degree and cardinality of the given table:<\/span><\/p>\n

a) 5,8 \u2713<\/strong><\/span><\/p>\n

b) 3,4<\/span><\/p>\n

c) 8,5<\/span><\/p>\n

d) 4,3<\/span><\/p>\n

 <\/p>\n

28. Consider a table \u2018SCORE\u2019:<\/span><\/p>\n

ROLLNO NAME STREAM OPTIONAL<\/span><\/p>\n

1 Greesha Science 10<\/span><\/p>\n

2 Satish Commerce 30<\/span><\/p>\n

3 Teena NULL 20<\/span><\/p>\n

4 Yasmine Humanities 10<\/span><\/p>\n

5 Yashika Science 10<\/span><\/p>\n

5 Lalit Humanities 20<\/span><\/p>\n

Reema wants to display names of those students who have not been assigned any <\/span>stream. Help her select the correct query:<\/span><\/p>\n

a) Select name from SCORE where stream =NULL;<\/span><\/p>\n

b) Select name from SCORE where stream =null;<\/span><\/p>\n

c) Select name from SCORE where stream = \u201c \u201c;<\/span><\/p>\n

d) Select name from SCORE where stream is NULL;\u00a0\u2713<\/strong><\/span><\/p>\n

 <\/p>\n

29. Consider the table SCORE in Q28. Select the correct query from the options given <\/span>below to display the names of all streams only once.<\/span><\/p>\n

a) Select distinct stream from score; \u2713<\/strong><\/span><\/p>\n

b) Select distinct(stream) from score;<\/span><\/p>\n

c) Select unique stream from score;<\/span><\/p>\n

d) Select stream from score where stream = distinct;<\/span><\/p>\n

 <\/p>\n

30. Online reservation systems are advantageous both for the company providing <\/span>reservation services and for the consumer who uses the online reservation system\u00a0<\/span>for booking.<\/span><\/p>\n

i) User can read reviews posted by people while making choices during <\/span>reservation.<\/span><\/p>\n

ii) More man-power is required by providers to ensure smooth functioning.<\/span><\/p>\n

Choose the correct justification to the statement given above:<\/span><\/p>\n

a) Only i \u2713<\/strong><\/span><\/p>\n

b) Only ii<\/span><\/p>\n

c) Both i and ii<\/span><\/p>\n

d) Neither i nor ii<\/span><\/p>\n

 <\/p>\n

31. Reeta is going to her aunt\u2019s house to spend her vacations. To book her rail tickets <\/span>online she needs to create new account on the reservation portal. Which of the <\/span>following is NOT a correct step to do the same?<\/span><\/p>\n

a) Sign up on the reservation portal.<\/span><\/p>\n

b) Fill the registration form.<\/span><\/p>\n

c) The fields marked with a star (*) are optional. \u2713<\/strong><\/span><\/p>\n

d) Click the submit button after filling the form.<\/span><\/p>\n

 <\/p>\n

SECTION C<\/span><\/strong><\/p>\n

(COMPETENCY BASED QUESTIONS)<\/span><\/strong><\/p>\n

Answer any 5 questions out of the given 7 questions (1 x 5 = 5 marks)<\/span><\/strong><\/p>\n

32. Read the following statements carefully about E-governance<\/span><\/p>\n

i) It is the use of electronic tools for governance.<\/span><\/p>\n

ii) It has decreased the transparency in the system.<\/span><\/p>\n

iii) E-governance empowers the citizens socially and economically.<\/span><\/p>\n

iv) It enables citizens to access information after paying money.<\/span><\/p>\n

 <\/p>\n

Choose the correct option from the following:<\/span><\/p>\n

a) Both i and ii are correct<\/span><\/p>\n

b) Both ii and iii are correct<\/span><\/p>\n

c) Both i and iii are correct \u2713<\/strong><\/span><\/p>\n

d) Only iv is correct<\/span><\/p>\n

 <\/p>\n

33.<\/span>Consider a Table STORE shown below:<\/span><\/p>\n

Consider a table OWNER shown below:<\/span><\/p>\n

OwnerId OwnerName<\/span><\/p>\n

A145 Divyam Prakash<\/span><\/p>\n

B178 Neha Sultan<\/span><\/p>\n

D112 Gargi Chhabra<\/span><\/p>\n

Choose the correct query to display the number of employees present in Delhi and <\/span>Mumbai.<\/span><\/p>\n

 <\/p>\n

i) Select SUM(noofemployee), Location from STORE group <\/span>by location HAVING location in (\u201cDelhi\u201d,\u201dMumbai\u201d);<\/span><\/p>\n

ii) Select SUM(noofemployee), Location from STORE group <\/span>by location WHERE location in (\u201cDelhi\u201d,\u201dMumbai\u201d);<\/span><\/p>\n

iii) Select SUM(noofemployee), Location from STORE group <\/span>by location HAVING location =\u201cDelhi\u201d and <\/span>location=\u201dMumbai\u201d;<\/span><\/p>\n

iv) Select SUM(noofemployee), Location from STORE group <\/span>by location WHERE location =\u201cDelhi\u201d or<\/span><\/p>\n

location=\u201dMumbai\u201d;<\/span><\/p>\n

 <\/p>\n

Choose the correct option:<\/span><\/p>\n

a) Both i and ii<\/span><\/p>\n

b) Both ii and iii<\/span><\/p>\n

c) Both iii and iv<\/span><\/p>\n

d) Both i and iii \u2713<\/strong><\/span><\/p>\n

StoreId StoreName Location NoOfEmployee OpeningYear OwnerId<\/span><\/p>\n

S101 Libas Delhi 45 2007 A145<\/span><\/p>\n

S102 Life Style Mumbai 68 2000 B178<\/span><\/p>\n

S103 Vogue Mumbai 50 1999 B178<\/span><\/p>\n

S104 Pantaloon Chennai 78 2004 D112<\/span><\/p>\n

S105 Max<\/span><\/p>\n

Fashions<\/span><\/p>\n

Delhi 80 2020 A145<\/span><\/p>\n

 <\/p>\n

 <\/p>\n

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

a) Select storename, location, OpeningYear from store <\/span>where OpeningYear <\u201d2015\u201d; \u2713<\/strong><\/span><\/p>\n

b) Select storename, location, OpeningYear from store <\/span>where OpeningYear >\u201d2015\u201d;<\/span><\/p>\n

c) Select storename, location, OpeningYear from store <\/span>where OpeningYear =2015;<\/span><\/p>\n

d) Select storename, location, OpeningYear from store <\/span>where OpeningYear !=2015;<\/span><\/p>\n

 <\/p>\n

35. Consider the table STORE given in Q33. Radhika wants to add a new column SALE <\/span>on type integer to the table. Choose the correct query for the same:<\/span><\/p>\n

a) Add column SALE integer;<\/span><\/p>\n

b) Alter table add SALE integer;<\/span><\/p>\n

c) Alter table store add SALE integer; \u2713<\/strong><\/span><\/p>\n

d) Alter table store modify SALE integer;<\/span><\/p>\n

 <\/p>\n

36. Consider the table STORE and OWNER given in Q33. Seema wants to display <\/span>StoreName and OwnerName of all stores in Mumbai. Help her select the correct\u00a0<\/span>query from the options given below:<\/span><\/p>\n

a) Select StoreName, OwnerName from STORE, OWNER where <\/span>store.OwnerId=Owner.OwnerId or Location=\u201dMumbai\u201d;<\/span><\/p>\n

b) Select StoreName, OwnerName from STORE, OWNER where <\/span>store.OwnerId=Owner.OwnerId and Location=\u201dMumbai\u201d; \u2713<\/strong><\/span><\/p>\n

c) Select StoreName, OwnerName from STORE, OWNER where <\/span>Location=\u201dMumbai\u201d;<\/span><\/p>\n

d) Select StoreName, OwnerName from STORE, OWNER where <\/span>OwnerId=OwnerId and Location=\u201dMumbai\u201d;<\/span><\/p>\n

 <\/p>\n

37. Consider the table STORE given in Q33. Radhika wants to display the following <\/span>output:<\/span><\/p>\n

Store Id Store Name No Of Employee<\/span><\/p>\n

S101 Libas 45<\/span><\/p>\n

S102 Life Style 68<\/span><\/p>\n

 <\/p>\n

Choose the correct command:<\/span><\/p>\n

i) Select StoreId, StoreName, NoOfEmployee from STORE <\/span>where StoreId=102 or StoreId=101;<\/span><\/p>\n

ii) Select StoreId, StoreName, NoOfEmployee from STORE <\/span>where StoreName=\u201dLibas\u201d or StoreName=\u201dLife Style\u201d;<\/span><\/p>\n

iii) Select StoreId, StoreName, NoOfEmployee from STORE <\/span>where Location=\u201dDelhi\u201d or Location=\u201dMumbai\u201d;<\/span><\/p>\n

iv) Select StoreId, StoreName, NoOfEmployee from STORE <\/span>where StoreName like \u201dL%\u201d;<\/span><\/p>\n

 <\/p>\n

Choose the correct option:<\/span><\/p>\n

a) (i) and (ii) are correct<\/span><\/p>\n

b) (i), (ii) and (iii) are correct<\/span><\/p>\n

c) (i), (ii) and (iv) are correct \u2713<\/strong><\/span><\/p>\n

d) All are correct<\/span><\/p>\n

 <\/p>\n

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

a) Requirements Definition Phase \u2713<\/strong><\/span><\/p>\n

b) Testing Phase<\/span><\/p>\n

c) Implementation Phase<\/span><\/p>\n

d) Design Phase<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-1426","post","type-post","status-publish","format-standard","hentry","category-cbse-sample-papers-class-12"],"_links":{"self":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/comments?post=1426"}],"version-history":[{"count":0,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/posts\/1426\/revisions"}],"wp:attachment":[{"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/media?parent=1426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/categories?post=1426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cbsepython.in\/wp-json\/wp\/v2\/tags?post=1426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}