多项选择题
A. ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;
B. ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;
C. ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;
D. ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;
E. ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;
F. ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;
单项选择题 YouaremaintainingyourOLTPdatabaseinOracle10g.YouhavenotsetthewarninglevelandcriticallevelthresholdvaluesforspaceusageoftheDATA1tablespace.Whatwillbetheimpact?()
单项选择题 You issued the following statement to monitor the usage of the index: SQL> ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE; Which view will you query to ensure that the index is being monitored?()
单项选择题 You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session: ALTER SESSION ENABLE RESUMABLE; Which command could you issue to enable the resumable space allocation feature at the session level?()