单项选择题
You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
A. mount the new disk group in the ASM instance
B. restart the ASM instance and the production database instance
C. register the new disk groups in the production database instance
D. restart the ASM instance without restarting the production database instance
E. include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
相关考题
-
单项选择题
Exhibit， One of the important tables in the USERStablespace was dropped and purged from the recycle bin at 9：00 a.m. You noticed this at 11：00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true？（）
A. You must recover all data files to the required system change number （SCN）.
B. You must recover all data files， except those that are offline， to the required SCN.
C. You must recover all data files belonging to the USERS tablespace to the required SCN.
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace. -
单项选择题
Whiledesigningyourdatabase，youhavecreatedtheEMPLOYEEStableasanindex-organized（IOT）.YouwanttocreateabitmapindexontheJOD_IDcolumntomakequeriesfaster.Whichtaskmusthavebeencompletedsothatyouareabletocreatethebitmapindex？（）
A. A primary key must have been created.
B. A mapping table must have been created.
C. An overflow tablespace must have been specified.
D. The PCTTHRESHOLD option must have been specified. -
多项选择题
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN> RESTORE CONTROLFILE； Which two operations do you need to perform after restoring the control file from backup？（）
A. shut down and restart the instance
B. add new tempfiles to the temporary tablespaces after recovery
C. perform a media recovery and open the database with the RESETLOGS option
D. perform a media recovery and bring the database to NOARCHIVELOG mode
