The IT Certification Resource Center

Featured Deal

Get CompTIA, Cisco, and Microsoft training courses free for a week.
Learn More ❯

Question 10:

Which of the following is the correct syntax for creating an UNDO tablespace?

A. CREATE TABLESPACE undotbs DATAFILE '/disk1/undo.dbf' SIZE 100 M
B. CREATE TABLESPACE undotbs DATAFILE '/disk1/undo.dbf' SIZE 100 M UNDO
C. CREATE UNDO TABLESPACE undotbs DATAFILE '/disk1/undo.dbf' SIZE 100 M
D. CREATE UNDOTABLESPACE undotbs DATAFILE '/disk1/undo.dbf' SIZE 100 M