This website uses cookies to ensure you get the best experience on our website. Privacy Policy OK

BP2- Create - Alter

| See more in Career Skills


Created Date 08.22.20
Last Updated 08.25.20
Viewed 10 Times
Your browser doesn't support HTML5. System.Collections.Generic.List`1[System.String] System.Collections.Generic.List`1[System.String]
submit to reddit

Would you like to build your own game?

It's easy!

Go to the GameBuilder and get started!

Topics of this game:
  • create table t1 ( a1 number(2) primary key, a2 nvarchar(10) not null, a3 timestamp not null);
  • create table t1 ( a1 char(5) primary key, a2 nvarchar(10) not null primary key, a3 date not null);
  • alter table t1 add a1 number(3) ;
  • alter table t1 drop column a1;
  • drop column a1 from table t1;
  • add column a1 to table t1;
  • delete table t1;
  • create table t1 ( a1 char(10), a2 number(5), a3 date unique, constraint t1_pk primary key (a1));
  • create table t1 ( a1 number(2), a2 nvarchar(10) unique, a3 timestamp);
  • alter table t1 modify a1 char(10);
  • change a1 to char(10);
  • alter table t1 add a1 timestamp;
  • alter table t1 add constraint c1 foreign key references t2 (a2);
  • add constraint unique to table t1;
  • alter table drop unique;
  • 4
  • 6
  • 7
  • 8
  • 9