Prev Question
Next Question

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:

5a4b9715354e3 - Which three actions can be taken to enable the user to insert data?

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

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *