单项选择题
YouareaDatabaseAdministratorwithTXGlobal.YouuseapasswordfiletoestablishremoteconnectionstotheHRdatabaseontheserverlocatedatthehomeoffice.Currently,twoactiveremotesessionsexisttothisdatabase.ThesesessionswereestablishedusingtheSYSDBAprivilegefromtheremotemachines.Youaccidentallydeletedthepasswordfile.Whatwillbetheconsequenceofthisaction?()
A.Boththesessionswillbekilled,andnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilege.
B.Boththesessionswillremainactive,butnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilege.
C.Boththesessionswillbekilled,butnewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilegewhenthedatabaserestarts.
D.Thedatabasewillcrash,andnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilegewhenthedatabaserestarts.
A.YouuseapasswordfiletoestablishremoteconnectionstotheHRdatabaseontheserverlocatedatthehomeoffice.Currently,twoactiveremotesessionsexisttothisdatabase.ThesesessionswereestablishedusingtheSYSDBAprivilegefromtheremotemachines.Youaccidentallydeletedthepasswordfile.Whatwillbetheconsequenceofthisaction?()
A.Boththesessionswillbekilled,andnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilege.
B.Boththesessionswillremainactive,butnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilege.
C.Boththesessionswillbekilled,butnewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilegewhenthedatabaserestarts.
D.Thedatabasewillcrash,andnonewsessionswillbecreatedusingtheSYSDBAorSYSOPERprivilegewhenthedatabaserestarts.