PrepAway - Latest Free Exam Questions & Answers

What is the recommended way to convert the database MYD…

A database named MYDB was created as follows: CREATE DATABASE mydb AUTOMATIC STORAGE NO
What is the recommended way to convert the database MYDB to an automatic storage database?

PrepAway - Latest Free Exam Questions & Answers

A.
Use the ALTER DATABASE statement to add storage paths to the database.

B.
Use the CREATE STOGROUP statement to define a new storage group in the database and to assign
storage paths to the new storage group.

C.
Use the UPDATE DATABASE CONFIGURATION command to change the AUTOMATIC STORAGE
configuration parameter for the database to YES.

D.
Use the DROP DATABASE command to drop the database; then, recreate the database by executing a
CREATE DATABASE command statement that does not contain the AUTOMATIC STORAGE NO option.


Leave a Reply