CBSE Class 12 Informatics Practices Question Paper 2022 Set A

CBSE Class 12 Informatics Practices Question Paper 2022 Set A. Students can download the last year board exams question papers using the link below. Free download of examination question papers with solutions. Last 10 year question papers should be practised to get better marks in examinations.

1. Consider the tables given below and answer the question :

i) What output will you get when an equi join query is executed to get book name from the book table andcust_name from the table issue?

ii) Display book_name , cust_name , publisher and price of the books

iii) Display book_name and cust_name whose price in within the range 400 to 700 in descending order of book name

iv) Increase the price of all the books by 20%

v) Identify the primary key and foreign key in the table Issue

vi)Write command to add a new column named Cust_addr in table ISSUE of type varchar(30)

vii) Check the field Book_Id of both the tables, find if there is any descrepency or not. If yes write the reason.

viii) What is the degree and cardinality of cross join (Cartesian product ) ofboth the tables?

2. Seema works for a Sports company. She wants to create controls on a form for the following functions. Choose appropriate controls from Text Field, Label, Radio Button, Check box, List,

Combo Box, Button and write in the third column.

Please click the link below to download pdf file of CBSE Class 12 Informatics Practices Question Paper 2022 Set A