black

1Z0-042

登录

多项选择题

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?()

A.A
B.B
C.C
D.D
E.E
F.F

相关考题

单项选择题 Yourdatabaseperformancehasdegradedduetofrequentcheckpointing.Whatwouldyoudointhisscenario?()

单项选择题 Youwantthesizeofthetablespacetoincreasewhenitisfull.Whichoptionwouldyouuse?()

单项选择题 YourdatabaseisinNOARCHIVELOGmodeandalogswitchhappensevery20minutes.OnThursdaymorning,mediafailureresultedincorruptionofadatafilebelongingtotheTOOLStablespace.BackupsaretakenoneverySunday.Whatwouldyoudointhissituation?()

All Rights Reserved 版权所有©考试题库网(kstiku.com)

备案号:湘ICP备14005140号-3

经营许可证号:湘B2-20140064