Sample Paper for Class 12 Informatics Practices 2021 Pdf
Students can refer to the below Class 12 Informatics Practices Sample Paper designed to help students understand the pattern of questions that will be asked in Grade 12 exams. Please download CBSE Class 12 Informatics Practices Sample Paper 2021 Set B
Informatics Practices Class 12 Sample Paper 2021
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
Books recommended by teachers
CBSE Class 12 Informatics Practices Sample Paper 2019 (1) |
CBSE Class 12 Informatics Practices Sample Paper 2019 (2) |
CBSE Class 12 Informatics Practices Sample Paper 2019 (3) |
CBSE Class 12 Informatics Practices Blue Print |