#15. You create a new table named DEPARTMENTS by issuing this statement: CREATE TABLE departments( department_id NUMBER(4), department_name VARCHAR2(30), manager_id NUMBER(6), location_id NUMBER(4)) STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MINEXTENTS 1 MAXEXTENTS 5);
You realize that you failed to specify a tablespace for the table. You issue these queries: SQL> SELECT username, default_tablespace, TEMPORARY TABLESPACE 2> FROM user_users;
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
HR SAMPLE TEMP SQL> SELECT * FROM user_ts_quotas;
TABLESPACE_NAME BYTES MAX_BYTES BLOCKS MAX_BLOCKS
SAMPLE 28311552 -1 6912 -1
INDX 0 -1 0 -1
In which tablespace was your new DEPARTMENTS table created?
Show comments for this question (1)
Add comments
Link to this question
|
gen. 0.069
Forum
Master braindump