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？（）

A.make redo log files smaller
B.increase the size of the checkpoint file
C.make the changes as per the advice given by MTTR Advisor
D.make the changes as per the advice given by Checkpoint Advisor

单项选择题Youwantthesizeofthetablespacetoincreasewhenitisfull.Whichoptionwouldyouuse？（）

A.use automatic extent allocation
B.disable threshold for the tablespace
C.use freelists to manage the free space
D.use automatic segment space management
E.create the tablespace as a bigfile tablespace
F.use the RESIZE clause while creating the tablespace
G.enable AUTOEXTEND for at least one of the data files in the tablespace

单项选择题YourdatabaseisinNOARCHIVELOGmodeandalogswitchhappensevery20minutes.OnThursdaymorning，mediafailureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation？（）

A.recover using Oracle Flashback Database technology
B.restore the data files from backup and perform a complete recovery
C.restore only the corrupted data file and perform tablespace recovery
D.restore the data files from backup and perform cancel-based recovery
E.restore the entire database from the most recent backup and start the instance and open the database

多项选择题YourdatabaseisrunninginNOARCHIVELOGmode.YouwanttoputthedatabaseinARCHIVELOGmode.Whichtwostatementsregardingarchivelogdestinationsaretrue？（）

A.The destination must be global only.
B.A maximum of five destinations can be assigned.
C.A maximum of ten different destinations can be assigned.
D.All the destinations are determined by the server automatically.
E.The destination may be local or remote for a Standby Database.
F.The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

多项选择题Youstartedalongtransaction.Beforecommitting，youexecutedaqueryononeofthetablescurrentlybeingmodified.Youreceivedthefollowingerror：ORA-01555：snapshottoooldHowwouldyoupreventsuchanerrorinthefuture？（）

A.guarantee undo retention
B.add one more redo log group
C.size the redo log files appropriately
D.size the UNDO tablespace appropriately
E.size the SYSTEM tablespace appropriately
F.configure an appropriate undo retention interval
G.change automatic undo management to manual