Exhibit:
Your Oracle 11g database has 6 tablespaces in which:
-TEMP is the default temporary tablespace
– UNDOTBS1 is the default undo tablespace
– USERS is the default permanent tablespace
In this database, which three tablespaces can be made offline? (Choose three.)
A.
TEMP
B.
PROD
C.
USERS
D.
SYSAUX
E.
SYSTEM
F.
UNDOTBS1
Image not showing
Image not relevant, as is the case for most questions on these tests. For this question specifically, you know which tables are undo and temp, so you’ve got two of the three mission critical tables. System is a default name so there’s your third. That means whatever is leftover can be disabled.
only those that are not critical can be disabled
DEFAULT, CRITICAL = NO DISABLE
DEFAULT UNTO MUST BE KEPT