["Constraint s \u2022 \u00d8SQL> create table tt(tno number constraint ctt not null,tname varchar(10)); Table created \u2022 SQL> alter table tt modify(tname constraint tt_cc not null); Table altered. SQL> create table nn(nno number constraint nncc PRIMARY KEY,nname varchar(10)); Table created. SQL> create table ss(sno number,sname varchar(10)); Table created. SQL> alter table ss modify(PRIMARY KEY(sno)); Table altered. \u2022 SQL> alter table ss add(constraint sscc check(sno<100)); Table altered","Constraint s \u2022 SQL> alter table ss add(cname varchar(10) default('B.D.S')); Table altered. \u2022 SQL> alter table ss add(studid number constraint stss unique); Table altered. \u2022 SQL> create table pt(name varchar(10),id number constraint pk PRIMARY KEY,sal number); Table created. \u2022 SQL> create table ct(sname varchar(10),id number constraint fk references pt(id)); Table created.","SUMMARY Understanding the Knowledge of Learners will be purpose, data Data Modelling ,data equipped with the models, and integrity skills and components of a ,constraints etc knowledge of DBMS DBMS."]
Search
