CBSE Class 12 Informatics Practices Sample Paper 2021 Set B

Read and download PDF of CBSE Class 12 Informatics Practices Sample Paper 2021 Set B designed as per the latest curriculum and examination pattern for Class 12 issued by CBSE, NCERT and KVS. The latest Class 12 Informatics Practices Sample Papers have been provided with solutions so that the students can solve these practice papers and then compare their answers. This will help them to identify mistakes and improvement areas in Informatics Practices Standard 12 which they need to study more to get better marks in Grade 12 exams. After solving these guess papers also refer to solved Class 12 Informatics Practices Question Papers available on our website to build strong understanding of the subject

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).

Class 12 Informatics Practice SamplePaper 2021 Set B

 

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.

 Class 12 Informatics Practice SamplePaper 2021 Set B1

 

b) In a Database Company, there are two tables given below:
CBSE-Class-12-Informatics-Practices-Sample-Paper-2021-Set-B 1
 

CBSE-Class-12-Informatics-Practices-Sample-Paper-2021-Set-B 2

 

 

 

Write SQL queries for the following:

 

I. To display SalesmanID, names of salesman, LoactionID with corresponding location names. 

 

II. To display names of salesman, sales and corresponding location names who have achieved Sales more than 130000. 

 

III. To display names of those salesmen who have 'SINGH' in their names.

 

 IV. Identify Primary key in the table SALES. Give reason for your choice.

 

 V. Write a SQL command to change the LocationID to 104 of the Salesman with 


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


Books recommended by teachers

More Study Material