CBSE Class 12 Informatics Practices Revision Assignment Set 04

INFORMATICS PRACTICES

WORK SHEET – II TERM

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