Examine the syntax for creating a DEPARTMENT table:

CREATE TABLE department(

Deptno NUMBER(4),

Dname VARCNAR2(30),

mgr NUMBER(6),

Loc NUMBER(4))

STORAGE(INITIAL 200K NEXT 200K

PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 5)

TABLESPACE userdata;

What is the size defined for the fifth extent?

Keep practicing — related questions

• The storage parmeters for a given table are: INITIAL=100, NEXT=100, MINEXTENTS=2, MAXEXTENTS=10, PCTINCREAS...
• The storage parmeters for a given table are: INITIAL=100, NEXT=100, MINEXTENTS=2, MAXEXTENTS=10, PCTINCREAS...
• CREATE TABLE dept(deptno NUMBER(2),dname VARCNAR2(14),1oc VARCNAR2 (13));ROLLBACK;DESCRIBE DEPTWhat is true...
• How many ways are there to create a table?
• how many size categories are available in tables?
• What is the TCODE to create a Table?
• Create table employee salary (empid int, fname varchar (30), lname varchar (30), dept varchar (30), salary ...
• A tablespace has a table with 30 extents in it. Is this bad?