Which three action would allow the user to insert data?

The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace.
Which three action would allow the user to insert data? (Choose three.)

The user HR receives the following error while inserting data into the TTK table:
ERROR at line 1:
ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD
Upon investigation, you find that SMD is a small file tablespace.
Which three action would allow the user to insert data? (Choose three.)

A.
Change the segment space management for the SMD tablespace to automatic.

B.
Add a data file to the SMD tablespace.

C.
Alter the data file associated with the SMD tablespace to grow automatically.

D.
Add a data file to the temporary tablespace associated with the user HR.

E.
Resize the data file associated with the SMD tablespace to make it larger.



Leave a Reply 1

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


mr_tienvu

mr_tienvu

I choose BCE