A. Automatic memory management is disabled because PGA_AGGREGATE_TARGET and SGA_TARGET are not set
B. The instance is started but the database will not be opened until PGA_AGGREGATE_TARGET and SGA_TARGET are set
C. The database is opened but users cannot perform transactions until PGA_AGGREGATE_TARGET and SGA_TARGET are set
D. Automatic memory management is enabled and, as per policy, 60% of the memory for System Global Area (SGA) and 40% of the memory for Program Global Area (PGA) will be distributed at startup
第1题:
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT:SQL>DESCV$FLASHBACK_DATABASE_STATNameNull?Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue?()
A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.
B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.
C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.
D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.
E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.
第2题:
You enabled an audit policy by issuing the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;For which database users and for which executions is the audit policy now active? ()
A. SYS, SYSTEM
B. SCOTT
C. Only for successful executions
D. Only for failed executions
E. Both successful and failed executions
第3题:
A.selectfile->Database->newandgiveitafilenameof“blank.nsf”
B.selectfile->Database->new,chooselocalastheserver,andchosetheblanktemplate
C.selectfile->Database->new,chooselocalastheserver,andchosethedefault.ntftemplate
D.selectfile->Database->new,giveitafilenameof“blank.nsf”,andchosetheblanktemplate
第4题:
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention?()
A.V$FLASHBACK_DATABASE_LOG
B.V$FLASHBACK_DATABASE_STAT
C.V$DATABASE
D.V$UNDOSTAT
第5题:
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements:SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;For which database users is the audit policy now active?()
A. All users except SYS
B. All users except SCOTT
C. All users except sys and SCOTT
D. All users except sys, system, and SCOTT
第6题:
Anadministratorisplanningaclusterrunningapplicationsin3separateresourcegroups.RGA-Database1RGB-WebServerRGC-Database2Database1andDatabase2mustbeonlinebeforetheWebServer.AllresourcegroupshaveaStartupPolicyofOnlineonHomeNodeOnly.Whichofthefollowingwillensurethattheresourcegroupsareprocessedinthecorrectorder?()
A.SettheSerialAcquisitionOrder
B.SettheParallelAcquisitionOrder
C.ConfigureOnlineontheSameNodeDependency
D.ConfigureOnlineonDifferentNodesDependency