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.
USERS
B.
UNDOTBS1
C.
SYSAUX
D.
TEMP
E.
SYSTEM
F.
PROD
A,B,F
SYSTEM ans SYSAUX must be always online
Hello, have you taken 1z0-052 exams and were these questions helpful to you?
You can make the SYSAUX tablespace offline. This is if you wish to make the tablespace unavailable. If you make the sysaux tablespace offline then you will not be able to use the features that uses this tablespace.
#amina if you dont know, then please dont miss guide people.
thanks
You cannot take the following tablespaces offline:
SYSTEM
The undo tablespace
Temporary tablespaces
Before taking a tablespace offline, consider altering the tablespace allocation of any users who have been assigned the tablespace as a default tablespace. Doing so is advisable because those users will not be able to access objects in the tablespace while it is offline.