CBSE Class 12 Informatics Practices Sample Paper 2021 Set 02

CBSE Class 12 Informatics Practices Sample Paper 2021 Set B. CBSE issues sample papers every year for students for Class 12 board exams. Students should solve the CBSE issued sample papers to understand the pattern of the question paper which will come in class 12 board exams this year. The sample papers have been provided with marking scheme. It’s always recommended to practice as many CBSE sample papers as possible before the board examinations. Sample papers should be always practiced in examination condition at home or school and the student should show the answers to teachers for checking or compare with the answers provided. Students can download the sample papers in pdf format free and score better marks in examinations. Refer to other links too for latest sample papers. 

1. a) Consider the following table name "GARMENT". Write command of SQL from (i) to (iv) and output for (v) to (vii).

I. To display name of those garments that are available in 'XL' size

II. To display codes and names of those garments that have their names starting with 'Ladies'.

III. To display garment names, codes and prices of those garments that have price in the range 1000.00 to 1500.00 (both 1000.00 and 1500.00 included).

IV. To change the colour of the garment with code as 116 to "Orange".

V. SELECT COUNT(DISTINCT SIZE) FROM GARMENT

VI. SELECT AVG (PRICE) FROM GARMENT;

VII. SELECT GNAME FROM GARMENT WHERE SIZE IN ('M', 'L') AND PRICE>1500;

b) What is the degree and cardinality of 'Garment table'.

c) What is the transaction? Which command is used to make changes done by a transaction permanent]on a database?

2. a) Write MySQL command to create the Table 'LIBRARY' with given constraints.

Please click the link below to download CBSE Class 12 Informatics Practices Sample Paper 2021 Set B