Sumita Arora XII Structured Query Language

char(2) DEFAULT = ‘E1’ ); Check: This constraint limits values that can inserted into a column of table. For eg , CREATE TABLE employee (e code integer NOT NULL PRIMARY KEY, ename char(20),Sex char(2 ) , Grade char(2) DEFAULT = ‘E1’, Gross decimal CHECK (gross > 2000 ); 5. Ans. Compare DISTINCT and ALL keywords when used with SELECT ... ................
................

In order to avoid copyright disputes, this page is only a partial summary.