未知题型
YouaretheDatabaseAdministrator(DBA)ofyourcompany.YouexecutethefollowingstatementonanOracle10ginstance:SQL>ALTERSYSTEMSWITCHLOGFILE;Whichtwotasksareperformedwhenthestatementisexecuted?()
- A.TheDBWnprocesswritestothedatafile.
B.Changesinthebackgroundprocessarerecorded.
C.ThelogfileisupdatedwiththecurrentSCNnumber.
D.TheSystemChangeNumber(SCN)isrecordedinthecontrolfile.
E.Thechangestothelistenerconfigurationinthelistener.orafilearerecorded.
A, D
相关考题
-
未知题型
WhichtwostatementsaretrueabouttherolesintheOracledatabase?()
A.Arolecanbegrantedtoitself.
B.RolesareownedbytheSYSuser.
C.Rolescanbegrantedtootherroles.
D.Arolecannotbeassignedexternalauthentication.
E.Arolecancontainbothsystemandobjectprivileges. -
未知题型
InwhichsituationswilltheASMmetadatabackuphelpyourecovertheASMdiskinadiskgroup?()
A.whenoneormorefiledirectorypathsareaccidentallydeletedfromanASMdiskgroup
B.whenoneofthedisksinadiskgroupisaccidentalyunplugged
C.whenthedatafileonanASMdiskgroupgetscorrupted
D.whenoneormoredisksinanASMdiskgrouparelost -
未知题型
Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication,theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective?()A.usetheALTERSYSTEMcommandtochangethetimezoneB.usetheALTERSESSIONcommandtochangethetimezoneC.usetheALTERDATABASEcommandtochangethetimezoneD.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachineE.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine
A.Foroneapplication,theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective?()
A.usetheALTERSYSTEMcommandtochangethetimezone
B.usetheALTERSESSIONcommandtochangethetimezone
C.usetheALTERDATABASEcommandtochangethetimezone
D.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachine
E.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine
