CBSE Class 12 Informatics Practices Worksheet - Revision (3)

Scroll down for PDF

CBSE Class 12 Informatics Practices Worksheet - Revision (3)

Chapter wise assignments are being given by teachers to students to make them understand the chapter concepts. Its extremely critical for all CBSE students to practice all assignments which will help them in gaining better marks in examinations. All assignments available for free download on the website are developed by the best teachers having many years of teaching experience in CBSE schools all over the country. Students, teachers and parents are advised to download the CBSE study material.

 

INTERNATIONAL INDIAN SCHOOL, RIYADH

INFORMATICS PRACTICES

WORK SHEET – II TERM

CLASS: XII

Q1:

Q2:

(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%”;

(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 Worksheet - Revision (3)

Tags: 


Click on the text For more study material for Informatics Practices please click here - Informatics Practices

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

CBSE DATE SHEET 2020

Central Board of Secondary Education, CBSE is to conduct the 10th and 12th Board Examination 2020 from February 15, 2020. Due to University Admissions, CBSE has shifted Board Exams dates from 1 March to February 15 from 2019. This year too CBSE would be making changes...

CBSE Board Secretary says Class 10 and 12 CBSE Exam Pattern to be modified

The Central Board of Secondary Education is expected to introduce a few changes to the exam pattern for class 10 and board exams by 2023. Anurag Tripathi, secretary of CBSE speaking at an Assoham School Education Summit said that although this year class 10 students...

Requirements for admissions in CBSE affiliated Schools

CBSE gives an advanced form of education. They try to indulge students in interactions and teach application based subjects along with some others. Due to this preponderance of parents, they tend to admit their children in CBSE affiliated schools. General conditions...

CBSE Circular Aryabhatta Ganit Challenge

For students with a keen interest in mathematics are now provided with a better opportunity to explore their knowledge. CBSE has announced to conduct an exam for the purpose of generating interest in maths among students. It is a trial to clarify the myth that...

Tips for exam preparation

Students often get nervous during their exams. The reason behind this nervousness is either a lack of confidence or a lack of preparedness. To overcome these fears students are advised to do their preparation in such a way that will retain their confidence. For this...

CBSE to launch 'Tamanna' aptitude test

Introduction: The poor decisive condition of students to pursue their subject of interest has been an area of concern. To the ease of which CBSE is to launch ‘Tamanna’. An aptitude test in order to provide a line of guidance to students of class 9th and 10th. What is '...

×
Studies Today