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)