informative practices

Question

Write the names of any two DBMS.                                                           (¹/2+¹/2= I)

(b) Seema has created a table CUSTOMER with the following specifications. (1+1+2)

Attibute	Datatype	Length
CN0.	Varchar	3
CName	Varchar	10

The SQL command given below gives an error. Why ?

INSERT INTO CUSTOMER <!--[if gte vml 1]> <![endif]--> "K.V.S. NARAYAN");

What suggestion will you give to Seema to insert the data given below:

CN0.	CName
01	K.V.S. NARAYAN

(c)         Is select a DDL or DML. Justify. (1)

(d)         Consider the table TEACHER given below<!--[if gte vml 1]> <![endif]-->

Teacher ID	Teacher Name	Subject	Designation	Dt_of_App
011 012 013 015 016 017	Gurjeet Sonia Sakshi Arushi Sangeeta Minal Rajesh	Science Hindi English Hindi Science English Maths	TGT TGT PGT TGT TGT TGT PGT	2009-07-01 2010-07-02 2011-01-01 2013-06-05 2000-02-01 1996-05-10 1995-07-10

(4)          To display the subjects taught by the teachers. (subjects should not be repeated)       (1)

(5)          To display the names and subject of teachers who joined after 1st July

2010.