1CREATE DATABASE numismatics; /*+ MODE = TRANSACTIONAL */ 2 3CREATE TABLE coin (cid INT(8) PRIMARY KEY, 4 unit VARCHAR2(20), 5 value NUMERIC(8,2), /*+ MODE = TRANSACTIONAL */ 6 mintage_year INT(8), 7 mint_id INT(8), 8 CONSTRAINT mint_id_fk FOREIGN KEY(mint_id) 9 REFERENCES mint(mid)); 10 11CREATE INDEX unit_index ON coin(unit); 12 13CREATE TABLE mint (mid INT(8) PRIMARY KEY, 14 country VARCHAR2(20), 15 city VARCHAR2(20)); /*+ MODE = TRANSACTIONAL */ 16 17CREATE INDEX mid_index ON mint(mid); 18 19CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY, 20 chunk bin(127)); 21 22CREATE TABLE table1 (att_int INT(8) PRIMARY KEY, 23 att_char CHAR(20), 24 att_varchar VARCHAR(20), 25 att_bit BIT, 26 att_tinyint TINYINT, 27 att_smallint SMALLINT(2), 28 att_integer INTEGER(4), 29 att_bigint BIGINT, 30 att_real REAL, 31 att_double DOUBLE, 32 att_float FLOAT, 33 att_decimal DECIMAL, 34 att_numeric NUMERIC, 35 att_bin bin(5)); 36 37CREATE TABLE table2(att_int INT(8) PRIMARY KEY); 38 39CREATE TABLE table3(att_char CHAR(20) PRIMARY KEY); 40 41CREATE TABLE table4(att_bin bin(10) PRIMARY KEY); 42 43CREATE TABLE table5(att_bin bin(10) PRIMARY KEY, 44 att_bit BIT); 45 46CREATE TABLE table6(att_bin bin(10), 47 att_bit BIT PRIMARY KEY); /*+ MODE = TRANSACTIONAL */ 48