1CREATE DATABASE numismatics; /*+ MODE = TRANSACTIONAL */ 2 3CREATE TABLE coin (cid INT(8) PRIMARY KEY, 4 unit VARCHAR2(20), 5 value NUMERIC(8,2), 6 mintage_year INT(8), 7 mint_id INT(8), 8 CONSTRAINT mint_id_fk FOREIGN KEY(mint_id) 9 REFERENCES mint(mid)); --+ MODE = TRANSACTIONAL 10 11CREATE TABLE mint (mid INT(8) PRIMARY KEY, 12 country VARCHAR2(20), 13 city VARCHAR2(20)); --+ MODE = NONTRANSACTIONAL 14 15CREATE INDEX coin_index ON coin(unit); 16 17CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY, 18 chunk bin(127)); /*+ MODE = NONTRANSACTIONAL */ 19