#224. User Mary was created using this CREATE USER statement: CREATE USER mary IDENTIFIED BY lamb QUOTA 15M ON user_data01 QUOTA 10M ON SYSTEM QUOTA 0 ON user_data02 QUOTA UNLIMITED ON hr TEMPORARY TABLESPACE temp; GRANT CREATE ANY TABLE TO mary
/ Mary used this statement to create the EMPLOYEE table: CREATE TABLE employee( employee_id NUMBER(9), first_name VARCHAR2(30), last_name VARCHAR2(30), STORAGE(INITIAL 100K NEXT 100K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 10);
In which tablespace was the EMPLOYEE table created?
Show comments for this question (1)
Add comments
Link to this question
|