SMD is a smallfile locally managed tablespace with manual segment space management.
The SH user receives the following error while inserting data into the sales table:
Which three actions can be taken to enable the user to insert data? (Choose three.)
A.
altering the data file associated with the SMD tablespace to grow automatically
B.
adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of
file
C.
changing segment space management for the SMD tablespace to automatic
D.
resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not
yet reached their maximum size
E.
increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached
their maximum size
I think the correct answers should be A, B, and D. When you encounter error ORA-01653, you can:
– add one or more datafile
– resize the datafile
– enable AUTOEXTEND