单项选择题
A.Coalesce the application tables at a regular interval.
B.Export and Import the application tables a regular interval.
C.Drop and recreate the application tables at a regular interval.
D.Move the application tables to a tablespace with less space usage.
E.Distribute the application tables across multiple tablespaces depending on usage.
F.Move the application tables to automatic segment space management tablespace.
多项选择题 Exhibit： View the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables. Your organization plans to dissolve the department with department ID 30. You execute the following command to delete rows from the DEPARTMENTS table： SQL>delete from DEPARTMENTS where DEPT_ID = 30； The command fails and displays the following error： ERROR at line 1： ORA-02292： integrity constraint （HR.SYS_C005374） violated - child record found Which two actions would you take to overcome this error？（）
单项选择题 Yourdatabaseperformancehasdegradedduetofrequentcheckpointing.Whatwouldyoudointhisscenario？（）
单项选择题 Youwantthesizeofthetablespacetoincreasewhenitisfull.Whichoptionwouldyouuse？（）