Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
-- Question 3
CREATE TABLE table_name ( a NUMBER, b NUMBER );
ALTER TABLE table_name RENAME TO other_name;
DROP TABLE other_name;
-- Question 4
CREATE TABLE table_name ( a NUMBER, b NUMBER );
ALTER TABLE table_name DROP ( a, b );
ORA-12983: cannot drop all columns in a table

DROP TABLE table_name;
-- Question 5
CREATE TABLE table_name ( a NUMBER CONSTRAINT qu5__pk PRIMARY KEY, b NUMBER );
INSERT ALL
  INTO table_name ( a, b ) VALUES ( 1, 1 )
  INTO table_name ( a, b ) VALUES ( 1, 2 )
SELECT * FROM DUAL;
ORA-00001: unique constraint (FIDDLE_VTYEZQMROXUQFKAFUSVZ.QU5__PK) violated

ALTER TABLE table_name MODIFY PRIMARY KEY DISABLE;
INSERT ALL
  INTO table_name ( a, b ) VALUES ( 1, 1 )
  INTO table_name ( a, b ) VALUES ( 1, 2 )
SELECT * FROM DUAL;
2 rows affected

DROP TABLE table_name;
-- Question 6
CREATE TABLE table_name ( a NUMBER, b NUMBER );
ALTER TABLE table_name READ ONLY;
INSERT INTO table_name ( a, b ) VALUES ( 2, 2 );
ORA-12081: update operation not allowed on table "FIDDLE_VTYEZQMROXUQFKAFUSVZ"."TABLE_NAME"

UPDATE table_name SET b = 2;
ORA-12081: update operation not allowed on table "FIDDLE_VTYEZQMROXUQFKAFUSVZ"."TABLE_NAME"

DELETE FROM table_name;
ORA-12081: update operation not allowed on table "FIDDLE_VTYEZQMROXUQFKAFUSVZ"."TABLE_NAME"