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

Database

ii3
By
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

Create multiple-choice games on Wisc-Online and play them on our Chakalaka mobile app!

But that's not all! Explore educational games created by others. Simply search by category or enter agame code number and dive into a world of learning and fun.

Download the Chakalaka mobile app here:
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