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

SMD is a smallfile locally managed tablespace with manual segment space management.
The SH user receives the following error whi le inserting data into the s a les 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

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.