Oracle 11G OCP 1Z0-052 150

（150）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 SMD tablespace.

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

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

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

E. Change the segment space management for the SMD tablespace to automatic. n segments is managed through free lists.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1224830/，如需轉載，請註明出處，否則將追究法律責任。