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.
Add a data file to the SMDtablespace.

B.
Add a data file to the temporarytablespace associated with the user HR.

C.
Resize the data file associated with the SMDtablespace to make it larger.

D.
Alter the data file associated with the SMDtablespace to grow automatically.

E.
Change the segment space management for the SMDtablespace to automatic.



Leave a Reply 0

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