CS404 T09a

CREATE EMP (empno, ename);

CREATE TABLE EMP (empno NUMBER, ename VARCHAR2(20));

CREATE TABLE EMP VALUES (empno, ename);

NEW TABLE EMP (empno NUMBER, ename CHAR);

REMOVE

DELETE

TRUNCATE

DROP

The table structure is deleted

All data is removed but the table remains

The table is locked

Only the first row is deleted

256

1000

2000

4000

PRIMARY KEY empno

CONSTRAINT pk_emp PRIMARY KEY (empno)

PRIMARY (empno)

CONSTRAINT PRIMARY KEY (empno)

CHECK salary < 10000

CHECK (salary > 0)

CHECK salary IS NOT NULL

CHECK (salary = 'HIGH')

Deletes the project column from emp

Deletes the entire emp table

Renames the column

Converts column type

INSERT INTO DEPT VALUES (50, 'NEW YORK');

INSERT INTO DEPT (deptno, loc) VALUES (50, 'NEW YORK');

INSERT VALUES INTO DEPT (50, 'NEW YORK');

INSERT INTO DEPT SET deptno = 50, loc = 'NEW YORK';

9999.99

999.99

99.99

9.9

The table is deleted, and dependent constraints are kept

The table is dropped without warning

Oracle raises an error and prevents the table from being dropped

The related foreign keys are turned into NULLs