ExaminetheseattributesfortheprofileassignedtoUSER1whosepasswordisoracle_4U. •PASSWORD_REUSE_MAXis5. •PASSWORD_REUSE_TIMEis10. •PASSWORD_GRACE_TIMEis15. WhichtwoconditionsmustbemetforUSER1toreuse
EachrowintheTRANS_SUMMARYtablecontainsdetailsofoneproduct. EachrowintheTRANS_MONTHLYtablecontainstransactiondetailseitherfornewproductsorfor updatestoexistingproducts. Thereisamonthlyrequirementt
Examinethesecommandsandtheiroutput: SQL>SELECT*FROMemp; ENOENAME ---------- 100Adam 101Alan SQL>INSERTINTOempVALUES(102,'Ben'); 1rowcreated. SQL>COMMIT; Commitcompleted. S
USER1.EMPhasareferentialintegrityconstraintdefinedonEMP.DNOthatreferencesUSER1.DEPT.DNO. USER1executesthesecommands: SQL>UPDATEdeptSETloc='UK'wheredno=1; 1rowupdated. SQL>UPDATEemp
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号