PrepAway - Latest Free Exam Questions & Answers

What must be done to convert any existing DMS table spa…

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 be converted.

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


Leave a Reply