CBSE Class 12 Informatics Practices Revision Assignment Set D





Q1: (a)Which commands in MySql is used to make any Database current Database and see the list of table in that data base?

(b) What do you mean by table level constraint and column level constraints? Give example for that.

(c) How primary key in a table is different from unique key constraint?

(d) What is the purpose of following query statements. Write output.

Select round(4325.7869,2);

Select truncate(4325.7869,2);

(e) What is the difference between Group by and Order by clause?

(f) A table Alpha contains 4 records and table Beta contains 7 records what will be total number of records in their Cartesian product?

(g) Write SQL statement to add a column regno of data type varchar in a table Candidate which is primary key?

(h) Mrs Hetal, a database administrator created a table Voters in which she has used nationality as column name and by mistake she has entered nationality as Gujarat. Now she wants to change all the values from Gujarati to Indians using single statement. Help her to do the following by writing statement.

(i) What will be the query output for the following statement. Write in words/sentence.

(a) SELECT * from SCHOOL where sname like “_ _ _ SURAT”;

(b) SELECT * from SCHOOL where sname like “DC%”;


Q2: (a) What is the difference between drop and delete table command?

(b) What are different commands used in Transaction in MySql?


Please click the below link to access CBSE Class 12 Informatics Practices Revision Assignment Set D



Click to View or Download pdf file
Click for more Informatics Practices Study Material

Latest NCERT & CBSE News

Read the latest news and announcements from NCERT and CBSE below. Important updates relating to your studies which will help you to keep yourself updated with latest happenings in school level education. Keep yourself updated with all latest news and also read articles from teachers which will help you to improve your studies, increase motivation level and promote faster learning

NEP Transforming India Quiz

As a part of Shikshak Parv celebration, an online quiz competition on National Education Policy 2020 will be organized by the Ministry of Education, Govt. of India, from 5 th September to 25th September 2020 in order to create awareness about NEP among all stakeholders...

Online Teacher Training Course on Competency based Education in DIKSHA

Competency is a set of skills, abilities, knowledge that helps an individual perform a given task in real life. Every learning should go into the imbibing of these skills to lead a productive and joyful life. The NATIONAL EDUCATION POLICY-2020 calls for shift towards...

Training of CBSE School Teachers on Olabs

Training of CBSE School Teachers on Olabs in collaboration with C-DAC Mumbai: OLabs is a platform jointly developed by the Ministry of Electronics and Telecommunications, Government of India, CDAC, and Amrita University to facilitate a virtual experience of CBSE...

Keep your kids engaged during Lockdown

Kids are the Future of our Country! Outlines have changed and so should the formats of existence! It is the best time to teach our kids the pleasure of Self-Discipline, Self-Realization and Self-Control. To keep the future generation safe in such unpredictable...

Conduct of the practical work during the lockdown

CBSE has advised schools to follow the Alternative Calendar developed by NCERT to continue education during the lockdown through alternative modes to achieve learning outcomes. Schools have reportedly started using these calendars and other prescribed pedagogical...

National Online Painting Championship

The National Mission for Clean Ganga, Ministry of Jal Shakti in collaboration with Kalantar Art Trust is organizing KALANTAR-2020: National Online Painting Championship with the aim to provide a platform to youth and school children to demonstrate their artistic skills...

Studies Today