PrepAway - Latest Free Exam Questions & Answers

What must be done to convert any existing DMS table spaces to automatic storage table spaces?

An existing non-automatic storage database named MYDB has been successfully converted
to an automatic storage database. What must be done to convert any existing DMS table
spaces to automatic storage table spaces?

PrepAway - Latest Free Exam Questions & Answers

A.
Execute the statement ALTER DATABASE mydb CONVERT TO AUTOMATIC
STORAGE IMMEDIATE.

B.
Execute the statement ALTER DATABASE mydb CONVERT TABLESPACES TO
AUTOMATIC STORAGE.

C.
Execute the ALTER TABLESPACE statement with the MANAGED BY STOGROUP
clause specified for each DMS table space that is to beconverted.

D.
Execute the ALTER TABLESPACE statement with the MANAGED BY AUTOMATIC
STORAGE clause specified for each DMS table space that isto be converted.


Leave a Reply